Microsoft Excel is easier to use when you know the right keyboard shortcuts. Whether you manage business reports, organize personal budgets, analyze sales figures, or work with large datasets, a few simple key combinations can help you complete everyday tasks more efficiently.

This Excel shortcuts cheat sheet brings together more than 100 useful keyboard shortcuts for Windows and Mac users. It covers essential commands for copying and pasting, navigating worksheets, formatting cells, entering formulas, managing data, and working with multiple sheets.

The guide also explains how to learn shortcuts without memorizing everything at once. Since Excel shortcuts can vary by operating system, keyboard layout, and application version, you will find practical notes to help you choose the right combination for your setup.

Whether you are a beginner or an experienced spreadsheet user, keep this reference handy whenever you need to work faster and reduce repetitive mouse clicks.

What Is an Excel Shortcuts Cheat Sheet?

An Excel shortcuts cheat sheet is a quick reference list of keyboard combinations that help you perform common Excel tasks faster.

Instead of opening menus or searching through the ribbon, you press a few keys to complete an action. For example, Ctrl + C copies selected content on Windows, while Command + C performs the same basic action on Mac.

Excel is a spreadsheet application developed by Microsoft and is available across Windows, macOS, mobile platforms, and the web.

The shortcuts below focus on practical commands that are useful for students, office workers, accountants, analysts, business owners, and anyone who spends time working with spreadsheets.

Why Is an Excel Shortcuts Cheat Sheet Important?

Learning shortcuts can make repetitive Excel work much easier.

Imagine you are preparing a report with 500 rows of sales data. You need to select a column, format numbers, find a customer, insert a formula, and move between worksheets.

Doing everything with a mouse works, but repeating those actions dozens of times becomes slow.

With keyboard shortcuts, many of these tasks can be completed in seconds.

Main benefits include:

• Faster navigation through large worksheets
• Less mouse usage during repetitive work
• Quicker data entry and editing
• Faster formatting
• Easier formula management
• Better productivity
• More efficient spreadsheet analysis
• Improved workflow for financial and business models

Keyboard shortcuts can also be useful for accessibility because they provide an alternative to mouse-based commands. Microsoft specifically notes this benefit for Microsoft 365 applications.

100+ Excel Keyboard Shortcuts for Windows & Mac

The following Excel shortcuts cheat sheet is divided into practical categories so you can find what you need quickly.

Shortcut note: Windows commonly uses Ctrl, Alt, and F-keys, while Mac commonly uses Command (⌘), Option (⌥), and Control (⌃). Some shortcuts differ between platforms and Excel versions. Microsoft also notes that its Mac shortcuts refer to a US keyboard layout.

1. Basic Excel Shortcuts

Action	Windows	Mac
New workbook	Ctrl + N	Command + N
Open workbook	Ctrl + O	Command + O
Save workbook	Ctrl + S	Command + S
Print	Ctrl + P	Command + P
Close workbook	Ctrl + W	Command + W
Undo	Ctrl + Z	Command + Z
Redo/repeat	Ctrl + Y	Command + Y
Cut	Ctrl + X	Command + X
Copy	Ctrl + C	Command + C
Paste	Ctrl + V	Command + V
Find	Ctrl + F	Command + F
Select all	Ctrl + A	Command + A
Insert hyperlink	Ctrl + K	Command + K
Cancel action	Esc	Esc
Help	F1	F1

These basic shortcuts are worth learning first because you will use them in almost every Excel session.

Microsoft’s official Mac shortcut documentation confirms common commands such as Command + N, Command + O, Command + S, Command + P, Command + Z, Command + C, Command + V, and Command + F.

2. Excel Navigation Shortcuts

Moving around a large spreadsheet can be frustrating when you constantly scroll with the mouse.

These shortcuts help you move quickly:

Action	Windows	Mac
Move one cell	Arrow keys	Arrow keys
Move to beginning of row	Home	Fn + Left Arrow
Move to last used cell	Ctrl + End	Command + End
Move to first cell	Ctrl + Home	Control + Home
Move down one screen	Page Down	Page Down
Move up one screen	Page Up	Page Up
Move right one screen	Alt + Page Down	Option + Page Down
Move left one screen	Alt + Page Up	Option + Page Up
Move to edge of data region	Ctrl + Arrow	Command + Arrow
Move between worksheets	Ctrl + Page Up/Down	Option + Left/Right Arrow

