80 of the Most Useful Excel Shortcuts

Excel at using Excel with these keyboard hotkeys that will save you minutes of time—and hours of aggravation.

You may not realize it, but clicking around an Excel spreadsheet with your mouse is wasting time—your precious time. There are hundreds of Excel shortcuts that you can use to complete a task without moving a hand off the keyboard. These shortcuts, also called hotkeys, consist of two or more keys pressed at the same time. Here are some of the most useful Excel hotkeys to make a wide range of spreadsheet tasks easier.

Save even more time by committing these Windows keyboard shortcuts and Word shortcuts to memory.

General

These are some simple Excel shortcuts that everyone needs, no matter what type of spreadsheets you’re creating.

General Excel shortcuts on a PC

COMMANDACTION
CTRL + WClose a workbook
CTRL + OOpen a workbook
CTRL + SSave a workbook
CTRL+CCopy text
CTRL+VPaste text
CTRL + ZUndo shortcut
CTRL + YRedo something you just undid
Shift + spacebarSelect the row
ALT + I + RExcel insert row shortcut (Add a new row above the one you selected.)
CTRL + –Excel delete row shortcut (The row you have selected will disappear.)
Shift + Control + ArrowInstantly move to the bottom of the data set. In addition, this auto-selects the entire range for fast copying

Print This Chart

General Excel shortcuts on MacOS

COMMANDACTION
Command + WClose a workbook
Command +NOpen a workbook
Command + SSave a workbook
Command + CCopy text
Command + VPaste text
Command + ZUndo shortcut
Command + YRedo something you just undid
Shift + Command + ArrowInstantly move to the bottom of the data set. In addition, this auto-selects the entire range for fast copying

Print This Chart

Working on an Apple? You’ll definitely want to know about these 41 Mac keyboard shortcuts.

Navigating Excel

Navigating with Excel hotkeys is typically different, depending on the operating system you’re using. Also, some navigation hotkeys don’t have equivalents in the other operating system.

Navigating Excel on a PC

COMMANDACTION
ALT + HGo to the Home tab
ALT + AGo to the Data tab
Command + TabSwitch to the next application
ALT + NGo to the Insert tab
ALT + PPage Layout tab
ALT + WSwitch to the View tab
Shift + F10Open the context menu
ALT + MGo to the Formula tab
TabMove to the next option, box, control, or command
Shift + TabMove to the previous box, option, control, or command

Print This Chart

Find out the top Windows 10 keyboard shortcuts.

Navigating Excel on a Mac

COMMANDACTION
Command + Option + RMinimize or maximize ribbon tabs
Command + Shift + TabSwitch to the next application
TabMove to the next option, box, control, or command
Shift + TabMove to the previous box, option, control, or command

These 11 keyboard shortcuts make web browsing ten times easier.

Selecting cells, rows, columns, etc.

When navigating through cells, rows, and columns the Excel shortcut keys are the same, no matter what operating system you use. Just press Shift + arrow keys to select a single cell or a range of cells. For columns, click on a cell in the column you want to select and then press CTRL + spacebar. Selecting a row is just as easy. Choose a cell in the row you want to select, and then press Shift + spacebar.

There is also an Excel hotkey for selecting a table or list. Choose a cell in the table or list and press CTRL + A.

Apple fan? Here are 9 Mac keyboard shortcuts every Mac user should know.

Formatting and editing cells

Formatting cells using Excel shortcuts is a lot faster than choosing options from menus. These are the most useful ones to know:

Formatting and editing cells on a PC

COMMANDACTION
CTRL + BBold
CTRL + IItalic
CTRL + 9Hide selected rows
CTRL + Shift + (Unhide selected rows
CTRL + 0Hide selected columns
CTRL + Shift + )Unhide selected columns
CTRL + ;Insert the current date
CTRL + Shift + ;Insert the current time
Command + KInsert a hyperlink
CTRL + Shift + %Change data to percentage format
CTRL + FFind something
CTRL + HReplace something
CTRL + SHIFT + $Show all values as currency
CTRL + SHIFT + ~Show all values in general number format
CTRL + 5Excel strikethrough shortcut: strikethrough text or remove it
ALT + EnterExcel cell shortcut: Add a new line in Excel

Print This Chart

Formatting and editing cells on a Mac

COMMANDACTION
Command + BBold
Command + IItalic
Command + 9Hide selected rows
Command + Shift + (Unhide selected rows
Command + 0Hide selected columns
Command + Shift + )Unhide selected columns
CTRL + ;Insert the current date
Command + ;Insert the current time
Command + KInsert a hyperlink
Command + FFind and replace values
CTRL + SHIFT + $Show all values as currency
CTRL + SHIFT + ~Show all values in general number format
CTRL + 5Strikethrough text or remove it

Pro tip: ALT + H + B + A applies a border to your selected data. “This shortcut allows me to highlight the most important columns or rows on the spreadsheet at first glance,” says Aaron Simmons, founder of TestPrepGenie.com. “Using ALT+H+B+A takes time to get used to but once you get a hang of it, you can easily apply borders on cells without spending time choosing from the box on the side or from the toolbar.

Print This Chart

Formula shortcuts

Excel formula shortcuts are for more advanced users, but they are lifesavers if you have a lot to do.

Formula shortcuts on a PC

COMMANDACTION
ALT + ‘Toggle cell formulas
CTRL + Shift + EnterCreate an array formula
F9Evaluate a formula
CTRL + Shift + UHide or show the formula bar

Formula shortcuts on a Mac

COMMANDACTION
Control + ‘Toggle cell formulas
CTRL + Shift + EnterCreate an array formula
F9 + FnEvaluate a formula
CTRL + Shift + UHide or show the formula bar

Pro tip: “My favorite Excel keyboard shortcut is hands down F4! I work as an accountant for small businesses, so I do a lot of manual Excel reports and this saves me hours of work,” says Jennifer Miskelly. “Ever create a formula and drag it down only to realize that you need one part of the formula to stay constant and the other part to continue in sequence? Instead of spending an hour going through every cell and typing each formula, press F4 until the $ sign is applied to the part of the formula that you need to stay constant, then drag until you no longer need it.” Note: Mac users use F4 + Fn. Find out what all those computer “F” keys do.

Create a hotkey

If you find a PC Excel shortcut that you like and you use a Mac, you can always make your own hotkey by using Microsoft’s quick guide. For PC and Mac users, you can also set up a macro for a new hotkey using these steps.

Next, check out these most useful Zoom shortcuts that’ll make your life easier.

Popular Videos

Alina Bradford
Alina Bradford is an award-winning writer of tech, health and science topics. Her work has been featured by CBS, CNET, MTV, USA Today and many more. Vistit her website at alinabradford.com.