Excel shortcut key’s [2020]: The Complete Guide

Shailesh by Shailesh Lovlekar

Excel Shortcut List

Do you ever wish to master the excel shortcuts keys?

If yes, then you are not alone.

This guide will show you everything you need to know about Excel shortcuts keys

The skill that will allow you to use the keyboard more than the mouse

Primarily the best strategies and core techniques

Also by the end of this post, I will show you the 3 vital tips that will help you to remember these shortcut keys in the long run

So lets get started:

Most of the shortcut keys are the combination of one or more modifier keys.

For e.g.:

The most common shortcut key:

  • Cut Ctrl + X
  • Copy Ctrl + C
  • Paste Ctrl + V

Are in combination with the modifier key Ctrl

Similarly, more than 90% of the shortcut keys are in combination with three major modifier keys.

Ctrl, Alt and Shift keys

However, there are some key’s that are stand-alone keys for e.g.:

Function f, Tab , Insert Insert key, etc

So let’s go through each of these key’s step by step


Excel shortcut using function key’s


F1 Open Excel Help Window

For Instant support, use this key to open Excel help window


F2 Put The active cell in edit mode

This key can be used if you wish to edit anything within a cell. Use Esc key to come out of edit mode


F3 Open Paste Name Window

If a name is defined, then you can use this key to paste the defined name within a formula


F4 Repeat last action

Fill cell A1 with red color, then click on cell B1 and hit function F4 key to get exact same behavior OR Delete column A1, then select any other column and hit F4 to get exact same behavior


F4 Switch between Absolute, Row, Column, and Relative references

Within a formula, press function key F4 to make both column and row reference absolute $A$1, repeat F4 to make row reference absolute A$1, again repeat F4 to make column reference absolute $A1, repeat F4 to make it relative A1


F5 Open Go To window

Move the courser to the desired location by placing cell reference under References


F6 Switch between Split Window, Ribbon bar

Move the course within the split panes and ribbon bar clockwise


F7 Spell check

Use this key to check spelling in the active worksheet or selected range


F8 Extended selection mode

To select multiple cells press function key F8 and use the arrow key’s to select the desired range. Press F8 again to come out of the selection mode


F9 Recalculate the entire workbooks

Function key F9 will help you calculate the entire workbook. If the automatic calculation is turned off


F10 View menu bar key tips

Function key F10 will help you view menu bar key tips


F11 Create New Chart Sheet

From the selected data create a new chart sheet


F12 Shortcut key to open save as dialog box

Function key F12 will help you save the file as any ‘xyz’ name


Shift + Function key’s


Shift + F2 Add or edit a comment

You can add a comment or edit an existing comment within a cell


Shift + F3 Open Insert Function window

For a quick selection of function’s hit Shift + F3 to open Insert Function window


Shift + F5 Open Find and replace window

This key will display a search box that will help you find anything within a sheet or a workbook


Shift + F6 Switch between Split Window, Ribbon bar

Move the course within the split panes and ribbon bar


Shift + F7 Select multiple ranges within a sheet

This key will help you select multiple ranges of cells by using arrow keys or mouse


Shift + F9 Display additional option for a selected item

This key will show an additional short menu for the selected item within a workbook


Shift + F11 Shortcut key to add a new worksheet

If you press Shift + F11 a new sheet will get added to the left of the active sheet


Shift + Other key’s


Shift + right arrow key

Extend the selection to the right


Shift + left arrow key

Extend the selection to left


Shift + up arrow key

Extend the selection to up


Shift + down arrow key

Extend the selection to down


Shift + Enter select a cell above after completing a cell entry

On pressing Enter key If you want to move the selection above the current cell use Shift + Enter key


Shift + Spacebar key to select the entire row

From active cell press Shift + Spacebar to select the entire row. To select multiple rows select multiple columns and hit Shift + Spacebar


Shift + Tab move the courser towards left

Use this key if you want to select the previous cell or previous option


Shift + Alt + Right Arrow Group row or column

Use this key to group a range of Rows or Column


Shift + Alt + Left Arrow Ungroup row or column

Use this key to ungroup a range of Rows or Column


Alt + Function key’s


Alt key Help you view menu bar key tips

Use the Alt key to highlights all the respective shortcut on the ribbon bar


Alt + F1 Shortcut key to creating a chart

This key will help you create a chart from the selected data


Alt + F2 Shortcut key to open save as dialog box

This key will help you save the file as any ‘xyz’ name


Alt + F4 Shotcut key to close excel sheet

This key will help you close the active sheet


Alt + F10 Shortcut key to open selection pane

