Automatically translated.View original post

Excel Data Mast

24.7K followers

Follow

Follow

Follow

1/2

6 saved

5

📍 Changing the name of Sheet in Excel

📌 renaming Sheet in Excel.

# creatorsearchinsights # exceltips # Excel # SME # viral

2025/12/17 Edited to

นอกจากวิธีเปลี่ยนชื่อ Sheet ที่แนะนำไปแล้ว ผมขอแนะนำทริคเล็กๆ ที่ช่วยให้การจัดการ Sheet ใน Excel มีประสิทธิภาพมากขึ้น เช่น การตั้งชื่อ Sheet ให้สื่อความหมายตรงกับเนื้อหาของตารางข้อมูล จะช่วยให้เราค้นหาและทำงานได้เร็วขึ้นมาก สำหรับใครที่ต้องการเปลี่ยนชื่อ Sheet หลายๆ แผ่นงานพร้อมกัน ผมแนะนำให้ใช้ VBA มาเป็นตัวช่วย เพราะจะประหยัดเวลามากกว่าการเปลี่ยนชื่อทีละแผ่น วิธีนี้จะเหมาะกับงานที่มี Sheet เยอะและต้องเปลี่ยนชื่อเป็นรูปแบบเดียวกัน เช่น รายเดือน หรือแยกตามประเภทสินค้า อีกหนึ่งเคล็ดลับที่อยากแชร์คือ การใช้เมนูคลิกขวาแล้วเลือก Rename ที่สะดวกและเข้าใจง่าย เหมาะกับผู้เริ่มต้นใช้งาน Excel นอกจากนี้ ควรหลีกเลี่ยงการตั้งชื่อที่ยาวเกินไปหรือมีสัญลักษณ์พิเศษ เพราะอาจทำให้เกิดข้อผิดพลาดหรือไม่สามารถใช้งานสูตรบางอย่างได้ ผมเองก็ได้เรียนรู้ว่าการตั้งชื่อ Sheet ให้สอดคล้องกับข้อมูลเป็นสิ่งสำคัญสำหรับการทำงานกับ Excel ให้ราบรื่นและไม่สับสนเวลามองย้อนกลับมาภายหลัง ลองนำเทคนิคเหล่านี้ไปใช้ดู แล้วจะรู้สึกว่างาน Excel ของคุณง่ายและมืออาชีพขึ้นอย่างแน่นอน!

Related posts

A tablet displays an Excel wedding budget spreadsheet on a desk with notes and a planner. The image is titled 'Stop Struggling with Excel Learn These Super Easy Formulas'.

This image details core Excel calculation formulas: SUM, AVERAGE, MIN, and MAX. Each function is explained with an example Excel table showing its application and purpose.

This image explains Excel's reference formulas, VLOOKUP and HLOOKUP. It provides examples with tables demonstrating how to search and retrieve data vertically and horizontally, along with usage tips.

Excel shortcuts every student should know! 👩🏻‍💻

Stop Wasting Time: Master These Excel Formulas for Maximum Efficiency! 🕒 If you’ve ever struggled with Excel, mastering formulas can seriously up your game. Here’s a breakdown of the essentials that’ll make you look like a pro 1.Core Calculation Formulas 🧮 These are the basics you can’t live

1180 likes

A laptop displays an Excel spreadsheet with charts and data, while a hand interacts with the trackpad. The image features text overlay "Excel shortcuts cheat sheet" and "SWIPE FOR MORE," indicating a guide to Excel shortcuts.

This image lists four essential Excel shortcuts: Autosize Columns (Alt + H + O + I), AutoSum (Alt + =), Display formula in cells (Ctrl + ~), and Insert Current Date (Ctrl + ;). It is part of a multi-page guide.

This image presents four more Excel shortcuts: Insert Hyperlink (Ctrl + K), Freeze Rows & Columns (Alt + W + F + F + F), Fill Down / Fill Right (Ctrl + D and Ctrl + R), and Paste Special - Values (Alt + E, S, N).

Excel shortcuts every student should know! 👩🏻‍💻

