If you use Microsoft Excel every day, you probably know the feeling: you start with a simple spreadsheet task, and 20 minutes later you’re still clicking through menus, scrolling around the worksheet, and formatting cells one by one.

There is a faster way.

Excel keyboard shortcuts can turn many repetitive tasks into two- or three-key commands. Once a few of them become second nature, you’ll notice that you’re reaching for the mouse less often and getting through spreadsheets much faster.

This Excel shortcuts cheat sheet brings together more than 100 useful shortcuts for editing, formatting, navigating worksheets, working with formulas, managing data, and much more.

You don’t need to memorize all of them. Start with the shortcuts you use most often and build from there.

Quick note: This guide focuses mainly on Excel for Windows. Mac and Excel for the web use some different shortcuts, so those differences are covered separately below.

Quick Excel Shortcuts Cheat Sheet

If you’re looking for the shortcuts you can start using immediately, here’s the short version.

If you’re new to Excel shortcuts, start with these 20. They’re useful enough to make an immediate difference without overwhelming you.

Basic Excel Shortcuts

Let’s start with the commands you’ll probably use more than anything else.

A few worth remembering immediately

Ctrl + S is one of those shortcuts that should become automatic. Save your workbook regularly, particularly when you’re working with important data.

Ctrl + Z is your safety net. Made a mistake? Undo it.

And F2 is incredibly useful when you need to edit the contents of a cell without reaching for the mouse.

Excel Shortcuts for Copying and Pasting

Copying and pasting sounds simple, but Excel gives you several shortcuts that can make the process much more efficient.

Paste Special

One of the most useful shortcuts for regular Excel users is:

Ctrl + Alt + V

It opens the Paste Special options.

This is particularly handy when you want to paste values only, formatting only, formulas, or another specific part of the copied data instead of bringing everything across.

For example, if you’ve copied a formula but only want the resulting numbers in another location, Paste Special → Values is much cleaner than copying and then manually removing formulas.

Excel Navigation Shortcuts

Large spreadsheets can become difficult to navigate quickly.

If your worksheet has 5,000 rows, scrolling isn’t exactly the most efficient way to get around.

These shortcuts help.

The shortcut that saves a lot of scrolling

Try Ctrl + Down Arrow inside a column containing continuous data.

Excel jumps to the edge of that data range.

The same principle works horizontally with Ctrl + Right Arrow.

Once you get used to these, moving around a large spreadsheet becomes considerably easier.

Excel Shortcuts for Selecting Data

Selecting data with a mouse is fine for a small worksheet. It’s less convenient when you’re working with thousands of cells.

Select an entire column

Click any cell in a column and press:

Ctrl + Space

The entire column is selected.

For a complete row:

Shift + Space

These are small shortcuts, but they’re surprisingly useful when you’re formatting, deleting, copying, or moving large amounts of data.

Excel Formatting Shortcuts

Formatting can eat up a lot of time if you’re constantly opening menus.

These shortcuts cover many of the basics.

The Ctrl + 1 shortcut is worth knowing

If you frequently format spreadsheets, remember:

Ctrl + 1

It opens the Format Cells dialog box.

From there, you can control number formats, alignment, fonts, borders, fills, and protection settings.

Instead of hunting through the Ribbon, you get everything in one place.

Excel Shortcuts for Rows and Columns

Need to insert, delete, hide, or select rows and columns?

These are the shortcuts to know.

For example, select a row with Shift + Space, then press Ctrl + + to insert a new row.

It’s much quicker than right-clicking the row number and searching through the menu.

Excel Shortcuts for Entering Data

If your job involves entering information into Excel all day, these shortcuts are particularly useful.

Add a new line inside a cell

Press:

Alt + Enter

This lets you put multiple lines of text inside one cell.

It’s useful for addresses, notes, descriptions, instructions, and similar information.

Enter today’s date

Press:

Ctrl + ;

Excel inserts the current date into the selected cell.

Excel Formula Shortcuts

Formulas are where Excel really starts to become powerful.

These shortcuts can make working with formulas considerably easier.

AutoSum

One of the most useful formula shortcuts is:

Alt + =

Excel automatically suggests a SUM formula based on nearby data.

For example, if you have monthly sales figures in cells B2:B13, placing your cursor below them and pressing Alt + = can quickly create the total.

F4 and Absolute Cell References

If you’ve ever copied a formula and watched the cell references change when you didn’t want them to, F4 is your friend.

Suppose your formula is:

=A2*B2

If you need to lock a reference, you can use F4 to cycle through reference types such as:

A2

$A$2

A$2

$A2

This becomes especially important when building formulas that you’ll copy across multiple rows or columns.

Excel Shortcuts for Tables

Excel Tables are extremely useful for structured data such as sales records, customer lists, inventory, expenses, and project data.

Create a table quickly

Select your data and press:

Ctrl + T

Excel opens the Create Table dialog.

If your first row contains column headings, make sure Excel recognizes them as headers.

Excel Sorting and Filtering Shortcuts

Filtering is one of the first things many Excel users need when dealing with large datasets.

For example, imagine you have 10,000 customer records and only want to see customers from one city.

Turn on filters with:

Ctrl + Shift + L

Then use the column’s filter menu to narrow down the results.

Excel Worksheet Shortcuts

