VIEWS: 4,709 PAGES: 3 CATEGORY: Bookkeeping and Payroll Forms POSTED ON: 10/27/2009
An easy-to-read matrix of keyboard shortcuts that will encourage more efficient use of Excel 2007.
Excel 2007 Keyboard Shortcuts +Ctrl + Alt + Shift Key Stand-Alone + Alt +Alt + Shift + Shift + Ctrl + Ctrl-Alt Ctrl + Shift Inserts New Displays or Hides F1 Help Inserts Chart Worksheet Ribbon Edits active cell; moves cursor to end of cell contents. Adds or edits cell Displays Print F2 When cell editing comment. Preview is off, moves insertion point to Formula Bar. Displays Paste Displays Insert F3 Name dialogue Function dialogue box. box. Repeats last Closes workbook F4 command or action. window. Displays Go To Restores window F5 dialogue box. size. Switches between Switches between worksheet, worksheet, Zoom Switches to next F6 Ribbon, task pane controls, task pane workbook window. and Zoom controls. and Ribbon. Displays Spelling Performs Move F7 dialogue box. function. Add a non- Turns extend mode Opens Macro adjacent cell or Performs Size F8 off or on. dialogue box. range to a command. selection of cells. Calculates all Re-checks Calculates all Minimizes a worksheets in dependent Calculates the F9 worksheets in workbook window open workbooks, formulas and active worksheet. open workbooks. to an icon. even if formulas calculates all cells have not changed. in open workbooks. Page 1 of 3 Excel 2007 Keyboard Shortcuts +Ctrl + Alt + Shift Key Stand-Alone + Alt +Alt + Shift + Shift + Ctrl + Ctrl-Alt Ctrl + Shift Displays menu or Maximizes or Turns key tips on Displays the F10 message for a restores the or off. shortcut menu. Smart Tag. workbook window. Creates a chart of Opens the Inserts a new F11 the data in the Microsoft Visual worksheet. current range. Basic editor. Displays the Save F12 As dialogue box. Removes cell DELETE contents but leaves formatting. With Scroll Lock on, moves to the cell in the lower Moves to the last Extends selection right corner of cell in a worksheet. of cells to the last END window. In the formula bar, used cell in the When a menu is moves to the end worksheet. visible, selects the of the text. last command on that menu. Selects the current Moves one screen Moves to the Moves one screen sheet and the PAGE UP to the left in a previous sheet in a up in a worksheet. previous sheet in a worksheet workbook. workbook. Selects the current Moves one screen Moves one screen Moves to the next sheet and the next PAGE DOWN down in a to the right in a sheet in a sheet in a worksheet. worksheet. workbook. workbook. Extends selection Extends selection Moves to the edge to the last Move one cell left. by one cell to the of the current data populated cell in left. to the left. the same row or column to the left. Page 2 of 3 Excel 2007 Keyboard Shortcuts +Ctrl + Alt + Shift Key Stand-Alone + Alt +Alt + Shift + Shift + Ctrl + Ctrl-Alt Ctrl + Shift Extends selection Extends selection Moves to the edge to the last Move one cell by one cell to the of the current data populated cell in right. right. to the right. the same row or column to the right. Extends selection Moves to the to the last Extends selection Move one cell up. bottom of the populated cell in by one cell up. current data. the same row or column up. Extends selection to the last Move one cell Opens a selected Extends selection Moves to the top populated cell in down. drop-down menu. by one cell down. of the current data. the same row or column down. In a dialogue box, performs the Selects an entire action for the Displays the Selects an entire Selects the entire SPACE BAR column in a selected button. control menu. row in a workbook. worksheet. worksheet. Selects or clears a checkbox. Moves one cell to Switches to the Switches to the the right in a Moves to the TAB next tab in a previous tab in a worksheet. previous cell. dialogue box. dialogue box. Page 3 of 3 Page 3 of 3
Pages to are hidden for
"Excel 2007 Keyboard Shortcuts"Please download to view full document