Excel shortcuts can significantly improve your efficiency and productivity when working with spreadsheets. Here are some powerful Excel shortcuts that everyone should know. These shortcuts can save you a lot of time and make working with Excel more efficient. Practice using them regularly to become

2717 likes

100 Excel Tips The best Shortcuts, Formulas, Formatting & Advanced Tips Bookmark this, you'll save 1,000 of hours! A list of tips that all professionals need. Here is a preview: ⌨️ Shortcuts 1. How to hide a column? Ctrl + 0 2. How to hide a row? Ctrl + 9 3. How to

1433 likes

A detailed Excel Cheat Sheet page covering 'Edit a Workbook', 'Basic Formatting', 'Insert Objects', 'View and Manage Worksheets', and 'Basic Formulas' with instructions and examples.

1/3: Ultimate Excel Cheatsheet You Should Know

Hey there, I've got just the right boost for your Excel game. 🌟 📝 The Journey from Junior to Senior: My Excel Cheatsheet Chronicles I've been there, struggling with the basics and wondering how to climb the Excel ladder. But fear not, because I've distilled my journey into a one-p

537 likes

Excel import magic

Excel magic at its finest. Import data from picture whether it’s a photo from your phone or a screenshot. #tutorial #exceltips #exceltricks #exceltraining #exceltutorial

371 likes

This image displays a Microsoft Excel Cheat Sheet covering basic skills, including the program screen, keyboard shortcuts, navigation, and formatting. It features a 'Swipe' overlay, indicating more content is available.

This image shows a Microsoft Excel Cheat Sheet focused on advanced skills, specifically detailing PivotTable elements, fields, layout, and charts. It provides a comprehensive guide to using PivotTables in Excel.

How to get the excel Cheatsheet pdf?

I just made my own website : valder.org A lot of free data resources will share on it. If you are a student in college you can follow to get more.

59 likes

Excel formatting does the same thing as many people using Word #tutorial #exceltips #exceltricks #exceltutorial #exceltraining #worktips #alwayslearning

4949 likes

Name cells in excel

Customize and store headings in Excel #exceltips #tutorial #exceltraining #exceltricks #exceltutorial #excelforbeginners #learn Takw my Excel class xecutethevision.com#onthisday

32 likes

A comprehensive DeepSeek Complete Cheatsheet by Jafar Najafov, outlining roles, tasks, restrictions, and specific prompts for business owners, developers, marketers, and designers, along with prompt priming and the C.R.E.A.T.E. formula.

A list of roles from a DeepSeek AI cheatsheet, including Lawyer, Ghostwriter, Website Designer, Best Selling Author, Chief Financial Officer, Expert Copywriter, Prompt Engineer, Accountant, Project Manager, Sports Coach, Financial Analyst, and Full Stack Developer.

A list of roles from a DeepSeek AI cheatsheet, including Analyst, Teacher, Marketer, Advertiser, Mindset Coach, Therapist, Journalist, and Inventor, under the heading 'Act as a [ROLE]'.

🚀 DeepSeek Complete Cheatsheet

Hey everyone! 🌟 I’ve put together a comprehensive cheatsheet based on the DeepSeek Complete guide by Jafar Najafov.This is perfect for anyone looking to leverage AI prompts effectively. Let’s dive in! 🧭 ---- Act as a [ROLE] Need to switch roles? Here’s a list of personas you can adopt: 1. Anal

75 likes

A vibrant graphic titled 'USEFUL EXCEL FORMULAS' in green, overlaid on a spreadsheet displaying various charts, data tables, and financial figures. The image includes 'Career | Lemon 8' branding and a 'SWIPE' indicator.

A laptop screen showing code, with a text box explaining the 'VLOOKUP' Excel formula. It defines its function for searching large datasets and provides a detailed example. The image is branded 'Career | Lemon 8 | Yun Jung'.

A text box on a wooden desk with a laptop, smartphone, and coffee cup, explaining 'SUMIF & SUMIFS' Excel formulas. It defines their use for adding cells based on conditions and provides a SUMIF example. The image is branded 'Career | Lemon 8 | Yun Jung'.