Moving between worksheets doesn’t have to involve clicking sheet tabs.

If your workbook has tabs such as January, February, March, April, you can move between them quickly with Ctrl + Page Up and Ctrl + Page Down.

Excel Shortcuts for Finding and Replacing Data

Searching manually through a large spreadsheet is a waste of time.

Use:

Ctrl + F

to find specific text, numbers, or other information.

Use:

Ctrl + H

when you want to find something and replace it with something else.

For example, if a product name was entered incorrectly 200 times, you don’t need to fix every cell manually. Find and Replace can handle the repetitive work for you.

Excel Function Key Shortcuts

The function keys at the top of your keyboard have several useful Excel functions.

Some function-key behavior can vary depending on your keyboard, operating system, Excel version, and laptop settings.

Excel Chart Shortcuts

Creating charts can also be done from the keyboard.

Select the data you want to visualize and press Alt + F1.

Excel will create a chart using the selected data.

Excel Shortcuts for Mac

Excel on Mac shares many shortcuts with the Windows version, but the keys aren’t always identical.

In many common cases, Command replaces Ctrl.

Not every Windows shortcut has a direct Mac equivalent, so it’s worth checking Microsoft’s current documentation if you’re using Excel on macOS.

Excel for the Web Shortcuts

Excel for the web works inside a browser, so there can be some differences from desktop Excel.

Common shortcuts include:

Browser shortcuts can sometimes conflict with Excel for the web, so behavior may differ depending on your browser and operating system.

25 Excel Shortcuts You Should Memorize

Trying to memorize 100+ shortcuts on day one isn’t necessary.

Start with these:

If you can use these without thinking, you’re already well ahead of someone who relies on the mouse for every task.

Excel Shortcuts for Beginners: Where Should You Start?

If you’re completely new to Excel keyboard shortcuts, don’t try to learn everything on this page at once.

Start with five categories.

First: Editing

Learn:

Ctrl + C → Ctrl + V → Ctrl + X → Ctrl + Z

These are universal and you’ll use them constantly.

Second: Navigation

Learn:

Ctrl + Arrow

This will save you a lot of scrolling.

Third: Formatting

Learn:

Ctrl + 1

It gives you quick access to Excel’s formatting options.

Fourth: Data

Learn:

Ctrl + T and Ctrl + Shift + L

These are particularly useful for tables and filters.

Fifth: Formulas

Learn:

Alt + =

It’s one of the quickest ways to create a SUM formula.

Once these become familiar, add more shortcuts gradually.

How Much Time Can Excel Shortcuts Actually Save?

It depends on how much Excel work you do.

If you only open Excel occasionally to make a simple list, shortcuts probably won’t make a dramatic difference.

But if you spend several hours a day working with spreadsheets, the small savings add up.

Think about a task you perform 50 times a day that takes five seconds with the mouse but two seconds with a shortcut.

That’s 150 seconds saved every day.

Over hundreds of working days, those small improvements become meaningful.

The bigger benefit, though, is less interruption. When common commands become muscle memory, you can keep your attention on the data rather than constantly searching menus.

Frequently Asked Questions

What is the most useful Excel shortcut?

There isn’t one shortcut that’s best for everyone. For general use, Ctrl + C, Ctrl + V, Ctrl + Z, Ctrl + S, Ctrl + F, F2, Ctrl + 1, and Ctrl + T are excellent starting points.

What is the shortcut for copy and paste in Excel?

On Windows, use Ctrl + C to copy and Ctrl + V to paste. On Mac, use Command + C and Command + V.

What is the shortcut for AutoSum?

Press Alt + = on Windows to quickly insert an AutoSum formula.

What is the shortcut to create a table in Excel?

Press Ctrl + T after selecting your data.

What is the Excel shortcut for filtering?

Press Ctrl + Shift + L to turn filters on or off.

How do I edit a cell without using the mouse?

Select the cell and press F2.

How do I select an entire Excel column?

Click a cell in the column and press Ctrl + Space.

How do I select an entire row in Excel?

Click a cell in the row and press Shift + Space.

How do I move between Excel worksheets?

Use Ctrl + Page Down for the next worksheet and Ctrl + Page Up for the previous worksheet.

What is the shortcut for today’s date in Excel?

Press Ctrl + ; to enter the current date.

What is the shortcut for a new line inside an Excel cell?

Press Alt + Enter while editing the cell.

Are Excel shortcuts different on Mac?

Yes. Many shortcuts are similar, but some combinations differ between Windows and Mac. Excel for the web can also have its own differences.

Final Thoughts

You don’t need to become an Excel keyboard-shortcut expert overnight.

Start with the commands you use every day. Learn copy and paste, undo, save, find, F2, and Ctrl + Arrow first. Then add shortcuts for formatting, tables, filtering, formulas, and worksheets as you become more comfortable.

The goal isn’t to memorize a giant list.

The goal is to make the repetitive parts of Excel disappear into muscle memory.

Keep this Excel shortcuts cheat sheet bookmarked, learn a handful of shortcuts at a time, and you’ll gradually find yourself doing more in Excel without reaching for the mouse.

Tip: Microsoft regularly updates its Excel documentation, so if a shortcut behaves differently on your particular version of Excel, operating system, or keyboard, check Microsoft’s official Excel keyboard-shortcut reference for the latest information.