239 Excel Shortcuts for Windows & Mac

239 Excel Shortcuts for Windows & Mac


Where shortcut keys must be pressed together they will be shown like this

Ctrl + P


which means press CTRL and P together.

Where keys must be pressed one after the other they will be shown like this


Alt + H , A C


which means press Alt and H together, then release those keys and press A, then C.

 

 

General

Open help

F1

Undo last action

Ctrl + Z

Redo last action

Ctrl + Y

Copy selection

Ctrl + C

Repeat last action

F4

Cut selection

Ctrl + X

Paste content from clipboard

Ctrl + V

Display the Paste Special dialog box

Ctrl + Alt + V

Display find and replace with Find tab selected

Ctrl + F

Display find and replace with Replace tab selected

Ctrl + H

Find previous match (after initial Find)

Ctrl + Shift + F4

Find next match (after initial Find)

Shift + F4

Insert embedded chart

Alt + F1

Insert chart in new sheet

F11

Toggle Autofilter

Ctrl + Shift + L

Activate filter

Alt + 

Create table

Ctrl + T OR Ctrl + L

Select table row

Shift + Space

Select table column

Ctrl + Space

Select table (when active cell is in table)

Ctrl + A

Clear slicer filter

Alt + C

Run Spellcheck

F7

Open Thesaurus

Shift + F7

Open Macro dialog box

Alt + F8

Open VBA Editor

Alt + F11

Duplicate object, formula, text

Ctrl + D

Snap to grid (whilst dragging)

Alt

Hide or show objects

Ctrl + 6

Open Modify Cell Style dialog box

Alt + '

Show right-click menu

Shift + F10

Display control menu

Alt Space

 

Worksheet

Insert new worksheet

Shift + F11

Go to next worksheet

Ctrl + PgDn

Go to previous worksheet

Ctrl + PgUp

Rename current worksheet

Alt + O , H R

Delete current worksheet

Alt + E , L

Move current worksheet

Alt + E , M

Move between the worksheet, Ribbon, task pane and zoom controls in a worksheet that has been split

F6 OR Shift + F6

Select adjacent worksheets

Ctrl + Shift + PgUp/PgDn

Select non-adjacent worksheets

Ctrl + Click

Toggle scroll lock

ScrLk

Toggle full screen

Ctrl + Shift + F1

Print

Ctrl + P

Open print preview window

Ctrl + F2

Set print area

Alt + P , R S

Clear print area

Alt + P , R C

Zoom in

Ctrl + Mouse Wheel Up

Zoom out

Ctrl + Mouse Wheel Down

Protect sheet

Alt + R , P S

 

Workbook

Create new workbook

Ctrl + N

Open workbook

Ctrl + O

Save workbook

Ctrl + S

Save as

F12

Go to next workbook

Ctrl + Tab

Go to previous workbook

Ctrl + Shift + Tab

Minimize current workbook window

Ctrl + F9

Maximize current workbook window

Ctrl + F10

Protect workbook

Alt + R , P W

Close current workbook

Ctrl + F4

Close Excel

Alt + F4

 

Ribbon

Expand or collapse ribbon

Ctrl + F1

Activate access keys

Alt

Move through Ribbon tabs and groups

   

Activate or open selected control

Space OR Enter

Confirm control change

Enter

Get help on selected control

F1

 

Drag and Drop (After Selecting Cells)

Drag and cut

Drag

Drag and copy

Ctrl + Drag

Drag and insert

Shift + Drag

Drag and insert copy

Ctrl + Shift + Drag

Drag to worksheet

Alt + Drag

Drag to duplicate worksheet

Ctrl + Drag

 

Navigation

Move one cell right

Move one cell left

Move one cell up

Move one cell down

Move one screen right

Alt + PgDn

Move one screen left

Alt + PgUp

Move one screen up

PgUp

Move one screen down

PgDn

Move to right edge of data region

Ctrl + 

Move to left edge of data region

Ctrl + 

Move to top edge of data region

