๐ก Excel Tips & Tricks ๐ง ๐
Part 2 โ Tips That Save Time
๐น Tip 11: Use Flash Fill
When Excel recognizes a pattern, press: Ctrl + E
๐ Great for splitting, combining, or reformatting text without writing formulas.
๐น Tip 12: Quickly Insert a New Line Inside a Cell
Press: Alt + Enter
๐ Useful when you need multiple lines of text within one cell.
๐น Tip 13: Select Only Visible Cells
After filtering data, press: Alt + ;
๐ This selects only visible cells, preventing you from accidentally modifying hidden or filtered-out rows.
๐น Tip 14: Use Absolute References When Needed
If a formula needs to always refer to the same cell or range, use $.
Example: =B2*E1
๐ E1 remains fixed when you copy the formula.
๐น Tip 15: Quickly Copy a Formula Down
Double-click the fill handle (small square at the bottom-right of the selected cell).
๐ Excel automatically fills the formula down alongside the neighboring data.
๐น Tip 16: Use Ctrl + 1 to Open Format Cells
Instead of navigating through menus, press: Ctrl + 1
๐ Quickly change number formats, alignment, borders, protection, and more.
๐น Tip 17: Use SUM() with AutoSum
Press: Alt + =
๐ Excel automatically suggests a range and inserts a SUM() formula.
๐น Tip 18: Quickly Create a Chart
Select your data and press: Alt + F1
๐ Excel creates a chart directly on the current worksheet.
๐น Tip 19: Use Ctrl + Shift + $ for Currency Format
Select the values and press: Ctrl + Shift + $
๐ Quickly applies currency formatting.
๐น Tip 20: Use Named Ranges for Important Data
Instead of repeatedly using ranges such as B2:B1000, give the range a meaningful name.
Example: SalesData
๐ Formulas become easier to understand and maintain.
๐ฌ Double Tap โฅ๏ธ For More Excel Tips!
7August 29, 2026 532 3