Useful Excel Formulas to save your time at work!

Hey everyone! Excel formulas are awesome for speeding up calculations and analyzing data. They range from simple math stuff to more complex tasks like searching and matching data. Learning these formulas can make your work easier and help you get more done in less time. Try out online tutorials and

872 likes

15 Life-Changing Websites You Need to Know in 2025 🔥 | Hidden Online Tools

Discover 15 of the most powerful, underrated, and life-changing websites that will completely transform how you work, learn, and live online in 2025. 🚀 From productivity tools and AI-powered hacks to secret online resources and hidden gems most people have never heard of — these websites are design

883 likes

Excel quick search tabs instead of scrolling trick

Excel quick search tabs instead of scrolling trick #tutorial #exceltips #exceltricks #excel _learning #exceltraining #learn #excelforbeginners #fyp

18 likes

Excel list comparison 🌸

So we have to use something called Planbook at work (Teacher). I think this will make me want to actually use it more, and I can see me changing it again before second semester begins lol. How cute is this?! I’d usually do random colors, but love the pink & green combo. #Planbook #

4458 likes

Excel shortcuts are easy to remember with cheat sheets like the ABC’s. These are some of the most common shortcuts to use. #excel #exceltraining #exceltips #exceltricks #excelpro #alwayslearning

33 likes

Excel cheat sheet

Excel cheat sheet #excel #exceltips #exceltricks #exceltraining #tutorials #excel_learning

14 likes

100 Excel Shortcuts

#excelshortcuts #excelformulas #exceltips

745 likes

✨🗄️ Job Interview Cheat Sheet For Beginners 📋✨

✨ Whewww. If your palms get sweaty just thinking about job interviews, this post is for you. Whether you’re entering the workforce, pivoting careers, or going for that corporate baddie promotion,interviews don’t have to feel like a pop quiz you didn’t study for.✨ ✨ Here are 12 of the most common

154 likes

Study tips to help you excel in your exams 🍋

📝Daily affirmations - Straight A's are not negotiable - GPA reflection of my dedication - Study techniques that changed my life - From average to academic weapon - Transforming my grades completely - Study methods that actually work #StudyTok #studyWithMe #studyMotivation

6 likes

A promotional image featuring a woman with text overlay that reads: 'Ultimate office software Cheat Sheet can leverage your career. Get PDF from valder.org'. The image also includes 'lemon8 @wuvalder' branding.

A 'Custom Guide Microsoft® Excel 2021 Basic Quick Reference Guide' cheat sheet, detailing the Excel program screen, keyboard shortcuts, general navigation, getting started, editing, and formatting options.

A 'Custom Guide Microsoft® Excel 2021 Intermediate Quick Reference Guide' cheat sheet, illustrating chart elements, chart options, various chart types, and instructions for creating, modifying, printing, and distributing charts.

my ultimate office software cheatsheet

Let me tell you a little secret: I used to be that person who Googled every single Excel formula, struggled with PowerPoint layouts, and spent way too much time formatting Word documents. Sound familiar? 😅 But then, I decided to take control. I printed out these Ultimate Cheat Sheets for Excel, Po

60 likes

Save these Useful Excel Shortcuts!

Hey everyone! Excel shortcuts are super helpful for getting things done faster and smoother. They range from simple tricks for moving around your spreadsheet to more advanced ones for formatting and data manipulation. Mastering these shortcuts can really save you time and make you more efficient! I

296 likes

Blank EXCEL template for school nurses!

As a school nurse this isn’t perfect but I wanted to share it anyways. It is a BLANK excel template for students with health conditions. Just click and request access. Is there any other templates you’d like to have access to or need ? 1. Click my link tree in my bio!!! Click on drop down arrow

58 likes

Excel Trick:Create an Interactive Project Tracker😎

✨ Welcome to Our Excel Mini-Class! ✨ Hey Excel Pros!😉 Want to take your project management skills to the next level? Want to stay organized and on top of your projects like a true professional? Let's create a super simple yet interactive project tracker in Excel that'll keep you focused

6 likes

