Skip to main content
HomeCheat sheetsSpreadsheets

Excel Shortcuts Cheat Sheet

Improve on your Excel skills with the handy shortcuts featured in this convenient cheat sheet!
Nov 2023  · 4 min read

Have this cheat sheet at your fingertips

Download PDF

Using Shortcuts in Excel

While every action in Excel can be performed by clicking on menu items or dialog boxes, this is often slower than pressing keys on your keyboard. Regular Excel users can gain productivity increases by making use of keyboard shortcuts. The shortcuts shown here are for the Windows versions of Excel. Most shortcuts are applicable to Excel in Office 365. Likewise most shortcuts can be used on MacOS by replacing CTRL with CMD.

Getting Help

Functionality

Shortcut

Open help browser

F1

Open keyboard shortcut browser

CMD + /

Manipulating Workbooks

Functionality

Shortcut

Open a workbook

CTRL+O

Save a workbook

CTRL+S

Close a workbook

CTRL+W

Insert new worksheet

SHIFT+F11

ALT+SHIFT+F1

Access Ribbon Tabs

Functionality

Shortcut

Open the File menu

ALT+F

Open the Home tab

ALT+H

Open the Insert tab

ALT+N

Open the Page Layout tab

ALT+P

Open the Formulas tab

ALT+M

Open the Data tab

ALT+A

Open the Review tab

ALT+R

Open the View tab

ALT+W

Functionality

Shortcut

Move one cell down

ENTER

Down arrow

Move one cell up

SHIFT+ENTER

Up arrow

Move one cell right

TAB

Right arrow

Move one cell left

SHIFT+TAB

Left arrow

Move one screen down

PageDown

Move one screen up

PageUp

Move one screen right

ALT+PageUp

Move one screen left

ALT+PageDown

Move to first row, first column

CTRL+Home

Move to last filled cell

CTRL+End

Zooming

Functionality

Shortcut

Zoom in

CTRL+ALT+=

Zoom out

CTRL+ALT+-

Editing

Functionality

Shortcut

Cut selection

CTRL+X

Copy selection

CTRL+C

Paste selection

CTRL+V

Open the Paste Special dialog

CTRL+ALT+V

Undo & Redo

Functionality

Shortcut

Undo last action

CTRL+Z

Redo last undone action

CTRL+Y

Selecting Cells

Functionality

Shortcut

Select the current column

CTRL+Space

Select the current row

SHIFT+Space

Select all cells from the current location downwards

SHIFT+PageDown

Select all cells from the current location upwards

SHIFT+PageUp

Select all cells from the current location rightwards

SHIFT+End

Select all cells from the current location leftward

SHIFT+Home

Select all completed cells

CTRL+A

Cell Entry

Functionality

Shortcut

Cancel your input to a cell

Esc

Write a new line within a cell

CTRL+Enter

Go to the end of the line

CTRL+End

Go to the start of the line

CTRL+Home

Insert a function

SHIFT+F3

Display function arguments (when cursor is to right of function name)

CTRL+A

Insert AutoSum formula

ALT+=

Insert hyperlink

CTRL+K

Insert current date

CTRL+;

Insert current time

CTRL+:

Insert a comment on the cell

CTRL+SHIFT+F2

Text Formatting

Functionality

Shortcut

Apply bold formatting

CTRL+B

Apply italic formatting

CTRL+I

Apply strikethrough formatting

CTRL+5

Apply general number formatting

CTRL+SHIFT+~

Apply scientific number formatting

CTRL+SHIFT+^

Apply currency format

CTRL+SHIFT+$

Apply percentage format

CTRL+SHIFT+%

Apply date format

CTRL+SHIFT+#

Apply time format

CTRL+SHIFT+@

Toggle hiding/displaying content

CTRL+6

Charts

Functionality

Shortcut

Create a chart of the selected data in new worksheet

F11

Create a chart of the selected data in current worksheet

ALT+F11

Refreshing Data

Functionality

Shortcut

Refresh external data in current worksheet

CTRL+F5

Refresh external data in all worksheets

CTRL+ALT+F5

Run all calculations in all open workbooks

CTRL+ALT+F9

Topics
Related

How to Earn a Microsoft Excel Certification in 2024: Top Tips and Resources

Discover step-by-step instructions, exam insights, and expert tips to achieve Excel certification.
Matt Crabtree's photo

Matt Crabtree

12 min

Top 25 Excel Interview Questions For All Levels

A guide to the most common Excel interview questions for beginner, intermediate, and advanced users to ace the technical interview.
Chloe Lubin's photo

Chloe Lubin

17 min

Do Spreadsheets Need a Rethink? With Hjalmar Gislason, CEO of GRID

Richie and Hjalmar Gislason explore the integral role of spreadsheets in today's data-driven world, the limitations of traditional Business Intelligence tools, and the transformative potential of generative AI in the realm of spreadsheets.
Richie Cotton's photo

Richie Cotton

54 min

Avoiding Burnout for Data Professionals with Jen Fisher, Human Sustainability Leader at Deloitte

Jen and Adel cover Jen’s own personal experience with burnout, the role of a Chief Wellbeing Officer, the impact of work on our overall well-being, the patterns that lead to burnout, the future of human sustainability in the workplace and much more.
Adel Nehme's photo

Adel Nehme

44 min

Becoming Remarkable with Guy Kawasaki, Author and Chief Evangelist at Canva

Richie and Guy explore the concept of being remarkable, growth, grit and grace, the importance of experiential learning, imposter syndrome, finding your passion, how to network and find remarkable people, measuring success through benevolent impact and much more. 
Richie Cotton's photo

Richie Cotton

55 min

Excel Regex Tutorial: Mastering Pattern Matching with Regular Expressions

Discover the power of Regular Expressions (RegEx) for pattern matching in Excel. Our comprehensive guide unveils how to standardize data, extract keywords, and perform advanced text manipulations.
Chloe Lubin's photo

Chloe Lubin

12 min

See MoreSee More