65 Shortcut Keys in Excel [Free PDF Download]

Microsoft Excel is a powerful tool for data analysis, calculations, and creating complex spreadsheets. While its user interface is user-friendly, mastering Excel shortcuts can significantly boost your productivity. In this article, I’ll discuss 65 essential shortcut keys in Excel that every user should know. Plus, I’m offering a free PDF download for quick reference. Let’s dive in and supercharge your Excel skills!

Download 65 Excel Shortcut Keys in PDF

25 Common Shortcut Keys for Excel

Serial No.Shortcut KeysFunction
1.Ctrl + CCopies the content of a selected cell.
2.Ctrl + VPastes contents from the clipboard.
3.Ctrl + XCuts and copies the contents of a selected cell.
4.Ctrl + ASelects all the cells in a workbook.
5.Ctrl + FOpens the Find dialog box.
6.Ctrl + GOpens the Go To dialog box.
7.Ctrl + HOpens the Find and Replace dialog box.
8.Ctrl + KInserts a hyperlink in a selected text.
9.Ctrl + LOpens the Create Table dialog box.
10.Ctrl + PAvails the Print window to print a worksheet.
11.Ctrl + WCloses the current workbook.
12.Ctrl + ZReverses the last action.
13.Ctrl + 1Opens the Format Cells dialog box.
14.Ctrl + –Deletes the selected columns or rows.
15.Ctrl + SpaceSelects an entire column.
15.Shift + SpaceSelects an entire row.
16.Ctrl + HomeRedirects to cell A1.
17.AltDisplays the access keys.
18.TabMoves to the next cell.
19.F2Enables editing a cell.
20.EscCancels out an entry.
21.EnterExecutes an entry in a cell and moves to the next cell.
22.Alt + EnterStarts a new line in the current cell.
23.F1Opens the Microsoft Excel help.
24.Ctrl + F4Closes Microsoft Excel.
25.Alt +F8Opens the Macro window.

20 Basic Shortcut Keys for Excel

Serial No.Shortcut KeysFunction
1.Ctrl + NCreates a new Excel Workbook.
2.Ctrl + OOpens an existing workbook.
3.Ctrl + SSaves a workbook.
4.Ctrl + ASelects all the cells in the opened workbook.
5.Ctrl + BMakes the contents bold of a selected cell.
6.Ctrl + CCopies the contents of a selected cell.
7.Ctrl + DFills up a selected cell with the contents of its upper cell.
8.Ctrl + FOpens up the Find dialog box to search for anything inside the current workbook.
9.Ctrl + GOpens up the Go To dialog box.
10.Ctrl + HOpens up the Find and Replace dialog box.
11.Ctrl + IItalicizes your text.
12.Ctrl + KInserts hyperlink within a text.
13.Ctrl + LOpens up the Create Table dialog box.
14.Ctrl + PBrings up the Print window to print a workbook.
15.Ctrl + RFills up the selected cells with the contents of the left cell.
15.Ctrl + UAdds up an underline to the selected text.
16.Ctrl + VPastes your copied data from the clipboard.
17.Ctrl + WCloses down a running workbook.
18.Ctrl + –Deletes a selected row or column.
19.Ctrl + ZReverses the last action.
20.Ctrl + 1Opens up the Format Cells dialog box.

20 Advanced Shortcut Keys for Excel

