For example, the F2 key enables editing a particular cell, F9 calculates the values of the formula or part of a formula. Alter the functions of the F1 to F12 Keysįrom F1 to F12 keys, they perform various functions in Microsoft Excel. If none of the following solutions work for you, then there are possibilities that you have a hardware issue on your computer keyboard. In the following section, we are going to discuss the most common 5 possible reasons for it. In some cases, a certain shortcut key may not work on your computer. Navigates to the last cell in a workbook. Jumps into the first cell in a selected row.

Jumps into the last cell in a selected row. Jumps into the last cell in a selected column. Jumps into the top-most cell in a selected column. Removes the border from the selected cell. Switches between displaying formulas used in a cell and the cell value.Īpplies borders around the selected cell. Pastes your copied data from the clipboard.Īdvanced Excel Shortcuts Download 25 Advanced Excel Shortcuts PDF Serial No. Opens up the Find and Replace dialog box.īrings up the Print window to print a workbook.įills up the selected cells with the contents of the left cell.Īdds up an underline to the selected text. Opens up the Find dialog box to search for anything inside the current workbook. Makes the contents bold of a selected cell.įills up a selected cell with the contents of its upper cell. Selects all the cells in the opened workbook. Common Excel Shortcut Keys Download 25 Common Excel Shortcut Keys PDF Serial No.Ĭuts and copies the contents of a selected cell.Īvails the Print window to print a worksheet.Įxecutes an entry in a cell and moves to the next cell.īasic Shortcut Keys in Excel Download Basic Shortcut Keys in Excel PDF Serial No. So without having any further discussion, let’s learn them all one by one. We have prepared pdf files for each of the categories that you can download for free.

We have tried to categorize the most useful shortcut keys available in Excel into 3 major categories.

Microsoft Excel offers a ton of keyboard shortcut keys to work seamlessly. Download MS Excel Shortcut Keys PDF Excel Shortcut Keys List

Shortcuts for excel 2016