For large datasets, Ctrl + Arrow on Windows is particularly useful because it lets you jump toward the edge of a continuous data region instead of scrolling row by row.

3. Selection Shortcuts

Selecting the correct range is an important part of Excel work.

Action	Windows	Mac
Select entire column	Ctrl + Space	Control + Space
Select entire row	Shift + Space	Shift + Space
Extend selection	Shift + Arrow	Shift + Arrow
Select to edge of data	Ctrl + Shift + Arrow	Command + Shift + Arrow
Select to beginning	Ctrl + Shift + Home	Command + Shift + Home
Select to end	Ctrl + Shift + End	Command + Shift + End
Select current data region	Ctrl + A	Command + A
Select worksheet	Ctrl + A	Command + A

When working with thousands of rows, selecting a data region with keyboard commands can save a surprising amount of time.

4. Excel Editing Shortcuts

These Excel keyboard shortcuts are useful when entering or changing information.

Action	Windows	Mac
Edit active cell	F2	Control + U
Delete selected content	Delete	Delete
Complete cell entry	Enter	Return
Cancel cell entry	Esc	Esc
Move to next cell	Tab	Tab
Move to previous cell	Shift + Tab	Shift + Tab
Insert current date	Ctrl + ;	Control + ;
Insert current time	Ctrl + Shift + ;	Command + ;
Repeat last action	F4	Command + Y
Copy formula/data down	Ctrl + D	Control + D
Copy formula/data right	Ctrl + R	Control + R

The F2 shortcut is especially useful when editing formulas or correcting text inside a cell without replacing the entire cell contents.

5. Excel Formatting Shortcuts

Formatting does not have to mean repeatedly opening the ribbon.

Action	Windows	Mac
Bold	Ctrl + B	Command + B
Italic	Ctrl + I	Command + I
Underline	Ctrl + U	Command + U
Format Cells	Ctrl + 1	Command + 1
Apply general format	Ctrl + Shift + ~	Control + Shift + ~
Apply number format	Ctrl + Shift + 1	Control + Shift + 1
Apply time format	Ctrl + Shift + 2	Control + Shift + 2
Apply date format	Ctrl + Shift + 3	Control + Shift + 3
Apply currency format	Ctrl + Shift + 4	Control + Shift + 4
Apply percentage format	Ctrl + Shift + 5	Control + Shift + 5
Apply scientific format	Ctrl + Shift + 6	Control + Shift + 6
Apply border	Ctrl + Shift + 7	Command + Option + 0

For everyday reporting, Ctrl/Command + 1 is one of the most useful shortcuts because it opens the Format Cells dialog.

6. Formula and Calculation Shortcuts

Formulas are at the heart of Excel, and shortcuts can make formula-heavy work much faster.

Action	Windows	Mac
Start a formula	=	=
AutoSum	Alt + =	Command + Shift + T
Show formulas	Ctrl + `	Control + `
Calculate workbook	F9	F9
Calculate active worksheet	Shift + F9	Shift + F9
Recalculate everything	Ctrl + Alt + F9	Control + Option + F9
Insert function	Shift + F3	Shift + F3
Toggle absolute reference	F4	Command + T
Copy formula down	Ctrl + D	Control + D
Copy formula right	Ctrl + R	Control + R

For example, if you are building a monthly budget, you can enter a SUM formula and then use the appropriate fill shortcut to apply the formula across a range rather than typing it repeatedly.

7. Data Management Shortcuts

Excel is often used to sort, filter, clean, and analyze information.

Action	Windows	Mac
Create table	Ctrl + T	Command + T
Toggle filters	Ctrl + Shift + L	Command + Shift + F
Open filter menu	Alt + Down Arrow	Option + Down Arrow
Flash Fill	Ctrl + E	Control + E
Insert cells	Ctrl + Shift + +	Control + Shift + +
Delete cells	Ctrl + –	Command + –
Insert row/column	Ctrl + Shift + +	Control + Shift + +
Delete row/column	Ctrl + –	Command + –
Paste Special	Ctrl + Alt + V	Command + Control + V
Refresh data	Ctrl + Alt + F5	Command + Option + F5

