25 Excel tips and tricks
that save hours every week

Navigation and selection

1. Jump to the edge of your data

Press Ctrl + Arrow key to jump to the last non-empty cell in any direction. Ctrl + End takes you to the last used cell in the sheet.

2. Select to the edge instantly

Ctrl + Shift + Arrow selects from your current cell to the last non-empty cell — no dragging, no scrolling.

3. Select only visible cells

After filtering, press Alt + ; before copying to select only the visible rows. Without this, Excel copies hidden rows too.

Data entry shortcuts

4. Fill down in one keystroke

Select a cell with a formula, then select the cells below it, and press Ctrl + D to fill the formula down instantly.

5. Enter the same value in multiple cells at once

Select all the cells you want to fill, type your value, then press Ctrl + Enter instead of just Enter. Every selected cell gets the value simultaneously.

6. Add a line break inside a cell

Press Alt + Enter to start a new line within the same cell. Useful for addresses or multi-line labels.

Formula tricks

7. Auto-SUM a whole column

Click the cell below your numbers and press Alt + =. Excel writes the SUM formula automatically.

8. Toggle absolute references with F4

While editing a cell reference in a formula, press F4 to cycle through $A$1, A$1, $A1, A1. No manual dollar sign typing needed.

9. Show all formulas at once

Press Ctrl + ` (the backtick key, top-left of keyboard) to toggle between showing formula results and showing the formulas themselves. Great for auditing.

10. Use F2 to edit a cell

Press F2 to enter edit mode on the selected cell without clicking. The cursor appears at the end of the content.

Formatting shortcuts

11. Open Format Cells with Ctrl+1

This works on any selected cell or range and opens the full Format Cells dialog — the fastest route to custom number formats, borders, and alignment.

12. Repeat your last action with F4

After formatting something, press F4 on the next cell to repeat the exact same formatting. Works for most formatting actions.

13. Apply a table format instantly

Click inside your data and press Ctrl + T to convert it to an Excel Table. Tables automatically expand, filter, and work better with formulas.

Productivity tricks

14. Freeze the top row

View → Freeze Panes → Freeze Top Row. Your header stays visible no matter how far you scroll down.

15. Split names with Flash Fill

Type the first name from a full name column in the next column, then press Ctrl + E. Excel detects the pattern and fills the rest automatically.

16. Remove duplicates in two clicks

Select your data → Data → Remove Duplicates. Choose which columns to check and Excel removes duplicate rows instantly.

17. Paste values only

After copying, press Ctrl + Shift + V (or Alt + E + S on Windows) to paste values only — no formulas, no formatting, just the numbers.

18. Name a range for cleaner formulas

Select a range, click the Name Box (top left), type a name like "SalesData", press Enter. Now use that name in formulas: =SUM(SalesData) instead of =SUM(B2:B100).

Analysis tricks

19. Use CTRL+Z more than you think

Excel has 100 levels of undo. Don't be afraid to experiment — you can always undo back to safety.

20. Quick totals without a formula

Select a range of numbers and look at the status bar at the bottom of the screen. It shows Sum, Average, Count, Min, and Max instantly without any formula.

21. Conditional formatting for instant insights

Home → Conditional Formatting → Color Scales applies a colour gradient to any numeric column. The highest values turn green, lowest turn red — no formula needed.

22. Create a pivot table in seconds

Click inside any data table, press Alt + N + V, then Enter. A blank pivot table appears. Drag Region to Rows and Amount to Values for an instant summary.

23. Use IFERROR to hide error messages

Wrap any formula in =IFERROR(your_formula, "") to show a blank cell instead of #N/A or #REF! errors.

24. Transpose rows and columns

Copy a range, click where you want to paste, press Ctrl+Alt+V, check Transpose, click OK. Rows become columns and columns become rows.

25. Lock a row or column in a formula with $

In a formula, $B$1 always refers to B1 no matter where you copy the formula. $B1 locks the column only. B$1 locks the row only. Essential for building calculation tables.