Excel Shortcut list PDF

Download PDF of Excel Shortcut list from concordia.ca

143 People Like This
SHARE THIS AND SPREAD THE LOVE
 
Report this PDF

Download Excel Shortcut list PDF for free from concordia.ca using the direct download link given below.

Excel Shortcut list

First, let’s take a look at some general keyboard shortcuts for manipulating workbooks, getting help, and a few other interface-related actions.

  • Ctrl+N: Create a new workbook
  • Ctrl+O: Open an existing workbook
  • Ctrl+S: Save a workbook
  • F12: Open the Save As dialog box
  • Ctrl+W: Close a workbook
  • Ctrl+F4: Close Excel
  • F4: Repeat the last command or action. For example, if the last thing you typed in a cell is “hello,” or if you change the font color, clicking another cell and pressing F4 repeats that action in the new cell.
  • Shift+F11: Insert a new worksheet
  • Ctrl+Z: Undo an action
  • Ctrl+Y: Redo an action
  • Ctrl+F2: Switch to Print Preview
  • F1: Open the Help pane
  • Alt+Q: Go to the “Tell me what you want to do” box
  • F7: Check spelling
  • F9: Calculate all worksheets in all open workbooks
  • Shift+F9: Calculate active worksheets
  • Alt or F10: Turn key tips on or off
  • Ctrl+F1: Show or hide the ribbon
  • Ctrl+Shift+U: Expand or collapse the formula bar
  • Ctrl+F9: Minimize the workbook window
  • F11: Create a bar chart based on selected data (on a separate sheet)
  • Alt+F1: Create an embedded bar chart based on select data (same sheet)
  • Ctrl+F: Search in a spreadsheet, or use Find and Replace
  • Alt+F: Open the File tab menu
  • Alt+H: Go to the Home tab
  • Alt+N: Open the Insert tab
  • Alt+P: Go to the Page Layout tab
  • Alt+M: Go to the Formulas tab
  • Alt+A: Go to the Data tab
  • Alt+R: Go to the Review tab
  • Alt+W: Go to the View tab
  • Alt+X: Go to the Add-ins tab
  • Alt+Y: Go to the Help tab
  • Ctrl+Tab: Switch between open workbooks
  • Shift+F3: Insert a function
  • Alt+F8: Create, run, edit, or delete a macro
  • Alt+F11: Open the Microsoft Visual Basic For Applications Editor

Moving Around in a Worksheet or Cell

You can use keyboard shortcuts to easily navigate throughout your worksheet, within a cell, or throughout your entire workbook.

  • Left/Right Arrow: Move one cell to the left or right
  • Ctrl+Left/Right Arrow: Move to the farthest cell left or right in the row
  • Up/Down Arrow: Move one cell up or down
  • Ctrl+Up/Down Arrow: Move to the top or bottom cell in the column
  • Tab: Go to the next cell
  • Shift+Tab: Go to the previous cell
  • Ctrl+End: Go to the most bottom right used cell
  • F5: Go to any cell by pressing F5 and typing the cell coordinate or cell name.
  • Home: Go to the leftmost cell in the current row (or go to the beginning of the cell if editing a cell)
  • Ctrl+Home: Move to the beginning of a worksheet
  • Page Up/Down: Move one screen up or down in a worksheet
  • Alt+Page Up/Down: Move one screen to the right or left in a worksheet
  • Ctrl+Page Up/Down: Move to the previous or next worksheet

Download the Excel Shortcut list in PDF format using the link given below.

+ Show More

Excel Shortcut list PDF Download Link

REPORT THISIf the download link of Excel Shortcut list PDF is not working or you feel any other problem with it, please REPORT IT by selecting the appropriate action such as copyright material / promotion content / link is broken etc. If Excel Shortcut list is a copyright material we will not be providing its PDF or any source for downloading at any cost.

RELATED PDF FILES

Leave a Reply

Your email address will not be published. Required fields are marked *