Shortcut keys in MS excel to improve your efficiency at work

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 + SPACEShortcut

 

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 + :

Vaibhav

Author: Vaibhav

Vaibhav is an engineer by schooling and an SAP Consultant by training with 12 years of experience. He is certified in SAP PM and SAP MM. His expertise includes SAP PM, SAP MM, SAP QM, and MS excel. His industry specialties are Chemical, Automobile, Electronics and Infrastructure. He has lots of experience in SAP Training and Consulting.

4 Comments

  • sohan April 21, 2016 Reply

    Hello,

    I found your article very useful for my work. I appreciate your writing.
    Everyone can able to understand each and every point.
    Thanks

  • Anubhav April 21, 2016 Reply

    Hi Vaibhav,,

    Brilliant article. Everyone can easy to understand. Very clearly explained every point.
    Thank you for sharing such kind of information.

  • Raffaele April 5, 2016 Reply

    Nnice job, Vaibhav. Very useful and clearly explained.
    Just let me add a word about the locale input: these shortcuts will not work same way on all types of keyboard. Some commands are common (e.g. Ctrl + C; Ctrl + S, etc..) and shared on all types, just like the common set of ASCII characters, but what if one uses an AZERTY keyboard, or an Italian QWERTY? It will simply be impossible to replicate the proper sequence. of keys.
    Furthermore, MS Excel comes with a localized set of formulas and syntax, and not always these are easy-to-understand, particularly when an improper translation from native version occurs.
    It would be very worth to build a comparison table where all shortcuts are listed according to language, locale input method and keyboard.

    • Vaibhav
      Mishra, Vaibhav April 12, 2016 Author

      Thanks Raffaele. You have raised a very valid point. I do not have much knowledge about language issues. I will explore it and update the post accordingly.

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload CAPTCHA.

error: Content is protected !!