Flash Fill can be particularly useful when Excel recognizes a pattern. For example, if you have full names in one column and manually create the first few first-name examples in another column, Flash Fill may recognize the pattern and complete the remaining entries.

8. Worksheet Shortcuts

When a workbook contains multiple sheets, keyboard navigation becomes even more useful.

Action	Windows	Mac
Insert worksheet	Shift + F11	Shift + F11
Move to next sheet	Ctrl + Page Down	Option + Right Arrow
Move to previous sheet	Ctrl + Page Up	Option + Left Arrow
Move/copy worksheet	Alt + H, O, M	Use sheet menu
Select multiple sheets	Ctrl + click tabs	Command + click tabs
Rename selected sheet	Alt + O, H, R	Use sheet menu
Hide selected sheet	Alt + H, O, U, H	Use sheet menu
Unhide sheet	Alt + H, O, U, U	Use sheet menu

Some ribbon sequences are platform-specific, so Mac users should check the current Excel commands available in their version.

9. Row and Column Shortcuts

Rows and columns are much easier to manage when you know a few simple commands.

Action	Windows	Mac
Select column	Ctrl + Space	Control + Space
Select row	Shift + Space	Shift + Space
Insert row/column	Ctrl + Shift + +	Control + Shift + +
Delete row/column	Ctrl + –	Command + –
Hide selected rows	Ctrl + 9	Command + 9
Hide selected columns	Ctrl + 0	Command + 0
Unhide rows	Ctrl + Shift + 9	Command + Shift + 9
Unhide columns	Ctrl + Shift + 0	Command + Shift + 0

These shortcuts become especially helpful when cleaning reports or preparing worksheets for presentation.

10. Find, Search, and Review Shortcuts

Finding information manually in a large spreadsheet wastes time.

Use:

• Ctrl + F / Command + F — Find text or values
• Ctrl + H — Find and Replace on Windows
• Command + Shift + H — Find and Replace on supported Mac versions
• Ctrl + G — Go To
• F5 — Go To dialog in supported Windows versions
• Ctrl + A / Command + A — Select current region or all data depending on context
• Esc — Close or cancel a search-related action

The best shortcut here is often simply Ctrl + F or Command + F. If a workbook has hundreds or thousands of records, searching is much faster than scanning the worksheet.

11. Useful Advanced Excel Shortcuts

Once you are comfortable with the basics, these shortcuts can improve more advanced workflows:

• Ctrl + Shift + L — Turn filters on or off
• Ctrl + T — Create a table
• Ctrl + E — Flash Fill
• Ctrl + Shift + $ — Currency format
• Ctrl + Shift + % — Percentage format
• Ctrl + Shift + # — Date format
• Ctrl + Shift + @ — Time format
• Ctrl + Shift + ! — Number format
• Ctrl + Shift + ^ — Scientific format
• Ctrl + Shift + & — Apply outline border
• Ctrl + Shift + _ — Remove outline border
• Ctrl + Shift + “ — Copy value from cell above
• Ctrl + ‘ — Copy formula from cell above
• Alt + = — Insert AutoSum
• Ctrl + Shift + Enter — Enter an array formula in versions where this behavior applies

Shortcut behavior can change with Excel versions and operating systems, so Microsoft recommends checking the shortcut documentation for the specific Excel environment you use.

How to Learn Excel Shortcuts Quickly

You do not need to memorize all 100+ shortcuts at once.

A better approach is to learn them in groups.

Step 1: Learn the everyday shortcuts

Start with:

• Copy
• Paste
• Cut
• Undo
• Redo
• Save
• Find
• Select All

Step 2: Learn navigation

Next, practice:

• Ctrl/Command + Arrow
• Ctrl/Command + Home
• Ctrl/Command + End
• Page Up
• Page Down
• Worksheet navigation

Step 3: Learn formatting

Add:

