Microsoft Excel Shortcut Keys – Become a Smart User

Microsoft Excel Shortcut Keys

Ctrl + A : Select all the contents in a workbook.

Ctrl + B : Turn highlighted cells bold.

Ctrl + C : Copy cells that are highlighted.

Ctrl + D : Fill the selected cell with the content of the cell right above.

Ctrl + F : Search for anything in a workbook.

Ctrl + G : Jump to a certain area with a single command.

Ctrl + H : Find and replace cell contents.

Ctrl + I : Italicise cell contents.

Ctrl + K : Insert a hyperlink in a cell.

Ctrl + L : Open the create table dialog box.

Ctrl + N : Create a new workbook.

Ctrl + O : Open a saved workbook.

Ctrl + P : Print a workbook.

Ctrl + R : Fill the selected cell with the content of the cell on the left.

Ctrl + S : Save a workbook.

Ctrl + U : Underline highlighted cells.

Ctrl + V : Paste anything that was copied.

Ctrl + W : Close your current workbook.

Ctrl + Z : Undo the last action.

Ctrl + 1 : Format the cell contents.

Ctrl + 5 : Put a strikethrough in a cell.

Ctrl + 8 : Show the outline symbols.

Ctrl + 9 : Hide a row.

Ctrl + 0 : Hide a column.

Ctrl + Shift +  : Enter the current time in a cell.

Ctrl + ; : Enter the current date in a cell.

Ctrl + ` : Change the view from displaying cell values to formulas.

Ctrl + ‘ : Copy the formula from the cell above.

Ctrl + – : Delete columns or rows.

Ctrl + Shift + = : Insert columns and rows.

Ctrl + Shift + ~ : Switch between displaying Excel formulas or their values in cell.

Ctrl + Shift + @ : Apply time formatting.

Ctrl + Shift + ! : Apply comma formatting.

Ctrl + Shift + $ : Apply currency formatting.

Ctrl + Shift + # : Apply date formatting.

Ctrl + Shift + % : Apply percentage formatting.

Ctrl + Shift + & : Place borders around the selected cells.

Ctrl + Shift + _ : Remove a border.

Ctrl + – : Delete a selected row or column.

Ctrl + Spacebar : Select an entire column.

Ctrl + Shift + Spacebar : Select an entire workbook.

Ctrl + Home : Redirect to cell A1.

Ctrl + Shift + Tab : Switch to the previous workbook.

Ctrl + Shift + F : Open the fonts menu under format cells.

Ctrl + Shift + O : Select the cells containing comments.

Ctrl + Drag : Drag and copy a cell or to a duplicate worksheet.

Ctrl + Shift + Drag : Drag and insert copy.

Ctrl + Up arrow : Go to the top most cell in a current column.

Ctrl + Down arrow : Jump to the last cell in a current column.

Ctrl + Right arrow : Go to the last cell in a selected row.

Ctrl + Left arrow : Jump back to the first cell in a selected row.

Ctrl + End : Go to the last cell in a workbook.

Alt + Page down : Move the screen towards the right.

Alt + Page Up : Move the screen towards the left.

Ctrl + F2 : Open the print preview window.

Ctrl + F1 : Expand or collapse the ribbon.

Alt : Open the access keys.

Tab : Move to the next cell.

Alt + F + T : Open the options.

Alt + Down arrow : Activate filters for cells.

F2 : Edit a cell.

F3 : Paste a cell name if the cells have been named.

Shift + F2 : Add or edit a cell comment.

Alt + H + H : Select a fill colour.

Alt + H + B : Add a border.

Ctrl + 9 : Hide the selected rows.

Ctrl + 0 : Hide the selected columns.

Esc : Cancel an entry.

Alt + H : Go to the Home tab in Ribbon.

Alt + N : Go to the Insert tab in Ribbon.

Alt + P : Go to the Page Layout tab in Ribbon.

Alt + M : Go to the Formulas tab in Ribbon.

Alt + A : Go to the Data tab in Ribbon.

Alt + R : Go to the Review tab in Ribbon.

Alt + W : Go to the View tab in Ribbon.

Enter : Complete the entry in a cell and move to the next one.

Shift + Right arrow : Extend the cell selection to the right.

Shift + Left arrow : Extend the cell selection to the left.

Shift + Space : Select the entire row.

Page up/ down : Move the screen up or down.

Alt + Y : Open the Help tab in Ribbon.

Alt + Q : Quickly jump to search.

Alt + Enter : Start a new line in a current cell.

Shift + F3 : Open the Insert function dialog box.

F9 : Calculate workbooks.

Shift + F9 : Calculate an active workbook.

Ctrl + Alt + F9 : Force calculate all workbooks.

Ctrl + F3 : Open the name manager.

Ctrl + Shift + F3 : Create names from values in rows and columns.

Ctrl + Alt + + : Zoom in inside a workbook.

Ctrl + Alt + : Zoom out inside a workbook.

Alt + 1 : Turn on Autosave.

Alt + 2 : Save a workbook.

Alt + F + E : Export your workbook.

Alt + F + Z : Share your workbook.

Alt + F + C : Close and save your workbook.

Alt or F11 : Turn key tips on or off.

Alt + Y + W : Know what’s new in Microsoft Excel.

F1 : Open Microsoft Excel help.

Ctrl + F4 : Close Microsoft Excel.

Click here for Tally Prime Shortcult Keys