TypingWorks.in

Advertisement

Commonly Used Keyboard Shortcuts

Discover essential keyboard shortcuts for Excel to enhance your productivity. From workbook operations to cell navigation and formatting, streamline your tasks with these efficient shortcuts. Boost your Excel skills today!

5 min read

Catherine

By Catherine

Table of Contents

Workbook Operations:

  • Ctrl+W: Close the currently active workbook.
  • Ctrl+O: Open a new workbook.
  • Ctrl+S: Save the current workbook.
  • Ctrl+C: Copy the selected content.
  • Ctrl+V: Paste the copied content.
  • Ctrl+Z: Undo the most recent action.
  • Delete: Remove the content of the selected cell.
  • Ctrl+X: Cut the selected content.
  • Ctrl+9: Hide selected rows.
  • Ctrl+0: Hide selected columns.

Ribbon Navigation:

Advertisement

  • Alt+H: Access the Home tab.
  • Alt+N: Navigate to the Insert tab.
  • Alt+P: Open the Page Layout tab.
  • Alt+A: Access the Data tab.
  • Alt+M: Navigate to the Formula tab.
  • Alt+R: Open the Review tab.
  • Alt+W: Access the View tab.
  • Alt+Q: Access the Ribbon tabs and enter search term for assistance.

Ribbon Tabs Navigation:

  • Alt or F10: Select the active tab on the ribbon.
  • Tab key or Shift+Tab: Move focus to commands on the ribbon.
  • Arrow keys: Navigate among the items on the ribbon.
  • Ctrl+Shift+F10: Show tooltip for the focused ribbon element.
  • Spacebar or Enter: Activate a selected button.
  • Alt+Down arrow key: Open the menu for a selected button.
  • Shift+F10: Open a context menu.

Cell Navigation:

  • Shift+Tab: Move to the previous cell or option.
  • Arrow keys: Move up, down, left, or right among cells.
  • Ctrl+Arrow key: Move to the edge of the current data region.
  • End, Arrow key: Enter End mode and move accordingly.
  • Ctrl+End: Move to the last cell on a worksheet.
  • Ctrl+Shift+End: Extend selection to the last used cell.
  • Ctrl+Home: Move to the beginning of a worksheet.
  • Page down/Page up: Scroll down/up one screen.
  • Ctrl+Page down/Page up: Move to the next/previous sheet.

Formatting Cells:

  • Ctrl+1: Open the Format Cells dialog box.
  • F2: Edit active cell or formula.
  • Ctrl+Shift+F or Ctrl+Shift+P: Format fonts.
  • Ctrl+B: Apply or remove bold formatting.
  • Ctrl+I: Italicize text.
  • Ctrl+U: Underline text.
  • Ctrl+Shift+&: Apply outline border.
  • Ctrl+Shift+_: Remove outline border.
  • Ctrl+Shift+~: Apply General number format.
  • Ctrl+Shift+$: Apply Currency format.
  • Ctrl+Shift+%: Apply Percentage format.
  • Ctrl+Shift+#: Apply Date format.
  • Ctrl+Shift+@: Apply Time format.
  • Ctrl+Shift+!: Apply Number format.
  • Ctrl+K: Insert a hyperlink.

Selections and Actions:

  • Ctrl+A: Select the entire worksheet.
  • F8/Shift+F8: Extend selection mode.
  • Alt+Enter: Start a new line in the same cell.
  • Ctrl+Enter: Fill selected cell range with current entry.
  • Shift+Enter: Complete cell entry and select cell above.
  • Ctrl+Spacebar/Shift+Spacebar: Select entire column/row.
  • Ctrl+Shift+Spacebar: Select all objects on a worksheet.
  • Ctrl+Shift+Home: Extend selection to the beginning of worksheet.
  • Ctrl+A (Repeated): Select current region or entire worksheet.
  • Ctrl+Shift+*: Select current region around active cell.

Data, Functions, and Formula Bar:

  • F2: Edit active cell or formula.
  • Ctrl+Shift+U: Expand or collapse the formula bar.
  • Ctrl+Alt+P: Turn on or off tooltips for checking formulas.
  • F9/Shift+F9: Calculate worksheets.
  • Ctrl+Shift+F9/Ctrl+Alt+Shift+F9: Check dependent formulas and calculate all cells.
  • Alt+=: Insert AutoSum formula.
  • F4: Cycle through reference combinations in a formula.
  • F3: Paste a name from the Paste Name dialog box.
  • Enter: Move to the next field in a data form.
  • Alt+F11: Open the Visual Basic For Applications Editor.
  • Alt+F12: Open the Power Query Editor.

Refreshing External Data:

  • Esc: Stop a refresh operation.
  • Ctrl+F5: Refresh data in the current worksheet.
  • Ctrl+Alt+F5: Refresh all data in the workbook.

Power Pivot:

  • Shift+F10: Open context menu.
  • Ctrl+A/Ctrl+C/Ctrl+Y/Ctrl+Z: Select/Copy/Redo/Undo.
  • Ctrl+D/Ctrl+R: Delete/Rename table.
  • Ctrl+M: Move table.
  • Ctrl+Spacebar/Shift+Spacebar: Select current column/row.
  • Shift+Page down/Page up/End/Home/Ctrl+Page up/Ctrl+Page down/Ctrl+Home/Ctrl+End/Ctrl+Left or Right arrow key: Select cells or move to different tables.

These keyboard shortcuts facilitate efficient navigation and operation within Excel, optimizing workflow and productivity.