Automatically translated.View original post

16.5K followers

85 saved

100

Excel Hack: Focus Cell, clear row & column

Excel Hack: Focus Cell clearly sees row & column ➡️ 365, just one button. The old version uses the diy technique.# Excel # exceltips # Exceltutorial # digitaltan # This clip must be shared

2025/8/14 Edited to

หลายคนถามว่า “focus cell ใน excel 2016 อยู่ตรงไหน” หรือ “excel ไม่มี focus cell” เพราะเห็นใน Microsoft 365 มีฟีเจอร์กดปุ่มเดียวแล้วเน้นทั้งแถว/คอลัมน์ตามเซลล์ที่เลือก แต่ใน Excel 2016 (รวมถึง 2013/2010 หรือ 2019 บางเครื่อง) มักจะไม่มีปุ่มนี้ให้ใช้แบบสำเร็จรูปค่ะ วิธีที่เวิร์กและทำได้จริงคือทำ “Focus Cell แบบ DIY” ด้วย Conditional Formatting (ไม่ต้องลงโปรแกรมเพิ่ม) หรือถ้าต้องการให้ไฮไลต์ขยับตามการคลิกแบบอัตโนมัติแบบเนียน ๆ ค่อยเพิ่ม VBA เล็กน้อย วิธีที่ 1: DIY Focus Cell ใน Excel 2016 ด้วย Conditional Formatting (แนะนำ เริ่มง่าย) 1) เลือกช่วงตารางที่อยากให้ไฮไลต์ เช่น A1:Z200 (เลือกให้ครอบคลุมพื้นที่ทำงานจริง) 2) ไปที่ Home > Conditional Formatting > New Rule 3) เลือก “Use a formula to determine which cells to format” 4) ใส่สูตรนี้ลงไป: =OR(ROW()=CELL("row"),COLUMN()=CELL("col")) 5) กด Format แล้วเลือกสีเติม (Fill) อ่อน ๆ หรือเลือกเส้นขอบ (Border) ตามที่ชอบ จากนั้นกด OK ผลลัพธ์: แถวและคอลัมน์ของ “เซลล์ที่กำลัง Active” จะถูกไฮไลต์ ช่วยไล่ตารางยาว ๆ ได้ง่ายขึ้นมาก โดยเฉพาะเวลาทำงานกับข้อมูลหลายคอลัมน์ ข้อควรรู้ (ที่หลายคนเจอแล้วคิดว่า “หา focus cell ไม่เจอ”) - สูตร CELL("row") และ CELL("col") จะอ้างอิงเซลล์ที่ Active แต่บางครั้งสีอาจไม่ขยับทันทีหลังคลิก ต้อง “บังคับให้คำนวณใหม่” - ถ้าคลิกแล้วไฮไลต์ไม่เปลี่ยน ให้ลองกด F9 หนึ่งครั้ง หรือไปที่ Formulas > Calculation Options ตั้งเป็น Automatic วิธีที่ 2: ให้ไฮไลต์ขยับอัตโนมัติทุกครั้งที่คลิก (เสริมด้วย VBA) ถ้าคุณอยากให้เหมือน 365 คือคลิกปุ๊บ ไฮไลต์ย้ายตามทันที แนะนำเพิ่มโค้ดเหตุการณ์ในชีต 1) กด Alt + F11 เพื่อเปิด VBA Editor 2) ดับเบิลคลิกชื่อชีตที่ต้องการ (เช่น Sheet1) 3) วางโค้ดนี้: Private Sub Worksheet_SelectionChange(ByVal Target As Range) Application.Calculate End Sub 4) กลับมา Excel แล้วลองคลิกเปลี่ยนเซลล์ ไฮไลต์จะอัปเดตทันที ทิปส่วนตัว: เลือกสีไฮไลต์ให้ “อ่อน” หน่อย (เช่นเหลืองจาง/เทาอ่อน) จะไม่กลบตัวเลขในตาราง และถ้าตารางมี Conditional Formatting อื่นอยู่แล้ว ควรจัดลำดับกฎ (Manage Rules) เพื่อไม่ให้ตีกัน สรุปคือ Excel 2016 ไม่มี Focus Cell แบบปุ่มสำเร็จเหมือนบางเวอร์ชัน แต่ทำได้แน่นอนด้วย Conditional Formatting และถ้าต้องการความลื่นแบบคลิกแล้วอัปเดตทันที ค่อยเสริม VBA อีกนิด เท่านี้ก็ได้โหมดเน้นแถว+คอลัมน์แบบมืออาชีพแล้วค่ะ

