Pre-order now: Windows 11 Made Easy for $19 (launch price, normally $24). Out 15 Dec 2026.
Tech Drop Daily Log inSign up
Free guides / Excel

20 Excel keyboard shortcuts every beginner should know

Updated 17 November 2026

You don't need hundreds of shortcuts. These 20 cover what most people do every day in Excel on Windows. On a Mac, use Cmd where you see Ctrl for most of them.

Move around fast

Select

Edit and format

Formulas and data

Mac users: some shortcuts differ (for example, AutoSum is Cmd + Shift + T, and F-keys may need the fn key).

Questions

What is the shortcut for AutoSum in Excel?

Alt + = on Windows. On a Mac it is Cmd + Shift + T.

How do I lock a cell reference in an Excel formula?

While editing the formula, click the reference and press F4 to add $ signs, for example A1 becomes $A$1.

More: VLOOKUP in Excel: a simple guide with examples · How to make a pivot table in Excel (beginner guide)