• Bold
• Italic
• Underline
• Format Cells
• Currency
• Percentage
• Date

Step 4: Learn data shortcuts

Finally, learn:

• Filters
• Tables
• Flash Fill
• Paste Special
• Insert/delete rows and columns

The goal is not to remember every shortcut. The goal is to make your most common Excel tasks feel automatic.

Why Keyboard Shortcuts Can Make Excel Faster

The biggest advantage of Excel shortcuts is not that every command saves a huge amount of time.

It is the repetition.

If you save only two seconds each time you perform an action and repeat that action 100 times, you have already saved more than three minutes. Across a week or month, small improvements can add up.

For analysts, accountants, students, administrators, and other frequent Excel users, shortcuts can become part of a natural workflow.

Common Excel Shortcut Mistakes to Avoid

Not every shortcut works identically on every system.

Keep these points in mind:

1. Check your platform. Windows and Mac use different modifier keys for many commands.
2. Check your keyboard layout. Microsoft notes that Mac shortcut documentation is based on a US keyboard layout.
3. Check your Excel version. Some newer functions and commands may not exist in older versions.
4. Watch for add-ins. Office add-ins can register keyboard shortcuts and may create conflicts.
5. Do not memorize everything. Focus first on shortcuts that match your daily tasks.

For additional background about Excel itself, you can also explore the Microsoft Excel Wikipedia page.

FAQs

1. What are the most useful Excel shortcuts in 2026?

Some of the most useful shortcuts include Ctrl + C for copying, Ctrl + V for pasting, Ctrl + Z for undoing, Ctrl + S for saving, and Ctrl + F for finding information on Windows. Mac users generally use Command for common actions such as copy, paste, save, and find.

2. What is the shortcut for AutoSum in Excel?

On Windows, press Alt + = to insert the AutoSum function. Excel usually identifies a nearby range of numbers and prepares a SUM formula. Check Microsoft’s current shortcut reference if you use a Mac or a different Excel version.

3. How do I copy and paste in Excel?

Select the cell or range you want to copy, then press Ctrl + C followed by Ctrl + V on Windows. On Mac, use Command + C and Command + V. You can also use Paste Special when you need to copy only values, formulas, or formatting.

4. How can I select an entire row or column in Excel?

On Windows, press Ctrl + Space to select a complete column or Shift + Space to select a row. On Mac, the corresponding shortcuts may depend on your keyboard settings and Excel version. You can also select a row or column by clicking its heading.

5. Do Excel shortcuts work in Excel for the web?

Yes, Excel for the web supports many keyboard shortcuts, including common commands for editing and formatting. However, some combinations may behave differently because the application runs inside a browser. Browser shortcuts can also conflict with Excel commands.

6. Are Excel shortcuts different on Windows and Mac?

Yes. Many commands have similar functions across both platforms, but their key combinations are not always identical. Windows commonly uses Ctrl and Alt, while Mac often uses Command and Option. Keyboard layouts, operating system settings, and Excel versions can affect certain shortcuts.

7. How can beginners learn Excel shortcuts quickly?

Start with five to ten commands you use every day, such as save, copy, paste, undo, and find. Practise them while completing real spreadsheet tasks. Once they become familiar, move on to navigation, formatting, formulas, filters, and worksheet management.

8. Where can I find the official Excel keyboard shortcut list?

Microsoft maintains an official Excel keyboard shortcut guide covering Windows, Mac, and other supported platforms. Visit the Microsoft Excel keyboard shortcuts guide to check the combinations for your version.

Conclusion

This Excel shortcuts cheat sheet provides a practical starting point for anyone who wants to work more efficiently in spreadsheets. From everyday commands such as copy, paste, and save to advanced actions involving formulas, data filtering, and worksheet management, keyboard shortcuts can simplify many routine tasks.

You do not need to memorize every shortcut in this guide. Begin with the commands you use most often, practise them during your regular work, and gradually add more as your skills improve.

Remember that some shortcuts differ between Windows, Mac, and Excel for the web. For the most accurate information, consult Microsoft’s official documentation for your specific platform and version.

Keep this guide available as a quick reference, and use it to build a faster, more comfortable Excel workflow over time.