Stop wasting hours on manual clicks. Here are 20 Excel shortcuts that will save you 2+ hours every week. 🧵👇
1.Ctrl + Arrow Keys: Jump to the very edge of your data (Top, Bottom, Left, or Right).
2.Ctrl + Shift + Arrow Keys: Select all cells until the end of the data range.
3.Ctrl + Home: Instantly return to cell A1.
4.Ctrl + PgUp / PgDn: Move to the next or previous worksheet.
5.Ctrl + G: Open "Go To" (perfect for finding blanks or specific cells).
6.F2: Open the active cell for editing (stop double-clicking!).
7.Alt + Enter: Add a line break inside a single cell.
8.Ctrl + ;: Insert today’s date instantly.
9.Ctrl + 1: Open the full Format Cells menu.
10.Ctrl + Shift + $: Format numbers as Currency.
11.Ctrl + Shift + %: Format numbers as Percentage.
12.Alt + H + O + I: Auto-fit column widths (fixes those annoying #### symbols).
13.Alt + =: AutoSum—instantly sums up the column or row.
14.F4: Repeat your last action OR lock a cell reference (A1).
15.Ctrl + D: Fill Down (copies formula/data from the cell above).
16.Ctrl + Shift + L: Toggle Filters on or off.
17.Ctrl + T: Convert data into an official Excel Table.
18.Ctrl + Z: The "Life-Saving" Undo button.
19.Ctrl + F: Find specific data within your sheet.
20.Alt + A + M: Remove Duplicates from a selected range.
Pro-Tip: If you forget a shortcut, just tap the Alt key. Excel will show you "Key Tips" on the ribbon to guide your next move.
Which one is your most-used shortcut? Let me know below! 👇
Share this Scrolly Tale with your friends.
A Scrolly Tale is a new way to read Twitter threads with a more visually immersive experience.
Discover more beautiful Scrolly Tales like this.