View the list of all objects, change their orders or visibility


Alt + Alphabetic key’s


Alt + A Shortcut key to open DATA Tab

This key will open the Data Tab and will display all the shortcut key within it


Alt + F Shortcut key to open FILE Tab

This key will open the File Tab and will display all the shortcut key within it


Alt + H Shortcut key to open HOME Tab

This key will open the Home Tab and will display all the shortcut key within it


Alt + M Shortcut key to open FORMAT Tab

This key will open the Format Tab and will display all the shortcut key within it


Alt + N Shortcut key to open INSERT Tab

This key will open the Insert Tab and will display all the shortcut key within it


Alt + P Shortcut key to open PAGE LAYOUT Tab

This key will open the Page Layout Tab and will display all the shortcut key within it


Alt + R Shortcut key to open REVIEW Tab

This key will open the Review Tab and will display all the shortcut key within it


Alt + W Shortcut key to open VIEW Tab

This key will open the View Tab and will display all the shortcut key within it


Alt + Other key’s


Alt + Enter Add new line within a cell

This key will allow you to add multiple lines of text within the same cell


Alt + = Add SUM function to the selected cell

Get a sum of a range using Alt + = sign


Alt + Spacebar Display control menu

This key will allow you to use all control options such as Restore, Move, Size, Minimize, Maximize and Close


Alt + Numeric keys Add Symbols that are not on your keyboard

Allow you to add symbols that are not on your keyboard, you may also use multiple numbers to get a variety of options


Alt + Tab Switch between all open applications towards the right

This key will allow you to switch between all open applications towards the right


Alt + Shift + Tab Switch between all open applications towards left

This key will allow you to switch between all open applications towards left


Alt + Shift + F1 Add new worksheet

This key will allow you to add a new worksheet to the left of the active sheet


Ctrl + Function key’s


Ctrl + F2 Display Print Preview

This key will display print preview under the print tab


Ctrl + F3 Open Name Manager

This key will display a Name Manager window


Ctrl + F4 Close Workbook

This key will help us close the active workbook


Ctrl + F5 Restore the window size

This key will help you restore down the selected workbook


Ctrl + F6 Switch between open workbooks

If you have multiple workbooks open; then use this key to switch between each them


Ctrl + F7 Move the workbook

If the workbook is not in maximized mode; then Ctrl + F7 key will help us move the worksheet


Ctrl + F8 Activate resize mode when a workbook is not maximized.

From non maximized mode press Ctrl + F8 to activate the Size mode, and then use the arrow key to resize


Ctrl + F9 Minimize the active workbook

This key will help you minimize the active workbook


Ctrl + F10 Maximize the active workbook

This key will help you maximize the active workbook


Ctrl + F11 Add new Macro Sheets

A new sheet will get added as Macro1 to the left of the active sheet


Ctrl + F12 Open any saved workbook

This key will help you open already saved workbook


Ctrl + Number key’s


Ctrl + 0 Hide Selected Columns

Select the columns you want to hide and hit Ctrl + 0


Ctrl + 1 Open Format Cells window

Use this key to Format the selected Cell


Ctrl + 2 Apply Bold effect to the selected cell

Use this key to remove or apply a bold effect to the selected cell


Ctrl + 3 Apply Italic effect to the selected cell

Use this key to remove or apply Italic effect to the selected cell


Ctrl + 4 Apply Underline effect to the selected cell

Use this key to remove or apply Underline effect to the selected cell


Ctrl + 5 Apply Strikethrough effect to the selected cell

Use this key to remove or apply a strikethrough effect to the selected cell


Ctrl + 9 Hide Selected Rows

Select the Rows you want to hide and press ctrl + 9


Ctrl + Alphabetic key’s


Ctrl + A Select All Cells

This key will help you select all the cell within a worksheet


Ctrl + B Apply Bold effect to the selected cell

Use this key to remove or apply a bold effect to the selected cell


Ctrl + C Copy the selected cells

Use this key to the copy the selection in the clipboard, so that it can be pasted at any desired location


Ctrl + D Create a duplicate copy

This key will help you create a duplicate copy of the topmost cell


Ctrl + E Activicate Flash Fill

Enter a few examples and then use this key to automatically fill in the value for the rest of the cells


Ctrl + F Open Find and replace window

This key will display a search box that will help you find anything within a sheet or a workbook


Ctrl + G Open Go To window

Move the courser to the desired location by placing cell reference under references


Ctrl + H Open Find and replace window

A Replace tab will be active, that will help you find and replace anything within a sheet or workbook


Ctrl + I Apply Italic effect to the selected cell

