Excel Keyboard Shortcuts

Complete Windows and Mac Excel shortcut reference with 80+ shortcuts organized by category

The Excel keyboard shortcuts reference covers 80+ shortcuts for Windows and Mac, organized by category. Search by action to find any shortcut instantly. Keyboard shortcuts dramatically increase speed — power users rarely touch the ribbon.

How to Learn Excel Keyboard Shortcuts Effectively

Mastering Excel keyboard shortcuts is the fastest way to improve your spreadsheet speed. The goal isn't to memorize all 80+ shortcuts — it's to build a small core set that becomes automatic, then expand from there.

Step 1: Start with the 8 essential shortcuts

Ctrl+Shift+L (filters), Ctrl+T (table), F2 (edit cell), Ctrl+; (today's date), Alt+= (AutoSum), Ctrl+D (fill down), Ctrl+R (fill right), and Ctrl+Shift+End (select to last cell). These cover 80% of daily Excel tasks. Use them deliberately for a week until they're automatic.

Step 2: Use the "Ctrl+_" patterns

Many Excel shortcuts follow the Ctrl+letter pattern from standard Windows: Ctrl+C (copy), Ctrl+V (paste), Ctrl+Z (undo), Ctrl+Y (redo), Ctrl+F (find), Ctrl+H (replace), Ctrl+B (bold), Ctrl+I (italic), Ctrl+U (underline). If you know Windows shortcuts, you already know many Excel shortcuts.

Step 3: Learn navigation shortcuts second

Ctrl+Arrow keys jump to the last cell with data in any direction. Ctrl+Home goes to A1. Ctrl+End goes to the last used cell. Ctrl+Shift+Arrow extends the selection to the data boundary. These three patterns cover all spreadsheet navigation.

Frequently Asked Questions

Is this Excel keyboard shortcuts reference free?

Yes, completely free with no signup. Search and filter shortcuts by category.

What are the most important Excel shortcuts to learn first?

Start with: Ctrl+Shift+L (toggle filters), Ctrl+T (create table), F2 (edit cell), Ctrl+; (insert today's date), Ctrl+Shift+End (extend selection to last used cell), Alt+= (AutoSum), Ctrl+D (fill down), Ctrl+R (fill right). These 8 shortcuts cover 80% of daily Excel work.

How do I toggle AutoFilter in Excel?

Use Ctrl+Shift+L to toggle AutoFilter on or off for the selected range. This is one of the most useful shortcuts for working with large datasets.

What is the Excel shortcut to create a table?

Ctrl+T converts a range to a structured Excel table. Tables automatically expand when you add data, support structured references in formulas, and make filtering and sorting easier. They are one of the most underused Excel features.

Is my data safe when using this tool?

Yes, this reference runs entirely in your browser. No data is sent to any server.