How do I remember this Excel tip?

Use it on one real task this week, then add a sticky note on your monitor with the shortcut until it becomes automatic.

Will this tip work on Mac Excel?

Most shortcuts differ slightly on Mac (Cmd instead of Ctrl). Check the function or feature page for platform notes when something does not work.

Tips & Tricks - 2026-01-21

Stop wasting time with mouse clicks. These essential Excel shortcuts will transform how you work with spreadsheets.

Mastering keyboard shortcuts is the fastest way to improve your Excel productivity. Here are 10 must-know shortcuts: Ctrl + ; (Insert Current Date) Instantly insert today's date into the active cell. Ctrl + Shift + : (Insert Current Time) Add the current time with a single keystroke. Ctrl + D (Fill Down) Copy the cell above to the current cell. Works with selections too. Ctrl + R (Fill Right) Copy the cell to the left. Perfect for extending formulas. F4 (Toggle Absolute References) Cycle through reference types: A1 to $A$1 to A$1 to $A1 Alt + = (AutoSum) Instantly sum the cells above or to the left. Ctrl + Backtick (Show Formulas) Toggle between showing values and formulas in cells. Ctrl + Shift + L (Toggle Filters) Add or remove filter dropdowns instantly. Ctrl + Page Up/Down (Switch Sheets) Navigate between worksheets without the mouse. Ctrl + Space / Shift + Space Select entire column or row.

Try the shortcut or setting on a copy of your file first. Pin the technique to your Quick Access Toolbar if you will use it daily. Pair productivity tips with Excel Tables and named ranges for fewer broken references. Explore: Tips archive · Keyboard shortcuts guide

How do I remember this Excel tip? Use it on one real task this week, then add a sticky note on your monitor with the shortcut until it becomes automatic.
Will this tip work on Mac Excel? Most shortcuts differ slightly on Mac (Cmd instead of Ctrl). Check the function or feature page for platform notes when something does not work.