This key will help you find text within a workbook


Ctrl + K Open Insert hyperlink window

Use this key to link any documents for quick access


Ctrl + L Open Create Table window

This key will help you create a Table from the selection, that will help you organize as analyze data effectively 


Ctrl + N Create a new workbook

From the active sheet use this key to create a new workbook


Ctrl + O Open a spreadsheet

From Active sheet use this key to open already saved workbook


Ctrl + P Display Print option under File Tab

Use this key to set a print area and print the document


Ctrl + Q Display Quick Analysis option from the selected data

Use this key to quickly analyze the data; using excel’s most useful tools, such as charts, color-coding, tables, formulas, etc.


Ctrl + R Fill Right

Use this key to take the data from the left and fill it to the right


Ctrl + S Save Workbook

Use this key to save the unsaved data within a workbook


Ctrl + T Open Create Table window

This key will help you create a Table from the selection, that will help you organize as analyze data effectively


Ctrl + U Apply Underline effect to the selected cell

Use this key to remove or apply Underline effect to the selected cell


Ctrl + V Paste the Copied data

Use this key to Paste the copied data from selection to the desired location


Ctrl + W Close active workbook

If you have multiple workbooks open, you may use this key to close the active workbook


Ctrl + X Remove the selected cells

Use this key to the remove the selection and put it to the clipboard, so that it can be pasted at any other location


Ctrl + Y Repeat the last action

Use this key if you wish to redo or repeat the last action


Ctrl + Z Undo the last action

Use this key if you want to undo the last action performed


Ctrl + Special Characters


Ctrl + + Insert Cell, Row, or Column

From the active cell use this key to insert a cell down, also you can use this key to insert row or column by selecting either of them


Ctrl + - Delete Cell, Row, or Column

From the active cell use this key to delete a cell, also you can use this key to delete row or column by selecting either of them


Ctrl + ' Copy the value from a cell above

Use this key to copy the value from a cell above with no formatting effects