Ctrl + 

Move to bottom edge of data region

Ctrl + 

Move to beginning of row

Home

Move to last cell in worksheet that contains data

Ctrl + End

Move to first cell in worksheet

Ctrl + Home

Turn End mode on

End

 

Active Cell

Select active cell (when multiple cells already selected)

Shift + Backspace

Show the active cell on worksheet

Ctrl + Backspace

Move active cell clockwise to corners of selection

Ctrl + .

Move active cell down in selection - wrap to next column

Enter

Move active cell up in selection - wrap to previous column

Shift + Enter

Move active cell right in a selection - wrap to next row

Tab

Move active cell left in a selection - wrap to previous row

Shift + Tab

 

Selection

Select entire row

Shift + Space

Select entire column

Ctrl + Space

Select current region if worksheet contains data. Press again to select current region and summary rows. Press again to select entire worksheet.

Ctrl + A

Expand selection

Shift + Click

Add non-adjacent cells to selection

Ctrl + Click

Move right between non-adjacent selections

Ctrl + Alt + 

Move left between non-adjacent selections

Ctrl + Alt + 

Toggle 'Add to Selection' mode

Shift + F8

Exit 'Add to Selection' mode

Esc

 

Extend Selection

Extend selection right

Shift + 

Extend selection left

Shift + 

Extend selection up

Shift + 

Extend selection down

Shift + 

Extend the selection to the last cell on the right that contains data, or to the next cell that contains data, or to the last column

Ctrl + Shift + 

Extend the selection to the last cell on the left that contains data, or to the next cell that contains data, or to the first column

Ctrl + Shift + 

Extend the selection to the last cell up that contains data, or to the next cell that contains data, or to the first row

Ctrl + Shift + 

Extend the selection to the last cell down that contains data, or to the next cell that contains data, or to the last row

Ctrl + Shift + 

Extend selection up one screen

Shift + PgUp

Extend selection down one screen

Shift + PgDn

Extend selection right one screen

Alt + Shift + PgDn

Extend selection left one screen

Alt + Shift + PgUp

Extend selection to start of row(s)

Shift + Home

Extend selection to first cell in worksheet

Ctrl + Shift + Home

Extend selection to last cell in worksheet

Ctrl + Shift + End

Toggle 'Extend Selection' mode

F8

Cancel 'Extend Selection' mode

Esc

 

Select Special

Display 'Go To' dialog box

Ctrl + G OR F5

Select cells with comments

Ctrl + Shift + O

Select current region around active cell

Ctrl + Shift + *

Select current region

Ctrl + A

Select direct precedents

Ctrl + [

Select all precedents

Ctrl + Shift + {

Select direct dependents

Ctrl + ]

Select all dependents

Ctrl + Shift + }

Select visible cells only

Alt + ;

 

Cell Edit Mode

Edit the active cell

F2

Insert or edit comment

Shift + F2

Delete comment

Shift + F10 , M

Cancel editing

Esc

Select one character right

Shift + 

Select one character left

Shift + 

Move one word right

Ctrl + 

Move one word left

Ctrl + 

Select one word right

Ctrl + Shift + 

Select one word left

Ctrl + Shift + 

Select to beginning of cell

Shift + Home

Select to end of cell

Shift + End

Delete to end of line

Ctrl + Delete

Delete character to left of cursor

Backspace

Delete character to right of cursor

Delete

Start a new line in the same cell

Alt + Enter

 

Entering Data

Enter data and move down

Enter

Enter data and move up

Shift + Enter

Enter data and move right

Tab

Enter data and move left

Shift + Tab

Enter data and stay in same cell

Ctrl + Enter

Enter same data in multiple cells (after copying, then selecting cells)

Enter

Insert current date

Ctrl + ;

Insert current time

Ctrl + Shift + :

Fill down from cell above

Ctrl + D

Fill right from cell on left

Ctrl + R

Copy formula from cell above (formula is exact copy)

Ctrl + '

Copy value from cell above