Serial No.Shortcut KeysFunction
1.Ctrl + Shift + :Inserts the current time into a cell.
2.Ctrl + ;Inserts the current date into a cell.
3.Ctrl + `Displays the formula used in a cell.
4.Ctrl + Shift + =Inserts extra columns or rows.
5.Ctrl + Shift + ~Switches between displaying formulas used in a cell and the cell value.
6.Ctrl + Shift + @Applies time formatting.
7.Ctrl + Shift + #Applies date formatting.
8.Ctrl + Shift + %Applies percentage formatting.
9.Ctrl + Shift + &Applies borders around the selected cell.
10.Ctrl + Shift + _Removes the border from the selected cell.
11.Ctrl + SpacebarHighlights an entire column.
12.Ctrl + Shift + SpacebarSelects an entire workbook.
13.Ctrl + HomeNavigates back to cell A1.
14.Ctrl + Shift + TabJumps into the previous workbook.
15.Ctrl + Up arrowJumps into the top-most cell in a selected column.
15.Ctrl + Down arrowJumps into the last cell in a selected column.
16.Ctrl + Right arrowJumps into the last cell in a selected row.
17.Ctrl + Left arrowJumps into the first cell in a selected row.
18.Ctrl + EndNavigates to the last cell in a workbook.
19.Ctrl + F1Expands and collapses the main ribbon.
20.Shift + SpaceSelects an entire row.

Why Excel Shortcut Keys Are Not Working?

In some cases, a certain shortcut key may not work on your computer.

In the following section, we are going to discuss the most common 5 possible reasons for it. If none of the following solutions work for you, then there are possibilities that you have a hardware issue with your computer keyboard.

So let’s get started.

1. Alter the functions of the F1 to F12 Keys

From F1 to F12 keys, they perform various functions in Microsoft Excel. For example, the F2 key enables editing a particular cell, and F9 calculates the values of the formula or part of a formula.

On most recent computers, especially laptops, these keys are used as media keys such as to increase/decrease volume, increase/decrease brightness, mute, etc.

In this case, pressing any key from F1 to F12 may trigger these media functionalities rather than performing a specific task on MS Excel.

If the scenario is so, Excel shortcut keys might not work. To solve this problem, you can try any of the following solutions.


  • Press the Fn key before any of the keys from F1 to F12. For example, if pressing only the F2 key doesn’t enable editing a cell then press Fn + F2. This will work properly.
  • Lock your media keys. Find the command for locking up your media keys or you can simply google it. For example, Fn + Esc locks up the media keys in some keyboards.
  • Alter your media keys. To do that, restart your computer and go to the BIOS settings. There you will find options to alter your media keys with some other keys.

2. Modify Language Bar Settings

Using multiple language inputs can grasp some of the keys from your keyboard. All you need to do is, alter the keys for the Language Bar Settings. This is how you can free some of the keys that you have already been using as Excel shortcut keys.

3. Find the Shortcuts for Your Own Keyboard Layout

All the shortcuts discussed in this article, are based on the Standard US Keyboard Layout.

If you are using a different keyboard layout, such as Dutch, French, or any other non-English keyboard layout, then the shortcut keys may differ.

4. Windows and Mac Keyboard Shortcut Keys are not the Same

All the keyboard shortcut keys discussed in this article are only applicable to the Windows operating system. If you are a Mac user, the keyboard shortcuts will definitely be different.

In general, the CTRL key on Windows is replaced by a CMD key on a Mac. For example, to copy text, CTRL + C is used on Windows. Whereas on a Mac computer, the shortcut key to copy a text is CMD + C.

5. Check Program Trolls

Some programs out of your all-installed programs can take over some of your shortcut keys. These programs are known as Program Trolls.

For example, Lightshot is a program to take screenshots. This program automatically grasps the PtrScr key on the keyboard as a shortcut key.

If you have a program troll, such as Lightshot, some of your Excel shortcut keys might be already taken away. As a result, they may not work as you press them.


Excel is a versatile tool, and knowing the right shortcuts can make a world of difference in your productivity. These 65 essential shortcut keys cover various aspects of Excel, from navigation and selection to data handling and formula creation. With the free PDF download, you’ll have a valuable resource at your fingertips to enhance your Excel skills. So, start using these shortcuts and take your Excel proficiency to the next level.

Frequently Asked Questions

What is F1 f2 F3 F4 F5 F6 f7 f8 f9 f10 F11 F12 in Excel?

In Excel, the function keys F1, F2, F3, F4, F5, F6, F7, F8, F9, F10, F11, and F12 serve various functions:

  • F1: Opens Excel’s Help feature, allowing you to search for assistance and information.
  • F2: Activates the cell’s editing mode, enabling you to modify its contents.
  • F3: Displays the “Paste Name” dialog box for using defined names in formulas.
  • F4: Repeats the last action you performed in Excel, which can be a time-saving feature.
  • F5: Opens the “Go To” dialog, allowing you to navigate to a specific cell or range.
  • F6: Cycles through different elements within Excel, such as cells, the formula bar, and task panes.
  • F7: Initiates the spellcheck feature, highlighting potential spelling and grammar errors in the active worksheet.
  • F8: Activates the “Extend Selection” mode, useful for selecting cells or ranges in a non-contiguous manner.
  • F9: Recalculates all formulas in the workbook, particularly handy when working with manual calculation settings.
  • F10: Activates the Ribbon’s keytips, making it easier to access Excel’s commands using keyboard shortcuts.
  • F11: Creates a chart based on the selected data, providing a quick way to visualize your information.
  • F12: Opens the “Save As” dialog box, allowing you to save the current workbook with a different file name or format.

What is Ctrl +T in Excel?

In Excel, pressing Ctrl + T is a keyboard shortcut that creates a table from a selected range of data. Excel automatically applies formatting, filters, and structured references to the table, making it easier to manage and analyze data efficiently.

5/5 - (2 votes)

Similar Posts

Leave a Reply

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