Ctrl + ` View all the formulas within a sheet

Use this key to view all the formulas used within an active sheet


Ctrl + ; Insert current date.

Use this key to insert current date within a selected cell


Ctrl + / Select the array range

From the active array, cell use this key to select the array range for the selected cell


Ctrl + \ Select all the cell that doesn’t match the active cell value

From the selected range of rows use this key to select all the cell that doesn’t match the active cell value 


Ctrl + [ Select all the values based on active formula cell

Use this key to know all the values that the active formula cell is dependent on


Ctrl + ] Select all the formulas based on active cell value

Use this key to know all the formulas within a sheet that is dependent on the active cell value


Ctrl + Other key’s


Ctrl + Home Move the cursor to top left cell Or cell A1

From any cell, if you want to quickly move the cursor to top-left cell Or cell A1 use this key


Ctrl + End Move the cursor to the end of the lower-right most used cell

Use this key to select the last occupied cell within a sheet


Ctrl + Arrow Select last occupied cell in the same column or row as the active cell is

Use this key to select the last occupied cell in the same column or row as the active cell is


Ctrl + Enter Keep the active cell selected

Use this key, if you wish to keep the active cell selected after entering any value


Ctrl + PageDown From the active sheet move to next sheet

Use this key to move to the next sheet from the active sheet


Ctrl + PageUp From the active sheet moves to the previous sheet

Use this key to move to the previous sheet from the active sheet


Ctrl + Spacebar Select the entire column

From the active cell use this key to select the entire column. Select multiple cells to select multiple columns


Ctrl + Tab Switch between workbooks

If you have multiple workbook open; use this key to switch between each of them


Ctrl + Shift + Alphabetic key’s


Ctrl + Shift + A Display function arguments

Use this key inside a function to display a function argument within a cell


Ctrl + Shift + F Open Format Cells window with Font tab active

Use this key to Format the selected Cell


Ctrl + Shift + L Add Filter

Use this key to apply a filter to the selected data or a cell


Ctrl + Shift + O Select all Comments

Use this key to select all the comments within an active sheet


Ctrl + Shift + P Open Format Cells window

Use this key to Format the selected Cell


Ctrl + Shift + U Expand the formula bar

Use this key to expand or collapse the formula bar


Ctrl + Shift + special character key’s


Ctrl + Shift + : Insert current time

Use this key to insert current time within a selected cell


Ctrl + Shift + ~ Apply General Number Format

Use this key to apply a general number format to the selected cell


Ctrl + Shift + ! Apply Number Format

Use this key to apply a number format to the selected cell


Ctrl + Shift + @ Apply Time Format

Use this key to apply time format to the selected cell


Ctrl + Shift + # Apply Date Format

Use this key to apply a date format to the selected cell


Ctrl + Shift + $ Apply Currency Format

Use this key to apply currency format to the selected cell


Ctrl + Shift + % Apply Percentage Format

Use this key to apply the percentage format to the selected cell


Ctrl + Shift + ^ Apply Scientific Number Format

Use this key to apply Scientific number format to the selected cell


Ctrl + Shift + & Apply outline border

Use this key to apply the outline border from the selected cell


Ctrl + Shift + * Select all the data around the active cell

Use this key to select all the data around the selected cell; you may also use this key to select an entire PivotTable report


Ctrl + Shift + ( Unhide the hidden row

Use this key to unhide any hidden row within the selection


Ctrl + Shift + ) Unhide the hidden columns

Use this key to unhide any hidden columns within the selection


Ctrl + Shift + - Remove outline border

Use this key to remove the outline border from the selected cell


Ctrl + Shift + + Insert Cell, Row, or Column

From the active cell use this key to insert a cell down, also you can use this key to insert row or column by selecting either of them


Ctrl + Shift + " Copy the value from a cell above

Use this key to copy the value from a cell above with no formatting effects


Ctrl + Shift + other key’s


Ctrl + Shift + Home Extend the selection to the top left cell Or till cell A1

From the active cell use this key to extend the selection to the top-left cell or till cell A1


Ctrl + Shift + End Extend the selection to the last used lower-right cell

This key will help you select all the cells from the active selected cell to the last used lower-right cell


Ctrl + Shift + Arrow Extend the selection to the last occupied cell in the same column or row as the active cell is

This key will help you select all the cells from the last occupied cell in the same column or row as the active cell is


Ctrl + Shift + Spacebar Select All Cells

Use this key to select all the cell that contains data, repeat the process the second time to select the data with headers (if it’s a table), repeat the process the third time to select an entire cell within a worksheet


Ctrl + Shift + Tab Switch between workbooks

If you have multiple workbook open; use this key to switch between each of them


Ctrl + Shift + PgDn Select multiple sheets towards right

Use this key to make multiple selections towards right from the active sheet


Ctrl + Shift + PgUp Select multiple sheets towards left

Use this key to make multiple selection towards left from the active sheet


Ctrl + Alt + function key’s


Ctrl + Alt + F2 Open any saved workbook

This key will help you open already saved workbook


Ctrl + Alt + F3 Open Define name window

Use this key to define and apply new name range


Ctrl + Alt + F4 Close the active sheet

This key will help you close the active sheet


Ctrl + Alt + F9 Calculate all the worksheet within a workbook

Use this key to recalculate the formula, in all sheet within an active workbook


Ctrl + Alt + Alphabetic key’s


Ctrl + Alt + V Open Paste Special Window

Copy any cell and use this key to open Paste Special Window


So now that you have the complete list…

Let me share the 3 vital tips that will help you remember these excel shortcut keys in the long run?

Look for an underline ( _ ) sign below words

For e.g: If you look at the Paste Special Window

You will see an underlined letter below each word. These letters denote the shortcut key.

If you will press “F” key formulas will get selected

Or

If you press “V” values will get selected

You got the point

In some cases pressing key directly may not work. Try using it with the modifier keys like Ctrl , Alt or Shift

Use Alt key

From an excel sheet if you press Alt key a shortcut key assigned to each of the tabs will be displayed.

If you press any of these key all the shortcut keys within the tab will be displayed

Mouse hover

There are some direct shortcut keys assigned to most of the commands.

If you hover the mouse over any of the commands a shortcut key assigned for that command will be displayed.

For e.g: If you hover a mouse on an AutoSum command under Home tab a shortcut key associated to it i.e Alt + = will be displayed

That’s it.

So now it’s your turn

Do you like the 3 tips that I shared?

Which modifier key would you like to use first?

Or

Do you have anything that could be an addon to this list?

Let me know by leaving a comment below

4 Comments

  • Royal CBD

    Hello to every one, it’s in fact a good for me to go to see this site, it
    consists of valuable Information.

    Reply
    • Shailesh Lovlekar

      I’m glad you found it useful!

      Reply
  • Chitesh

    Hello Shailesh,
    Can you add search bar in this
    It will help to search by keyword which I want to refer, now I have to scroll whole document to search a particular function.
    Thank you

    Reply
    • Shailesh Lovlekar

      Sure Chitesh

      Reply

Leave a comment

Your email address will not be published.

Shailesh

Get exclusive data strategy & tips

Enter the details below and get access to the complete data insights that I only share with my subscribers