MS Excel Shortcut Keys | A to Z MS Excel Shortcut Keys

Spread the love

List of Top MS Excel Shortcut Keys or a to z MS Excel Shortcut Keys:

Alt + F + E: To export your own workbook.
Ctrl + Shift + Tab: To go to the previous workbook.
Ctrl + Shift + F: To open fonts menu under format cells. (Main shortcut keys of ms excel)
Ctrl + Shift + O: To select cells containing comments.
Ctrl + Up arrow: To go to topmost cell in a current column.
Ctrl + End: To go to last cell in a workbook. (Main shortcut keys of ms excel)
Alt + Page down: To move screen towards the right.
Alt + Page Up: To move the screen towards the left.
Alt + F + Z: To share your workbook.
Alt + F + C: To close & save your workbook. (Very Important MS Excel Shortcut Keys)
Ctrl + Drag: To drag a& copy a cell or to a duplicate worksheet.
Ctrl + Shift + Drag: To drag and insert copy.
F1: To open Microsoft Excel help. (Function keys in excel)
Ctrl + F2: To open print preview window. (Use of function keys in excel)
Ctrl + F1: To expand or collapse ribbon. (Use of function keys in excel)
F2: For edit a cell. (Function keys in ms excel)
F3: To paste a cell name if the cells have been named. (Function keys in excel)
Ctrl + F3: For open the name manager. (Use of function keys in excel)
Ctrl + F4: To close Microsoft Excel. (Use of function keys in excel)
Ctrl + Shift + F3: To create names from values in rows and columns.
Shift + F2: To add or edit a cell comment. (Shortcut function keys in excel)
Alt or F11: To turnkey tips on or off. (Use of function keys in excel)
Shift + F3: To open the Insert function dialog box. (Function keys in excel)
F5: Displays to Go to dialog box. (Function keys in ms excel)
Ctrl+F5: Restores window size of selected workbook window.
F6: Switches between worksheet, task pane, ribbon & Zoom controls. (Function keys in excel)
Shift+F6: Switches between worksheet, task pane, Zoom controls & ribbon.
Ctrl+F6: Switches to next workbook window when more than one workbook window is open.
F7: Open Spelling dialog box to check spelling in active worksheet or selected range. (Function keys in excel)
Ctrl+F7: Performs Move command on workbook window when it not maximized. Use arrow keys to move window, & when finished press Enter, or Esc for cancel.
F8: Turns extend mode on or off. (Function keys in excel)
Shift+F8: Enables you to add a nonadjacent cell or range to selection of cells by using arrow keys.
Ctrl+F8: Performs Size command when a workbook is not maximized.
Alt+F8: Displays Macro dialog box to create, run, edit, or delete a macro.
F9: For calculate workbooks. (Function keys in excel)
Shift + F9: For calculate an active workbook.
Ctrl + Alt + F9: For force calculate all workbooks.
F10: Turns key tips on or off. (Function keys in excel)
Shift+F10: Displays shortcut menu for a selected item.
Alt+Shift+F10: Displays menu or message for an Error Checking button.
Ctrl+F10: Maximizes or restores selected workbook window.
F11: Creates a chart of the data in current range in a separate Chart sheet. (Function keys in excel)
Shift+F11: inserts a new worksheet.
Alt+F11: Opens the Microsoft Visual Basic for Applications Editor, in this create a macro by using visual basic for applications
F12: Displays the Save As dialog box. (Function keys in excel)
Ctrl + Down arrow: To jump to last cell in a current column.
Ctrl + Right arrow: To go to last cell in a selected row.
Ctrl + Left arrow: To jump back to first cell in a selected row.
Alt + Y + W: To know what’s new in Microsoft Excel.
Ctrl + Shift + %: To apply percentage formatting.
Ctrl + Shift + &: To place borders around selected cells.
Ctrl + Shift + _: To remove a border.
Ctrl + –: To delete a selected row or column.
Ctrl + Spacebar: To select an entire column.
Tab: Move to next cell. (Also, Important shortcut keys of ms excel)
Alt + F + T: To open options.
Alt + Down arrow: To activate filters for cells.
Ctrl + Shift + Spacebar: To select an entire workbook.
Ctrl + Alt + +: To zoom in inside a workbook.
Ctrl + Alt +: To zoom out inside a workbook.
Alt + 1: To turn on Autosave.
Alt: For Open the access keys.
Alt + 2: For save a workbook.
Alt + N: To go to the Insert tab in Ribbon.
Alt + P: To go to the Page Layout tab in Ribbon.
Alt + M: To go to the Formulas tab in Ribbon. (shortcut excel formulas)
Ctrl + Shift + ~: To switch between displaying Excel formulas or their values in cell. (shortcut excel formulas)
Ctrl + Shift + @: To apply time formatting.
Ctrl + Shift + !: To apply comma formatting. (Main shortcut keys of ms excel)
Ctrl + Shift + $: To apply currency formatting.
Ctrl + Shift + #: For apply date formatting.
Alt + A: To go to the Data tab in Ribbon.
Alt + R: To go to the Review tab in Ribbon.
Alt + W: To go to the View tab in Ribbon.
Alt + Y: For open the Help tab in Ribbon.
Alt + Q: To quickly jump to search.
Alt + Enter: For start a new line in a current cell.
Alt + Down arrow: To activate filters for cells.
Ctrl + 9: To hide the selected rows. (Also, Important MS Excel Shortcut Keys)
Ctrl + 0: To hide the selected columns. (Also, Important MS Excel Shortcut Keys)
Esc: To cancel an entry.
Enter: To complete the entry in a cell and move to the next one.
Shift + Right arrow: To extend the cell selection to the right.
Shift + Left arrow: To extend the cell selection to the left.
Shift + Space: For select the entire row.
Alt + H + H: For select a fill colour. (Also, Important shortcut keys of ms excel)
Alt + H + B: To add a border.
Page up/ down: To move the screen up or down.
Alt + H: For go to the Home tab in Ribbon. (Also, Important shortcut keys of ms excel)
Ctrl + 8: To show the outline symbols.
Ctrl + 9: For hide a row.
Ctrl + 0: To hide a column.
Ctrl + Shift + :: To enter the current time in a cell.
Ctrl + ;: To enter the current date in a cell.
Ctrl + `: For change the view from displaying cell values to formulas. (shortcut excel formulas)
Ctrl + ‘: To copy the formula from the cell above. (shortcut excel formulas)
Ctrl + –: To delete columns or rows.
Ctrl + Shift + =: To insert columns and rows.
Ctrl + N: For create a new workbook.
Ctrl + O: To open a saved workbook.
Ctrl + S: To save a workbook.
Ctrl + A: For select all the contents in a workbook.
Ctrl + B: To turn highlighted cells bold.
+ C: To copy cells that are highlighted.
Ctrl + D: To fill the selected cell with the content of the cell right above.
Ctrl + F: To search for anything in a workbook.
Ctrl + G: To jump to a certain area with a single command.
Ctrl + H: To find and replace cell contents.
Ctrl + U: To underline highlighted cells.
Ctrl + V: To paste anything that was copied.
Ctrl + W: To close your current workbook.
Ctrl + Z: To undo the last action.
Ctrl + 1: To format the cell contents.
Ctrl + 5: To put a strikethrough in a cell.
Ctrl + I: To italicise cell contents.
Ctrl + K: To insert a hyperlink in a cell.
Ctrl + L: To open the create table dialog box.
Ctrl + P: To print a workbook.
Ctrl + R: To fill the selected cell with the content of the cell on the left.