100 Excel Tips

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

1446 likes

Memorize THESE Excel shortcuts = instant promotion

✨ Want to look like the Excel genius at work… without actually struggling for hours? 👀💻 I swear these little shortcuts make you go from “uhhh let me Google that…” ➡️ “oh yeah I got this 😌” ⚡ Ctrl this ⚡ Alt that ⚡ suddenly you're the coworker everyone asks for help No gatekeeping

6 likes

Excel drop it function

Remove columns and rows using drop in excel. #exceltips #excel #exceltutorial #businesstips #business #tutorial #boss #spreadsheet

20 likes

Excel Guide

#excelspreadsheets #

6 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 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

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

2720 likes

This image illustrates 20 Excel tips and tricks. It covers adding a dynamic dropdown list, unpivoting data, adding slicer buttons to a PivotTable, using text to columns, transposing data, duplicating windows, and tracking cell values with a watch window. Each tip includes a visual example and brief instructions.

20 Excel Tricks & Tips 👇

Master all 20 and become an excel wizard 🧙‍♂️ 1️⃣ Add a dropdown tied to a dynamic list Know how to create a drop down using data validation? Cool…now how about extending that reference when your list expands? Step 1: create a table out of the list. This will extend the table anytime a

247 likes

An office cubicle desk with a computer monitor, keyboard, and various personal items, including framed photos and plants. Overlay text reads 'How to List Items within one Cell in Excel', introducing a productivity tip.

A screenshot of Microsoft Excel showing a cell with '1) hello'. Text explains that pressing 'Enter' moves to the next cell, and introduces the 'ALT - Enter' shortcut to add a new line within the same cell.

A simplified Excel view demonstrating a single cell containing a multi-line list: '1) hello', '2) Hi', '3) Howdy'. Text confirms this is the result of using 'Alt - Enter' to create a list of steps within one cell.

HOW I LIST MULTIPLE LINES IN ONE CELL - EXCEL

I've discovered how to list out several items by line in a single cell by using the Alt-Enter key shortcut. I can now structure my spreadsheet in a more ideal way with this ability, and keep data that belongs together in the correct rows. I select the cell I want and type the first item. Then,

407 likes

Excel delete blanks

Remove the blank rows #tutorial #exceltraining #exceltricks #exceltips #exceltips

44 likes

Excel vs Word

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

4954 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 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

2588 likes

Everything you can do in Excel

Want to know what you can do in Excel? This post contains EVERYTHING you can do in excel 😱👇 Excel continues to be the #1 tool used for Finance & Accounting professionals…and for a very good reason. With excel, there are pretty much no limits to what you can accomplish. #l8r2023

249 likes

Excel formatting tips

Excel formatting tips #tutorials #excel #excelforbeginners #exceltraining

170 likes

5 PROVEN METHODS TO EXCEL AT WORK

Hey productivity bestie ☕✨ If you’ve been busy ALL day but still feel like you got nothing done… yeah, we fixing that TODAY 👀 Here’s your simple Productivity Glow-Up Blueprint (no overwhelm, just results 💼💅🏽): ✨ Set CLEAR goals (not “do work” be specific!) ✨ Prioritize what actually matte

3 likes

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

1192 likes

This image details the first Excel hack: "Return to the top without scrolling" by pressing Ctrl (or Command) and the up arrow twice, accompanied by a small Excel icon.

This image details the second Excel hack: "Quickly resize columns and rows" by double-clicking the dividing line between columns, accompanied by a small Excel icon.

3 Excel Hacks you need to know! 

