Pular para o conteúdo principal
InicioCheat sheetsSpreadsheets

Excel Shortcuts Cheat Sheet

Improve on your Excel skills with the handy shortcuts featured in this convenient cheat sheet!
nov. de 2023  · 4 min leer

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

Temas
Relacionado

Cheat sheet

Data Manipulation in Excel Cheat Sheet

Discover how to manipulate data in Excel using this convenient cheat sheet!
Adel Nehme's photo

Adel Nehme

4 min

Cheat sheet

Excel Formulas Cheat Sheet

Learn the basics of Excel with our quick and easy cheat sheet. Have the basics of formulas, operators, math functions and more at your fingertips.
Richie Cotton's photo

Richie Cotton

18 min

Cheat sheet

Bash & zsh Shell Terminal Basics Cheat Sheet

Improve your Bash & zsh Shell skills with the handy shortcuts featured in this convenient cheat sheet!
Richie Cotton's photo

Richie Cotton

6 min

Cheat sheet

LaTeX Cheat Sheet

Learn everything you need to know about LaTeX in this convenient cheat sheet!
Richie Cotton's photo

Richie Cotton

Cheat sheet

Working with Tables in Power Query M in Power BI

Learn how to work with tables in Power Query M in Power BI in this convenient cheat sheet!
Richie Cotton's photo

Richie Cotton

6 min

Cheat sheet

Markdown Cheat Sheet

Learn everything you need to know about Markdown in this convenient cheat sheet!
Richie Cotton's photo

Richie Cotton

See MoreSee More