List of Excel Keyboard Shortcuts!..

Select the whole column

CTRL + SPACE

Select the whole row

SHIFT + SPACE

Select table

SHIFT + CTRL + SPACE bar

Save

CTRL + s

Select visible cells only

ALT + ;

Select entire region

CTRL + A

Select range from start cell to far left

SHIFT + Home

Select range from start cell to end in direction of arrow

SHIFT + End + arrow

Select a continuous range of data (e.g. pivot), no matter where your cursor is.

CTRL + *

Select blank cells

F5 + ALT + S + K + ENTER

Select all cells with comments

CTRL + SHIFT + O

Select all cells that are directly or indirectly referred to by formulas in the selection

CTRL + SHIFT + {

Select all cells with formulas that refer directly or indirectly to the active cell

CTRL + SHIFT + }

Selects all the way to a1 from cursor position

CTRL + SHIFT + HOME

Select cells in the direction of arrow

CTRL + SHIFT + Arrow

Previous sheet

Change the type of cell reference from relative to absolute or semi-absolute

NAVIGATION

CTRL + Page Up

Next sheet

NAVIGATION CTRL + Page Down

Launch GO TO Dialog (from here you can select special or jump to a cell or range)

NAVIGATION

F5

Go to top left (will go to top left of freezed pane if set)

NAVIGATION

CTRL + Home

Go to last non-blank cell

NAVIGATION

CTRL + end

Go to previous sheet

NAVIGATION

CTRL + PgUp

Go to next sheet

NAVIGATION

CTRL + PgDn

Print

NAVIGATION

CTRL + p

Toggle between workbooks in a given session of excel.

NAVIGATION

CTRL + TAB

FORMULAS

F4

Repeat whatever you did last

FORMULAS

F4

Debug portions of a formula (select and press)

FORMULAS

F9

Sum range

FORMULAS

ALT + =

Enter array formula FORMULAS CTRL + SHIFT + Enter

Select array formula range

FORMULAS

CTRL + /

Display range names (can be used when typing formulas)

FORMULAS

F3

Evaluate formulas. (its easy to remember when working with some “tuf” formulas!)

FORMULAS

ALT + TUF

Copy a formula from above cell and edit

FORMULAS

CTRL + ‘

Display the formula palette after you type a valid function name in a formula

FORMULAS

CTRL + A (while writing a formula)

Alternate between displaying cell values and displaying cell formulas

FORMULAS

CTRL + ` (Single Left Quotation Mark)

Calculate formulas

FORMULAS

F9

Select all precedent cells

FORMULAS

CTRL + [

Select all dependent cells

FORMULAS

CTRL + ]

Format Selection (cells, objects, charts)

FORMATTING

CTRL + 1

Bold a cell’s content

FORMATTING

Preview(opens in a new tab)

CTRL + B

Format Painter – Paste formats from selection FORMATTING ALT + EST

Format as number with 2 dp

FORMATTING

CTRL + SHIFT + 1

Format as local currency

FORMATTING

CTRL + SHIFT + 4

Format as percentage with 0 dp

FORMATTING

CTRL + SHIFT + 5

Hide row

FORMATTING

CTRL + 9

Hide column

FORMATTING

CTRL + 0

Unhide row

FORMATTING

CTRL + SHIFT + 9

Unhide column

FORMATTING

CTRL + SHIFT + 0

Display the style command format menu

FORMATTING

ALT + ‘

Sets/removes strikeout in current cell

FORMATTING

CTRL + 5

Show/hide the top bar when you have a group

FORMATTING

Crtl + 8

Single border around selected cells

FORMATTING

CTRL + SHIFT + 7

Sort FORMATTING ALT + DS

Insert hyperlink

FORMATTING

CTRL + K

Freeze panes

FORMATTING

ALT + WFF

Remove grid lines or (alt+t)ov(alt+g)[enter]

FORMATTING

ALT + WVG (2007+)

To wrap lines

FORMATTING

ALT + HW (2007+)

Save as

EXCEL OPTIONS

F12

Collapse the ribbon (press again to expand)

EXCEL OPTIONS

CTRL + F1

Opens print preview

EXCEL OPTIONS

CTRL + F2

Maximize the current window

EXCEL OPTIONS

ALT + SPACE X

Activate next window

EXCEL OPTIONS

ALT + TAB

Activate previous window

EXCEL OPTIONS

ALT + SHIFT + TAB

Close an excel workbook

crtl + F4

Split screens EXCEL OPTIONS ALT + W + S

Create a pivot table in new sheet (of course after selecting the range)

EVERYTHING ELSE

ALT + DPF

Create a pivot table in the same sheet.

EVERYTHING ELSE

ALT + DPN

Show visual basic editor

EVERYTHING ELSE

ALT + F11

Macro dialog

EVERYTHING ELSE

ALT + F8

Apply/remove filter

EVERYTHING ELSE

ALT + DFF

Keep filter on columns, but show all rows

EVERYTHING ELSE

ALT + DFS

Insert pivot table

EVERYTHING ELSE

ALT + NVT

Turn filter on or off

EVERYTHING ELSE

CTRL + SHIFT + L

Paste values only

EDITING

ALT + ESV

Edit a cell, place cursor at the end

EDITING

F2

Show in-cell drop down with previously entered values

EDITING

ALT + Down arrow

Fills down value from cell above EDITING CTRL + D

Add a comment or Edit comment

EDITING

SHIFT + F2

Insert new sheet

EDITING

SHIFT + F11

Insert row

EDITING

CTRL + +

Delete row

EDITING

CTRL + –

Copy

EDITING

CTRL + C

Paste

EDITING

CTRL + V

Cut

EDITING

CTRL + X

Undo

EDITING

CTRL + Z

Get a line break inside the cell

EDITING

ALT + Enter (while editing the cell)

Clear all contents

EDITING

ALT + EAA

Copy

EDITING

CTRL + insert

Paste EDITING SHIFT + Insert

Make chart/pivot chart

EDITING

F11

Edit a cell in Apple Macs

EDITING

CTRL + U

Copy the value from the cell above the active cell into the cell or the formula bar

EDITING

CTRL + SHIFT + “

Copies whatever is in the cell to the left of it.

EDITING

CTRL + R

Delete box (cell, row, column)

EDITING

ALT + ED

Insert box (cell, row, column)

EDITING

ALT + IE

Enter current date

AUTO COMPLETE

CTRL + ;

Enter current time

AUTO COMPLETE

CTRL + :

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s