You know what's a game-changer in the office world? Understanding Microsoft Excel! 📊 It's not just a spreadsheet software; it's your secret weapon for success. Here's why: First, it's a productivity wizard. Excel can crunch numbers, organize data, and create slick charts in a

391 likes

USING PIVOT CHARTS

Pivot charts are dynamic tools that can transform raw data into meaningful insights, making them indispensable for anyone working with data analysis. Understanding how to use pivot charts opens up a world of possibilities for visualizing and interpreting complex datasets. To create a pivot chart

575 likes

Excel dot trick

Do you know the DOT?? Excel trick using the dot to remove extra zeroes #exceltraining #excel #exceltricks #exceltraining #exceltutorial #business #businesstips

106 likes

Transform rows to columns

The transpose function turns rows into columns for you in both Excel and GSheets #tutorial #exceltips #googlesheets #exceltips #onthisday

15 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

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

A decorative title slide with the text 'CREATING SPARKLINES IN EXCEL' in a handwritten style, overlaid on a background of personal photos and office desk items.

A beige background with white text defining a sparkline as a compact, simplified line chart for quick visual representation of data trends without labels or axes.

An Excel screenshot showing a row of monthly sales data highlighted, with the 'Insert' tab selected and the 'Line' sparkline option within the 'Sparklines' group highlighted.

SPARKLINES IN EXCEL

What Are Sparklines? Before we dive into the "how," let's briefly touch on the "what." Sparklines are small, in-cell charts that display data trends. They're ideal for quickly visualizing information like stock prices, sales figures, or temperature fluctuations. Sparklines

69 likes

Auto Rows Highlighter

📊 Welcome to Our Excel Mini-Class! 🚀 In today’s session of the Boost Your Excel Skills series, we’re introducing the Auto Rows Highlighter—the ultimate trick to visually organize your data like a pro! 👀✨ With just a few clicks, you’ll be able to highlight entire rows automatically, making your s

1 like

Excel Hacks: 4 Quick Ways to Fill Serial!

📈 Welcome to Our Excel Mini-Class! 💫 In this session, we're unveiling the magic of fill serial! Ready to save time on your Excel spreadsheets? Here's 4 super fast ways to fill serial numbers like a pro! 💼✨ Get ready to level up your Excel skills! 🙌 #wps #fillserial #exceltips

7 likes

A person takes a mirror selfie with the text overlay '6 Excel Ribbon MUST HAVES', serving as the cover image for an article on Excel tips.

A pink and orange graphic explains that customizing the Excel ribbon saves time by pinning frequently used actions, with a 'Swipe' prompt.

Screenshots illustrate 'HOW TO CUSTOMIZE' the Excel ribbon, showing steps to select a dropdown menu and add commands via the 'Customize Quick Access Toolbar' dialog.

6 EXCEL RIBBON MUST HAVES

As an employee in the corporate world, a lot of my time consists of using Microsoft Excel! There are many small functions that I use hundreds of time in a day. Instead of having to sort through different excel tabs to find these functions, Excel gives me the option to customize my ribbon and pin m

222 likes

A title slide with the text 'USING PIVOT TABLES IN EXCEL' overlaid on an office interior with large windows, indicating a tutorial on Excel pivot tables.

An Excel spreadsheet displaying raw business order data, including Order #, Shipping Location, Category, and Cost, with text explaining the data and introducing pivot table analysis.

An Excel screenshot showing the steps to create a pivot table: highlighting data, selecting 'PivotTable' from the 'Insert' tab, and choosing to place it on an 'Existing Worksheet'.

PIVOT TABLES IN EXCEL

Excel, the ubiquitous spreadsheet software, is a go-to tool for data management and analysis. When dealing with large and complex datasets, one indispensable feature that can help you gain valuable insights is the pivot table. Pivot tables are versatile, user-friendly tools that allow you to transf

141 likes

A green and white graphic titled 'Master Simple Excel Operations', listing five basic Excel tasks: creating a workbook, entering data, adjusting column/row size, inserting/deleting cells, and using functions.

A graphic titled 'Keyboard Function Key Identification' showing a white keyboard layout and a table identifying common keys like Esc, Tab, Caps Lock, Shift, Ctrl, Alt, Enter, Backspace, Sleep, and Wake Up.

