The document lists 100 Excel keyboard shortcuts along with their functions and level of familiarity. Many common shortcuts like Ctrl+C to copy, Ctrl+V to paste, and Ctrl+S to save are listed as having high familiarity. Other shortcuts related to formatting, inserting rows/columns, and navigating worksheets are indicated as having medium or low familiarity for most users. The shortcuts are organized in a table with columns for the shortcut code, description of functionality, and familiarity level.
The document lists 100 Excel keyboard shortcuts along with their functions and level of familiarity. Many common shortcuts like Ctrl+C to copy, Ctrl+V to paste, and Ctrl+S to save are listed as having high familiarity. Other shortcuts related to formatting, inserting rows/columns, and navigating worksheets are indicated as having medium or low familiarity for most users. The shortcuts are organized in a table with columns for the shortcut code, description of functionality, and familiarity level.
The document lists 100 Excel keyboard shortcuts along with their functions and level of familiarity. Many common shortcuts like Ctrl+C to copy, Ctrl+V to paste, and Ctrl+S to save are listed as having high familiarity. Other shortcuts related to formatting, inserting rows/columns, and navigating worksheets are indicated as having medium or low familiarity for most users. The shortcuts are organized in a table with columns for the shortcut code, description of functionality, and familiarity level.
The document lists 100 Excel keyboard shortcuts along with their functions and level of familiarity. Many common shortcuts like Ctrl+C to copy, Ctrl+V to paste, and Ctrl+S to save are listed as having high familiarity. Other shortcuts related to formatting, inserting rows/columns, and navigating worksheets are indicated as having medium or low familiarity for most users. The shortcuts are organized in a table with columns for the shortcut code, description of functionality, and familiarity level.
Download as XLSX, PDF, TXT or read online from Scribd
Download as xlsx, pdf, or txt
You are on page 1of 4
S.No.
Excel Shortcuts Functionality Familiarity
1 Ctrl + N To create a new workbook High 2 Ctrl + O To open a saved workbook 3 Ctrl + S To save a workbook 4 Ctrl + A To select all the contents in a workbook High 5 Ctrl + B To turn highlighted cells bold 6 Ctrl + C To copy cells that are highlighted 7 Ctrl + D To fill the selected cell with the content of the cell right above Low 8 Ctrl + F To search for anything in a workbook 9 Ctrl + G To jump to a certain area with a single command 10 Ctrl + H To find and replace cell contents 11 Ctrl + I To italicise cell contents 12 Ctrl + K To insert a hyperlink in a cell Low 13 Ctrl + L To open the create table dialog box 14 Ctrl + P To print a workbook 15 Ctrl + R To fill the selected cell with the content of the cell on the left 16 Ctrl + U To underline highlighted cells 17 Ctrl + V To paste anything that was copied 18 Ctrl + W To close your current workbook 19 Ctrl + Z To undo the last action 20 Ctrl + 1 To format the cell contents 21 Ctrl + 5 To put a strikethrough in a cell 22 Ctrl + 8 To show the outline symbols 23 Ctrl + 9 To hide a row 24 Ctrl + 0 To hide a column 25 Ctrl + Shift + : To enter the current time in a cell 26 Ctrl + ; To enter the current date in a cell 27 Ctrl + ` To change the view from displaying cell values to formulas 28 Ctrl + ‘ To copy the formula from the cell above 29 Ctrl + - To delete columns or rows Low 30 Ctrl + Shift + = To insert columns and rows Low 31 Ctrl + Shift + ~ To switch between displaying Excel formulas or their values in cell 32 Ctrl + Shift + @ To apply time formatting 33 Ctrl + Shift + ! To apply comma formatting 34 Ctrl + Shift + $ To apply currency formatting 35 Ctrl + Shift + # To apply date formatting 36 Ctrl + Shift + % To apply percentage formatting 37 Ctrl + Shift + & To place borders around the selected cells 38 Ctrl + Shift + _ To remove a border 39 Ctrl + - To delete a selected row or column 40 Ctrl + Spacebar To select an entire column 41 Ctrl + Shift + Spacebar To select an entire workbook 42 Ctrl + Home To redirect to cell A1 43 Ctrl + Shift + Tab To switch to the previous workbook 44 Ctrl + Shift + F To open the fonts menu under format cells 45 Ctrl + Shift + O To select the cells containing comments 46 Ctrl + Drag To drag and copy a cell or to a duplicate worksheet 47 Ctrl + Shift + Drag To drag and insert copy 48 Ctrl + Up arrow To go to the top most cell in a current column 49 Ctrl + Down arrow To jump to the last cell in a current column 50 Ctrl + Right arrow To go to the last cell in a selected row 51 Ctrl + Left arrow To jump back to the first cell in a selected row 52 Ctrl + End To go to the last cell in a workbook 53 Alt + Page down To move the screen towards the right 54 Alt + Page Up To move the screen towards the left 55 Ctrl + F2 To open the print preview window 56 Ctrl + F1 To expand or collapse the ribbon 57 Alt To open the access keys 58 Tab Move to the next cell 59 Alt + F + T To open the options 60 Alt + Down arrow To activate filters for cells 61 F2 To edit a cell 62 F3 To paste a cell name if the cells have been named 63 Shift + F2 To add or edit a cell comment 64 Alt + H + H To select a fill colour 65 Alt + H + B To add a border 66 Ctrl + 9 To hide the selected rows 67 Ctrl + 0 To hide the selected columns 68 Esc To cancel an entry 69 Enter To complete the entry in a cell and move to the next one 70 Shift + Right arrow To extend the cell selection to the right 71 Shift + Left arrow To extend the cell selection to the left 72 Shift + Space To select the entire row 73 Page up/ down To move the screen up or down 74 Alt + H To go to the Home tab in Ribbon 75 Alt + N To go to the Insert tab in Ribbon 76 Alt + P To go to the Page Layout tab in Ribbon 77 Alt + M To go to the Formulas tab in Ribbon 78 Alt + A To go to the Data tab in Ribbon 79 Alt + R To go to the Review tab in Ribbon 80 Alt + W To go to the View tab in Ribbon 81 Alt + Y To open the Help tab in Ribbon 82 Alt + Q To quickly jump to search 83 Alt + Enter To start a new line in a current cell 84 Shift + F3 To open the Insert function dialog box 85 F9 To calculate workbooks 86 Shift + F9 To calculate an active workbook 87 Ctrl + Alt + F9 To force calculate all workbooks 88 Ctrl + F3 To open the name manager 89 Ctrl + Shift + F3 To create names from values in rows and columns 90 Ctrl + Alt + + To zoom in inside a workbook 91 Ctrl + Alt + To zoom out inside a workbook 92 Alt + 1 To turn on Autosave 93 Alt + 2 To save a workbook 94 Alt + F + E To export your workbook 95 Alt + F + Z To share your workbook 96 Alt + F + C To close and save your workbook 97 Alt or F11 To turn key tips on or off 98 Alt + Y + W To know what's new in Microsoft Excel 99 F1 To open Microsoft Excel help 100 Ctrl + F4 To close Microsoft Excel Usage Relevance High High