Ctrl + Shift + "

Insert hyperlink

Ctrl + K

Display AutoComplete list

Alt + 

Flash fill

Ctrl + E

 

Formatting

Format cells

Ctrl + 1

Display Format Cells with Font tab selected

Ctrl + Shift + F

Apply or remove bold

Ctrl + B

Apply or remove italics

Ctrl + I

Apply or remove underscore

Ctrl + U

Apply or remove strikethrough

Ctrl + 5

Align center

Alt + H , A C

Align left

Alt + H , A L

Align right

Alt + H , A R

Indent

Alt + H , 6

Remove indent

Alt + H , 5

Wrap text

Alt + H , W

Align top

Alt + H , A T

Align middle

Alt + H , A M

Align bottom

Alt + H , A B

Increase font size one step

Alt + H , F G

Decrease font size one step

Alt + H , F K

 

Number Formatting

Apply general format

Ctrl + Shift + ~

Apply number format

Ctrl + Shift + !

Apply time format

Ctrl + Shift + @

Apply date format

Ctrl + Shift + #

Apply currency format

Ctrl + Shift + $

Apply percentage format

Ctrl + Shift + %

Apply scientific format

Ctrl + Shift + ^

 

Borders

Open list of border styles from Ribbon

Alt + H , B

Add border around selected cells

Ctrl + Shift + &

Add or remove right border

Alt + H , B R

Add or remove left border

Alt + H , B L

Add or remove top border

Alt + H , B P

Add or remove bottom border

Alt + H , B O

Add all borders to all cells in selection

Alt + H , B A

Remove borders

Ctrl + Shift + -

 

Formulas

Begin entering a formula

= OR +

Toggle absolute and relative references (in cell edit mode)

F4

Open the Insert Function Dialog Box

Shift + F3

Autosum

Alt + =

Toggle displaying formulas on and off

Ctrl + `

Insert function arguments

Ctrl + Shift + A

Enter array formula

Ctrl + Shift + Enter

Calculate worksheets

F9

Calculate active worksheet

Shift + F9

Force calculate all worksheets

Ctrl + Alt + F9

Evaluate part of a formula (in cell edit mode)

F9

Expand or collapse the formula bar

Ctrl + Shift + U

Display function arguments dialog box

Ctrl + A

Open Name Manager

Ctrl + F3

Create name from values in row(s)/column(s)

Ctrl + Shift + F3

Paste name into formula

F3

Accept function with auto-complete

Tab

 

Rows and Columns

Display Insert Dialog box

Ctrl + +

Insert selected number of rows

Ctrl + +

Insert selected number of columns

Ctrl + +

Display Delete dialog box

Ctrl + -

Delete selected number of rows

Ctrl + -

Delete selected number of columns

Ctrl + -

Delete contents of selected cells

Delete

Hide columns

Ctrl + 0

Hide rows

Ctrl + 9

Unhide rows

Ctrl + Shift + 9

Group rows or columns (with rows/columns selected)

Alt + Shift + 

Ungroup rows or columns (with rows/columns selected)

Alt + Shift + 

Open Group Dialog Box (no rows/cols selected)

Alt + Shift + 

Open Ungroup Dialog Box

Alt + Shift + 

Hide or show outline symbols

Ctrl + 8

 

Pivot Tables

Create pivot table

Alt + N , V

Select entire pivot table

Ctrl + A

Group pivot table items

Alt + Shift + 

Ungroup pivot table items

Alt + Shift + 

Hide (filter out) pivot table item

Ctrl + -

Unhide (clear filter on) pivot table item

Alt + H , S C

Insert pivot chart

Alt + N , S Z C

 

Dialog Boxes

Move to next control

Tab

Move to previous control

Shift + Tab

Move to next tab

Ctrl + Tab

Move to previous tab

Ctrl + Shift + Tab

Accept and apply

Enter

Check and uncheck box

Space

Cancel and close the dialog box

Esc

 

Post a Comment

Previous Post Next Post