Voir iotafinance en FrançaisYou are viewing the English version of iotafinance.comIotafinance auf Deutsch sehen
Icon for the financial resource section

Keyboard shortcuts in Excel for macOS

EDITING

Add current date
control  +  Shift  +   ;

Add current time
command  +  Shift  +   ;

Copy
command  +   C

Copy formula from the cell above into the active cell
control  +   '

Copy value from the cell above into the active cell
command  +  Shift  +  

Cut
command  +   X

Define a name for a cell
command  +   F3

Display shortcut menu
Shift  +   F10

Edit active cell
control  +   U

Fill down
control  +   D

Fill right
control  +   R

Font formatting dialog
control  +  Shift  +   P

Hide column(s)
control  +   0

Hide row(s)
control  +   9

Insert column
command  +   +

Insert or edit cell comments
Shift  +   F2

Insert row
command  +   +

Insert worksheet
Shift  +   F11

Open dialog to insert a hyperlink
control  +   K

Open the list of validation choices on a cell that uses data validation
option  +   Arrow down

Paste
command  +   V

Paste special
control  +  command  +   V

Repeat last command or action
command  +   Y

Start new line within cell
control  +  option  +   Enter

Sum selected cells
command  +  Shift  +   T

Table creation dialog
command  +   T

Toggle references
command  +   T

Undo last command or action
command  +   Z

FORMATTING

Apply currency format with two decimal places
command  +   $

Apply number format with two decimal places
command  +  Shift  +   !

Apply outline border to selected cell(s)
control  +  Shift  +   &

Apply percentage format with no decimal places
control  +  Shift  +   %

Bold characters
command  +   B

Display format cells menu
command  +   1

Italic characters
command  +   I

Remove outline border from selected cell(s)
control  +  Shift  +   _

Strikethrough
control  +   5

Underline text
command  +   U

NAVIGATE

Bold characters
control  +   2

Display «Go to» dialog box
F5

Italic characters
control  +   3

Move one cell down

Move one cell to the left

Move one cell to the right

Move one cell to the right in a worksheet
Tab

Move one cell up

Move one screen height down in a worksheet

Move one screen height up in a worksheet

Move one screen width to the left in a worksheet
option  +   Page Up

Move one screen width to the right in a worksheet
option  +   Page Down

Move to left edge of current data region
command  +   Arrow left

Move to lower edge of current data region
command  +   Arrow down

Move to previous cell in worksheet or previous option in dialog
Shift  +   Tab

Move to right edge of current data region
command  +   Arrow right

Move to the next sheet in the workbook
command  +   Page Down

Move to the previous sheet in the workbook
command  +   Page Up

Move to upper edge of current data region in worksheet
command  +   Arrow up

Underline text
control  +   4

FILES

Close the active workbook
command  +   W

Create a new workbook
command  +   N

Display «Save as » dialog box
command  +  Shift     S

Open workbook
command  +   O

Save file
command  +   S

DISPLAY

Display or hide grouping controls
control  +   8

SELECTION

Cycle through floating objects, such as shapes, text boxes or images
control  +  option  +   5

Extend current selection by one cell or row downwards
Shift  +   Arrow down

Extend current selection by one cell or row to the left
Shift  +   Arrow left

Extend current selection by one cell or row to the right
Shift  +   Arrow right

Extend current selection by one cell or row to the top
Shift  +   Arrow up

Select entire row
Shift  +   Space

Select entire sheet
command  +   A

Select range of non-empty cells around the active cell
control  +  Shift  +   *

OTHERS

Calculate all worksheets on all open workbooks
F9

Check spelling in the active worksheet or selected range
F7

Close Excel
command  +   F4

Expand or collapse the ribbon
option  +  command  +   R

Find
command  +   F

Find and replace
command  +  Shift  +   H

Print preview
command  +   P

Switch between hiding an displaying objects on the worksheet
control  +   6