A study desk with a tablet displaying images, a water bottle, and a glass. Overlay text reads '5 Free Resources You Probably Haven't Tried Yet,' introducing study tools.

A screenshot of the Perplexity AI interface, showing a search bar and options. The accompanying text describes it as a tool for direct answers and cited sources for research papers.

A screenshot of the Connected Papers interface, illustrating a visual graph of academic papers. The text explains its function in creating a visual map of related research articles.

5 game-changing study resources that cost you $0

🧠1. Perplexity AI: I used to get so lost in endless search results when starting a research paper. Perplexity saves me time by giving me a direct summary of any topic while citing all its sources, so I know the information is reliable. 🗺️2. Connected Papers: Writing literature reviews felt lik

828 likes

How to subtract hours and format time in excel

How to subtract hours using Excel. Format time with this excel tip. #excel #exceltips #exceltricks #tutorial #exceltraining

39 likes

Copy paste unique only in excel trick

Copy just the unique values in excel #exceltraining #exceltips #exceltricks #tutorials #excelforbeginners

12 likes

This image, titled "Essential Learning Techniques," describes the Feynman Technique for explaining concepts simply and the Pareto Principle (80/20 Rule) for focusing on high-impact study material. It features a person working on a laptop at a desk.

This image, titled "Essential Learning Techniques," explains the Ebbinghaus Forgetting Curve for memory retention through reviews and the Interdisciplinary Approach for comprehensive understanding. The background shows a desk with a laptop, flowers, and books.

This image, titled "Essential Learning Techniques," details the Dual Coding Theory for combining text and visuals, and the GROW Model for setting clear learning goals. The background features a modern desk with a computer monitor displaying code.

🧠 10 Game-Changing Study Hacks That Actually Work!

#studytips #productivity #learning Hey besties! 📚✨ Ready to level up your study game? I've got some mind-blowing learning techniques that'll transform how you absorb information! These aren't your boring old study tips - they're scientifically-proven methods used by

13 likes

An outdoor dining scene with people seated at tables, featuring the overlaid text "Freeze the Top Row in Excel." A purple glass is visible in the foreground on a black mesh table.

A light beige background with black text asking, "Do you ever have hundreds of rows of data and when scrolling down, you loose sight of the column header and forget which column/field is which?"

A light beige background with black text stating, "This is when freezing your top row is crucial! I will show you how!"

HOW I FREEZE THE TOP ROW IN EXCEL

The ability to freeze that first row of my column headers has been a lifesaver, allowing me to scroll through thousands of rows of data without losing sight of my column headers/fields. By simply selecting the row below the one you want to freeze, heading to the "View" tab, and clicking

105 likes

Excel vs Word #excel #exceltricks #exceltips #exceltutorial

Excel vs Word #excel #exceltricks #exceltips #exceltutorial

121 likes

Things that helped me excel as an online student

How to excel as an online student: planner📚: Keep a physical or online copy of a planner with you!! Planning out each day or writing down what classes you have at what time or what assignments are due each week will help you be prepared. Since you’re doing school online you won’t have a professor

45 likes

Excel's Most Powerful Trick-Ctrl+E

📊 Welcome to Our Excel Mini-Class! 🚀 In today’s session of the Boost Your Excel Skills series, we’re unlocking the magic of Ctrl+E—your new best friend for saving time! ⏳ Whether you’re working with big datasets or just need to clean up information, this shortcut will help you instantly fill in

150 likes

A woman takes a mirror selfie, holding a coffee cup and phone, with text overlay 'EXCEL SHORT CUTS SAVE TIME & FRUSTRATION PART 1'. Abstract shapes frame the image.

A beige graphic slide explains the Excel shortcut 'SHIFT + END + DOWN' for selecting an entire column or section of data, with a 'SWIPE' indicator.

A brown graphic slide details the Excel shortcut 'CTRL + A' which selects all data in a worksheet, accompanied by a 'SWIPE' instruction.

EXCEL SHORTCUTS

These excel short-cuts are just a few that have made my excel work take a fraction of the time and genuinely changed my work life!! Working in excel can be extremely frustrating when not using the tool efficiently. Here are some crucial shortcuts to enhance your experience with Excel. CTRL + A

