Shortcut keys in MS excel to improve your efficiency at work

 

Here is another mind blowing blog with some reliable information on Shortcut keys in MS excel. Do not worry I will not talk about Cut, Copy, Paste. It is beyond that. I am 100% sure that after reading these shortcut keys your work efficiency will improved to a significant extent.

I also request you to open an excel sheet with some dummy data and use these shortcut keys. Please also read my another blog on Shortcut keys in SAP .

Shortcut Keys related to Selection of content

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

 

 

Shortcut keys related to Navigation in Excel sheet

 

Previous sheet

CTRL + Page Up

 

Next sheet

CTRL + Page Down

 

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

F5

 

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

CTRL + Home

 

Go to last non-blank cell

CTRL + end

 

Go to previous sheet

CTRL + PgUp

 

Go to next sheet

CTRL + PgDn

 

Print

CTRL + p

 

Toggle between workbooks in a given session of excel.

CTRL + TAB

 

Shortcut keys related to FORMULAS in MS Excel

 

Sum range

ALT + =

 

Display range names (can be used when typing formulas)

F3

 

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

ALT + TUF

 

Copy a formula from above cell and edit

CTRL + ‘

 

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

CTRL + A (while writing a formula)

 

Alternate between displaying cell values and displaying cell formulas

CTRL + ` (Single Left Quotation Mark)

 

Excel short keys related to Data formatting

Open format cells

CTRL + 1

 

Bold a cell’s content

CTRL + B

 

Format Painter – Paste formats from selection

ALT + EST

 

Format as number with 2 dp

CTRL + SHIFT + 1

 

Format as local currency

CTRL + SHIFT + 4

 

Format as percentage with 0 dp

CTRL + SHIFT + 5

 

Hide row

CTRL + 9

 

Hide column

CTRL + 0

 

Unhide row

CTRL + SHIFT + 9

 

Unhide column

CTRL + SHIFT + 0

 

Display the style command format menu

ALT + ‘

 

Sets/removes strikeout in current cell

CTRL + 5

 

Show/hide the top bar when you have a group

Crtl + 8

 

Single border around selected cells

CTRL + SHIFT + 7

 

Sort

ALT + DS

 

Insert hyperlink

CTRL + K

 

Freeze panes

ALT + WFF

 

Remove grid lines

ALT + WVG (2007+)

 

To wrap lines

ALT + HW (2007+)

 

Shortcut keys for Excel options

Save as

F12

 

Collapse the ribbon (press again to expand)

CTRL + F1

 

Opens print preview

CTRL + F2

 

Maximize the current window

ALT + SPACE X

 

Activate next window

ALT + TAB

 

Activate previous window

ALT + SHIFT + TAB

 

Close an excel workbook

crtl + F4

 

Split screens

ALT + W + S

 

EVERYTHING ELSE

 

Create a pivot table

ALT + DPF

 

 

 

 

Keep filter on columns, but show all rows

ALT + DFF

Also ALT + HSF both commands will work.

 

 

Insert pivot table (select the desired data)

ALT + NV + Enter

 

 

Shortcut keys for EDITING in MS excel

 

Edit a cell, place cursor at the end

F2

 

Show in-cell drop down with previously entered values

ALT + Down arrow

 

Fills down value from cell above

CTRL + D

 

Add a comment or Edit comment

SHIFT + F2

 

Insert new sheet

SHIFT + F11

 

Insert row

CTRL + +

 

Delete row

CTRL + –

 

Copy

CTRL + C

 

Paste

CTRL + V

 

Cut

CTRL + X

 

Undo

CTRL + Z

 

Get a line break inside the cell

ALT + Enter (while editing the cell)

 

Clear all contents

ALT + EAA

 

Copy

CTRL + insert

 

Paste

SHIFT + Insert

 

Make chart/pivot chart

F11

 

Edit a cell in Apple Macs

CTRL + U

 

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

CTRL + SHIFT + ”

 

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

CTRL + R

 

Delete box (cell, row, column)

ALT + ED

 

Insert box (cell, row, column)

ALT + IE

 

Enter current date

CTRL + ;

 

Enter current time

CTRL + :