Getting Started with Excel: It's Really Simple!

We'll start with the basics, learning about Excel's interface, toolbar, cells, and other fundamental operations. Then, we'll move on to common office shortcuts, as well as some frequently used functions and formulas. #ExcelBasics #ProductivityTips #SpreadsheetSkills #Exce

40 likes

How to Delete Rows in Excel

In this video, i will be explaining detail How to DELETE Rows in Excel #excel #exceltips #exceltricks #exceltutorial #microsoftexcel

0 likes

EXCEL SHORTCUTS: PART 2

Excel has become an integral part of my daily work routine, and I've found several keyboard shortcuts that have significantly improved my efficiency. Let me share how I use some of these handy shortcuts to streamline my tasks and data management. Ctrl + Space & Shift + Space: These two

436 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

Must-Know Excel Tip for Busy Days! ⏰ 🥰

✨ Welcome to Our Excel Mini-Class! 📈 In this session, we’re unveiling the magic of Text to Columns! 🤓 Have you ever had a long list of data all in one cell and wished you could separate it into neat, organized columns? Well, now you can—with just a few clicks! 🔥 No more messy data or manual cutt

5 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

Excel conditional formatting

HR & People tool practical Excel application of conditional formatting #tutorials #template #excel #exceltricks #exceltraining

9 likes

A laptop on a desk with a gold lamp and glasses, displaying a design interface. The image is overlaid with the title 'Excel Shortcuts Part 3' in white and pink text.

A beige background with white and brown text presenting an Excel shortcut: 'F2: Edit the active cell.'

A beige background with white and brown text presenting an Excel shortcut: 'Alt + =: AutoSum selected cells.'

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

333 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

540 likes

Excel sparklines

Sparklines in Excel in a new way #tutorial #excel #friday #exceltricks #exceltips #exceltipsandtricks #spreadsheet #workhack

20 likes

✨ Welcome to Our Excel Mini-Class! 🐶 In this session, we’re diving into essential Excel functions that will save you tons of time! ⌛ From quick calculations to powerful data organization, these functions do the work for you—no more repetitive tasks! 🔄🔍 These go-to functions will boost your produ

3 likes

5 Must-Know Shortcuts

📊 Welcome to Our Excel Mini-Class! 🚀 Hey Excel enthusiasts! 👋 In today's session of the Boost Your Excel Skills series, we're diving into 5 Must-Know Shortcuts that will save you time and take your Excel game to the next level. Whether you're a beginner or a pro, these shortcuts are

6 likes

How to use AND Function in Excel

Here is a video explaining how to use AND Formula in Excel #excel #exceltipsandtricks #exceltips #exceltutorial #microsoftexcel

0 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

873 likes

A laptop displaying a lock screen with a scenic mountain and lake image, next to a potted cactus and a lit candle. The title 'CONDITIONAL FORMATTING IN EXCEL' is overlaid in green text.

An Excel spreadsheet showing a list of student names and their grades. Text on the right explains the goal: 'WE HAVE A LIST OF STUDENTS WITH CLASS GRADES LETS USE THE CONDITIONAL FORMATTING TOOL TO GIVE A BETTER VISUAL REPRESENTATION OF WHERE STUDENTS ARE IN THE CLASS'.

An Excel spreadsheet with the 'Grade' column (cells C5 to C22) highlighted, indicating the data selection for conditional formatting. Text on the right says 'HIGHLIGHT YOUR DATA...'.

CONDITIONAL FORMATTING IN EXCEL

Excel's conditional formatting is a powerful feature that allows you to visually emphasize specific data points, making your spreadsheets more intuitive and informative. Two commonly used conditional formatting rules are the Gradient Scale and the Greater/Less Than rules. Let's explore how

164 likes

$An infographic details Excel Custom Formatting, covering its definition, access methods, and syntax for positive, negative, and zero values. It illustrates various operators like numbers, colors, and symbols, alongside examples for formatting dates, conditional formatting, fractions, scientific notation, percentages, custom text, number abbreviations, and using symbols.$