2583 likes

ANALYZE DATA - EXCEL TOOL

Excel's Analyze Data Tool is a game-changer, simplifying the way you work with data. Say goodbye to the days of laboriously creating tables and charts and struggling with formatting intricacies. This tool automates the process, making data analysis and visualization effortless. With just a f

251 likes

How to Find Cube of any Numbers in Excel

How to Find Cube of any Numbers in Excel #excel #exceltips #exceltricks #exceltutorial #microsoftexcel

0 likes

EXCEL SHORTCUTS PART 3

As requested, here is another excel shortcut post! Discovering the power of Excel shortcuts has been a game-changer for my productivity at work. These little keystrokes might seem insignificant, but they're the key to working smarter, not harder. From navigating vast datasets quickly to instant

332 likes

Excel cheatsheet:5/20, one page equals a book

https://hf.datarails.com/ #excel -sheets 💅🏾🏙️📜🧐🤔🤨😀🤩💋👌🏾👄

2 likes

Nesting Cheat Sheet: Organization Tips

This is an ultimate cheat sheet for all the nesting mamas who are looking for some organization tips! I made this a three part series so feel free to check out my previous posts too! The pictures have some organization tips that have worked well for me as a first time mom with a now 14 month ol

1320 likes

Excel at the toughest premed classes! ✨

If you talk to any student who has completed their degree, with a premed major, there is a common three most difficult courses: Anatomy and physiology Organic chemistry Physics Across-the-board, these classes seem to be the ones that give students the most grief and require the most

28 likes

Nesting Cheat Sheet: Furniture, gear, & toys

This is your ultimate nesting cheat sheet for all you soon to be mamas! I’m going to make this three parts, with this first part being all the furniture, gear, and toys to get ready for baby to get here! The pictures have a step by step list that you can utilize as you’re setting everything up f

640 likes

A smiling woman in a black puffer jacket, white scarf, and earmuffs holds a book and coffee cup in front of a festive market stall. Overlaid text reads: "MUST HAVE SCHEDULE FOR LAZY STUDENT."

A woman wearing headphones works on a laptop, illustrating the morning study block. Overlaid text details "Morning (9-11am)", "Wake up and hydrate", and "Do 1 focused study block (max 1hr)" on a priority topic.

A woman relaxes on a couch, reading a book, with a small dog on the windowsill. Overlaid text describes the "Afternoon (1-3pm)" activities: "Rest / scroll / vibe" and "Passive learning" via media.

How you can excel at school (the lazy way)

This one’s for my fellow lazy-but-ambitious besties 💅 You want good grades, but motivation? Rare. Energy? Inconsistent. Attention span? Fighting for its life. LOL. So I made a schedule that actually works when you’re low-effort but still want to see results. Here’s the lazy but it works ro

51 likes

Erase Blank Lines in Excel in a Flash! ⚡📊

✨ Welcome to Our Excel Mini-Class! ✨ Ever end up with a ton of blank rows in your Excel sheet and wonder how to get rid of them fast? 🙄 Well, I’ve got a super quick solution for you! Let’s clean up your spreadsheet in just a few clicks! 🧹✨ With the tutorial in the video, your sheet will be cl

1 like

Excel differences in columns

Find the differences between these columns in Excel with these Excel tricks #excel #exceltraining #exceltips #excel _learning #tutorial #excel_learning #excelforbeginners #fyp

36 likes

Fast Task Tracking in Excel! 🏃‍♂️✅❌

✨ Welcome to Our Excel Mini-Class! ✨ Hey productivity champs! 🙌 If you’re juggling multiple tasks and need a simple, fast way to track your progress, I’ve got the perfect Excel trick for you! 📊✨ Let’s set up a Done/Not Done Tracker that will keep your tasks organized and help you stay on top

4 likes

Excel tip to fix row sizing 🌸

Just pause before you send a file like this. It takes 3 seconds to fix it. #exceltips #tutorial #exceltraining #exceltraining #exceltricks

54 likes

See more