[toolbars]  [shortcut]  [euro]  [new2002]  [new2003]  [deactivate]  [reassign]  [mykeys]  [formatting]  [winkey]  [autofit
[calc]  [volatile]  [rclick]  [cursor]  [ErrMsgs]  [HELP]  [accessibility]  [related]  [more

Shortcut Keys in Excel 2000 through Excel 2007

Applies to ALL versions of Excel though started from Excel 2000 (Excel Vers. 9).
Location:   http://www.mvps.org/dmcritchie/excel/shortx2k.htm
Home page: http://www.mvps.org/dmcritchie/excel/excel.htm
[View without Frames]

Keyboard shortcuts and keyboard help is available in many "Help" files of Microsoft products.  To find the keyboard shortcuts, go to Help and in the contents or index area, type in "keyboard", from a Tip in Keyboard Assistance and Shortcuts for Microsoft Products [fixed Microsoft link] which lists links to keyboard shortcuts for leading Microsoft products (be sure to use the "Show All" to expand links on the individual Microsoft pages).  In the builtin HELP you cannot expand information but have to go through several pages and if you can't find what you want when you want it the feature isn't going to do you any good for as long as you don't know about it or can't find it.

documentation of builtin and userdefined toolbar menus and icons:  (nothing in Help) (#toolbar)

Rather than just telling you to create a Shortcut keys sheet in an Excel file I decided to show you what mine looks like.  Since converting it to HTML, I find this HTML file so much easier and faster to use than the original Excel version.

The logical arrangement of the keyboard shortcut keys is exactly as from the Excel HELP file.  You can use FIND (Ctrl+F) within a HELP page, but not on all of the shortcut keys pages at once.  So having them all on one web page has a huge advantage.

Creation of Shortcut keys spreadsheet  (#shortcut)

Shortcuts are entirely optional.  A shortcut key can be assigned to a macro using: Tools --> Macro --> (select a macro) --> Options.  Excel will Warn you if you attempt to utilize a short cut key already in use -- it will change the form of assignment for instance.  You will have to remember them or write them down somewhere.  I highly recommend creating a sheet for your MS Excel installed shortcut keys so that you can use FIND to find a shortcut yourself.   You could even add your own at the bottom.  Also recommend creating another sheet for function keys.  You can get a list of your own shortcut keys assigned to macros with an addin by Ivan F Moala. (see later reference for Moala under #utilities)

Create your table of builtin shortcut keys as follows:

Alternatives to shortcut keys:  Toolbar menu item, more information on menus and shortcuts on my Toolbars and Menus page.  Assign a shortcut to a Shape, or use an Event Macro.  An interesting pair of Event macros (sheet activate and double-click) to sort a worksheet can be found on my sorting page under activate.

I have assigned a short-cut key [Ctrl+k] or a tool bar menu item [* XL2HTML - simple conversion*] to some of the macros I wrote or use.

Function keys
Function keys   SHIFT+Fn   [Shift+F1, shift+F2, Shift+F3, Shift+F4, Shift+F5, Shift+F6, Shift+F7, Shift+F8, Shift+F9, Shift+F10, Shift+F11, Shift+F12]
F1 Get online Help or the Answer Wizard Context Sensitive Help or What's This (prior to 2003)
F2 Activate a cell and the formula bar
If you do tools>option>edit and uncheck edit directly in cell, then F2 will put you in edit mode in the formula bar.
Edit a cell note (edit a comment)
F3 Paste a name into a formula Display the Function Wizard fx
F4 Repeat the last action.
Cycle through absolute/relative links a the locaiton bar.
Repeat a Find or Go To action, Find next blank cell in a selection or used range if no selection
F5 Carry out the Go To command (Edit menu) Carry out the Find command (Edit menu)
F6 Go to the next pane Go to the previous pane
F7 Carry out the Spelling command (Tools menu)  
F8 Extend a selection (expand see extend) Turns Add mode on or off
F9 Calculate all sheets in all open workbooks Calculate the active sheet
F10 Activate the menu bar Display a shortcut menu
F11 Create a chart  
F12 Carry out the Save As command (File menu) Carry out the Save command (File menu)

 

Function keys (continued)
Function keys CTRL+Fn   [Ctrl+F2, Ctrl+F3, Ctrl+F4, Ctrl+F5, Ctrl+F6, Ctrl+F7, Ctrl+F8, Ctrl+F9, Ctrl+F10, Ctrl+F12] CTRL+Shift+Fn   [Ctrl+Shift+F3, Ctrl+Shift+F6, Ctrl+Shift+F12]
F1 Toggles "minimize/restore ribbon" in 2007  
F2 Display the Info window  
F3 Define a name Create names from cell text
F4 Close the window  
F5 Restore the window size  
F6 Go to the next workbook Go to the previous workbook
F7 Carry out the Move command (Control menu)  
F8 Carry out the Size command (document Control menu)  
F9 Minimize the workbook  
F10 Maximize the document window  
F11    
F12 Carry out the Open command (File menu) Carry out the Print command (File menu)

 

Function keys (continued)
Function keys ALT+SHIFT+Fn CTRL+ALT+Fn
F1 Insert a new worksheet   [Alt+Shift+F1] or menus [Alt+I+W]  
F9   Recalculate all cells on all worksheets in all open workbooks  [Ctrl+Alt+F9]
F10   Show the Smart Tag Menu (added since Excel 2000)  [Ctrl+Shift+F10]
 Menus:  At least some of the following keyboard shortcuts found in the menus   (#menus)
 do not appear in HELP.  Find [Ctrl+F],   Replace [Ctrl+H],   GoTo [Ctrl+G] are not found in HELP. 

With the replacement of menus in Excel 2007 by the ribbon and the removal of actual HELP files which are online in Excel 2007 and are poorly indexed (no match for a Google search on the same database), it becomes almost imperative to learn a lot more keyboard shortcuts than ever before.  In this group you should be using all of them, and before Excel 2007, I had not bothered remembering the one for format -- but that is all changed.

  Edit Menu: 
   Undo [Ctrl+Z],   Repeat [Ctrl+Y],  
   Cut [Ctrl+X],   ccc Copy [Ctrl+C],   Paste [Ctrl+V]
   Fill Down [Ctrl+D],   Fill Right [Ctrl+R]
         clear contents [Del]
   Find [Ctrl+F],     Replace [Ctrl+H],      GoTo [Ctrl+G]  (none of these 3 are in help)
If you want you could install these into your Edit menu from customize
     Paste Values,     Paste Formatting  
    
  Format Menu: 
   Format Cells [Ctrl+1]
    
  Tools Menu:
   Spelling... [Ctrl+F7]
   Macro: 
     Macros [Alt+F8]
     Visual Basic Editor (VBE) [Alt+F11]
     Microsoft Script Editor [Alt+Shift+F11]
    
  Help Menu: 
   Help [F1]
   What's This [Shift+F1] -- also known as Context Sensitive Help   [not available in Excel 2007] contexthelp
    
  Keyboard Access to Menus: 
   Use of Alt+  and the underscored letter on a menu. 
   Also works within Help -- to see the menu names move the cursor over the symbols.
  

Note these shortcuts are with transition navigation keys option turned off.  If you have a problem with any of these shortcuts -- tools, options, transition, make sure transition navigation keys is off -- also make sure that you do not have Scroll Lock on (there is an indicator light and you can have sound warning with ToggleKeys for Scroll Lock)   /* required outside generated table*/.

   XL2000 Keyboard Shortcuts Keystrokes to invoke 
   Location: http://www.mvps.org/dmcritchie/excel/shortx2k.htm
  Use FIND to locate a shortcut Use FIND to locate a shortcut 
   
   If you create your own table in Excel from the Help files it will contain shortcuts to the HELP files, and give you some experience in copying data.  This table was created by copying from the HELP file.  Segments have been swapped left and right to make this more readable using move Column C by dragging the side of selected cells to Column A then using Edit, Shift cells to right. This table is similar to the one in SHORTX95.HTM where you will find additional information on Calculation and on working with disabilities (accessibility options).
  (shortx2k -- Created from webpages.xls [ShortX2K] file 2000-06-25) 
   Keys for working in a spreadsheet
 s1  Keys for moving and scrolling in a worksheet or workbook
 s2  Keys for previewing and printing a document
 s3  Keys for working with worksheets, charts, and macros
   Keys for working with data
 Keys for entering data
 Keys for formatting data
 Keys for editing data
 Keys for selecting data and cells
 Keys for selecting charts and chart items
 Keys to use with databases and lists
 Keys for outlining data
 Keys to use with PivotTable and PivotChart reports
x9   Keys to use with the OLAP Cube Wizard
   Keys for working in Microsoft Office
10   Keys for menus and toolbars
11   Keys for windows, dialog boxes, and edit boxes
12   Keys for the Office Assistant
13   Keys for working with the Open and Save As dialog boxes
14   Keys for sending e-mail messages
15   Keys for working with drawing objects, AutoShapes, WordArt, and other objects
                                                                                        
   Keys for working in a spreadsheet
   Keys for moving and scrolling in a worksheet or workbook
   
  Windows Shortcuts  Note   To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. To restore the window to its previous size and location, press ALT+SPACEBAR and then press R. To print this topic, press ALT+O and then press P.  Use of ALT+SPACEBAR is also good to move a window when the titlebar gets stuck under the top of the screen.  More on handling Windows Window and an Excel Window.  ALT+SPACEBAR then X (Maximize)
 ALT+SPACEBAR then R (Restore)
 ALT+SPACEBAR then M (Move)
  
  This topic lists:
   Keys for moving and scrolling in a worksheet or workbook
   Keys for moving in a worksheet with End mode on
   Keys for moving in a worksheet with SCROLL LOCK on
  
 s1  Keys for moving and scrolling in a worksheet or workbook
  Move one cell up, down, left, or right  Arrow keys
   Move to the edge of the current data region
 Mouse alternative: double-click on cell border in direction wanted.
 CTRL+arrow key
  Move to the beginning of the row  HOME
  Move to the beginning of the worksheet  CTRL+HOME
   Move to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottom-most used row (in the lower-right corner), or the cell opposite the home cell, which is typically A1  CTRL+END
  Move down one screen PAGE DOWN
  Move up one screen PAGE UP
  Move one screen to the right  ALT+PAGE DOWN
  Move one screen to the left  ALT+PAGE UP
   Move to the next sheet in the workbook  CTRL+PAGE DOWN
   Move to the previous sheet in the workbook  CTRL+PAGE UP
  Move to the next workbook or window  CTRL+F6 or CTRL+TAB
  Move to the previous workbook or window  CTRL+SHIFT+F6 or CTRL+SHIFT+TAB
   Move to the next pane in a workbook that has been split F6
   Move to the previous pane in a workbook that has been split  SHIFT+F6
  Scroll to display the active cell  CTRL+BACKSPACE
  Display the Go To dialog box F5
  Display the Find dialog box  SHIFT+F5
   Repeat the last Find action (same as Find Next) SHIFT+F4
   Move between unlocked cells on a protected worksheet TAB
   
 s2  Keys for moving in a worksheet with End mode on  
  Turn End mode on or off END
   Move by one block of data within a row or column
 (a shortcut for this shortcut is to double-click on a cell border)
 END, arrow key
 Move to the last cell on the worksheet, which is the cell at the intersection of the rightmost used column and the bottom-most used row (in the lower-right corner), or the cell opposite the home cell, which is typically A1  END, HOME
   Move to the last cell to the right in the current row that is not blank; unavailable if you have selected the Transition navigation keys check box on the Transition tab (Tools menu, Options command)  END, ENTER
   
 s3  Keys for moving in a worksheet with SCROLL LOCK on
  Turn SCROLL LOCK on or off  SCROLL LOCK
   Move to the cell in the upper-left corner of the window HOME
   Move to the cell in the lower-right corner of the window END
  Scroll one row up or down  UP ARROW or DOWN ARROW
  Scroll one column left or right  LEFT ARROW or RIGHT ARROW
   
   Tip   When you use scrolling keys (such as PAGE UP and PAGE DOWN) with SCROLL LOCK turned off, your selection moves the distance you scroll. If you want to preserve your selection while you scroll through the worksheet, turn on SCROLL LOCK first.
  
   Keys for working with data
 Keys for entering data
   Note   To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. To restore the window to its previous size and location, press ALT+SPACEBAR and then press R. To print this topic, press ALT+O and then press P.  ALT+SPACEBAR then X
 ALT+SPACEBAR then R
   
  This topic lists: 
   Keys for entering data on a worksheet  
   Keys for working in cells or the formula bar  
   
   Keys for entering data on a worksheet
   Complete a cell entry and move down in the selection ENTER
  Start a new line in the same cell   (IBM ThinkPad problem...)  ALT+ENTER   (Mac: Ctrl Command Enter)
   Fill the selected cell range with the current entry  CTRL+ENTER
   Complete a cell entry and move up in the selection  SHIFT+ENTER
   Complete a cell entry and move to the right in the selection  TAB
   Complete a cell entry and move to the left in the selection  SHIFT+TAB
  Cancel a cell entry ESC
   Delete the character to the left of the insertion point, or delete the selection  BACKSPACE
   Delete the character to the right of the insertion point, or delete the selection  DELETE
  Delete text to the end of the line  CTRL+DELETE
   Move one character up, down, left, or right Arrow keys
  Move to the beginning of the line  HOME
 Repeat the last action  F4 or CTRL+Y
  Edit a cell comment SHIFT+F2
  Create names from row and column labels  CTRL+SHIFT+F3
 Fill down CTRL+D
 Fill to the right CTRL+R
  Define a name CTRL+F3
  
   Keys for working in cells or the formula bar
   Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit cell contents  BACKSPACE
  Complete a cell entry ENTER
  Enter a formula as an array formula  CTRL+SHIFT+ENTER
  Cancel an entry in the cell or formula bar  ESC
   Display the Formula Palette after you type a function name in a formula  CTRL+A
   Insert the argument names and parentheses for a function after you type a function name in a formula  CTRL+SHIFT+A
  Insert a hyperlink CTRL+K
  Activate a hyperlink  ENTER (in a cell with a hyperlink)
   Edit the active cell and position the insertion point at the end of the line  F2
  Paste a defined name into a formula  F3
fx  Paste a function into a formula -- [fx] toolbar button, replace missing button  SHIFT+F3
  Calculate all sheets in all open workbooks  F9
   Calculate all sheets in the active workbook CTRL+ALT+F9
  Calculate the active worksheet  SHIFT+F9
  Start a formula = (equal sign)
  Insert the AutoSum formula  ALT+= (equal sign)
  Enter the date CTRL+; (semicolon)
  Enter the time  CTRL+SHIFT+: (colon)
   Copy the value from the cell above the active cell into the cell or the formula bar  CTRL+SHIFT+" (quotation mark)
   Alternate between displaying cell values and displaying cell formulas  CTRL+` (accent grave /not a quotation mark)
   Copy a formula from the cell above the active cell into the cell or the formula bar  CTRL+' (apostrophe / single quote)
  Display the AutoComplete list (i.e. cell with data validation dropdown)  ALT+DOWN ARROW
   
 Keys for formatting data  
   Note   To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. To restore the window to its previous size and location, press ALT+SPACEBAR and then press R. To print this topic, press ALT+O and then press P.  ALT+SPACEBAR then X
 ALT+SPACEBAR then R
  Display the Style dialog box  ALT+' (apostrophe / single quote)
  Display the Format Cells dialog box  CTRL+1
  Apply the General number format  CTRL+SHIFT+~
   Apply the Currency format with two decimal places (negative numbers appear in parentheses)  CTRL+SHIFT+$
   Apply the Percentage format with no decimal places  CTRL+SHIFT+%
   Apply the Exponential number format with two decimal places  CTRL+SHIFT+^
   Apply the Date format with the day, month, and year  CTRL+SHIFT+#
   Apply the Time format with the hour and minute, and indicate A.M. or P.M.  CTRL+SHIFT+@
   Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values  CTRL+SHIFT+!
  Apply the outline border  CTRL+SHIFT+&
  Remove outline borders  CTRL+SHIFT+_
  Apply or remove bold formatting  CTRL+B
  Apply or remove italic formatting  CTRL+I
  Apply or remove an underline  CTRL+U
 Apply or remove strikethrough formatting  CTRL+5
  Hide rows CTRL+9
  Unhide rows  CTRL+SHIFT+( (opening parenthesis)
  Hide columns CTRL+0 (zero)
  Unhide columns  CTRL+SHIFT+) (closing parenthesis)
  
 Keys for editing data
   Note   To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. To restore the window to its previous size and location, press ALT+SPACEBAR and then press R. To print this topic, press ALT+O and then press P.  ALT+SPACEBAR then X
 ALT+SPACEBAR then R
   
  This topic lists: 
   Keys for editing data  
   Keys for inserting, deleting, and copying a selection  
   Keys for moving within a selection  
   
  Keys for editing data
   Edit the active cell and put the insertion point at the end of the line  F2
  Cancel an entry in the cell or formula bar  ESC
   Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit the cell contents  BACKSPACE
  Paste a defined name into a formula  F3
  Complete a cell entry ENTER
  Enter a formula as an array formula  CTRL+SHIFT+ENTER
   Display the Formula Palette after you type a function name in a formula  CTRL+A
   Insert the argument names and parentheses for a function, after you type a function name in a formula  CTRL+SHIFT+A
  Display the Spelling dialog box  F7
  
   Keys for inserting, deleting, and copying a selection
ccc Copy the selection CTRL+C
 Cut the selection CTRL+X
 Paste the selection CTRL+V
  Clear the contents of the selection  DELETE
  Delete the selection CTRL+HYPHEN   [Ctrl+-]
 Undo the last action CTRL+Z
  Insert blank cells  CTRL+SHIFT+PLUS SIGN   [Ctrl++]
   
   Keys for moving within a selection
   Move from top to bottom within the selection (down), or move in the direction that is selected on the Edit tab (Tools menu, Options command)  ENTER
   Move from bottom to top within the selection (up), or move opposite to the direction that is selected on the Edit tab (Tools menu, Options command)  SHIFT+ENTER
   Move from left to right within the selection, or move down one cell if only one column is selected  TAB
   Move from right to left within the selection, or move up one cell if only one column is selected  SHIFT+TAB
   Move clockwise to the next corner of the selection  CTRL+PERIOD
   Move to the right between nonadjacent selections  CTRL+ALT+RIGHT ARROW
   Move to the left between nonadjacent selections  CTRL+ALT+LEFT ARROW
  
 Keys for selecting data and cells
  This topic lists:
   Keys for selecting cells, columns, or rows  
   Keys for extending the selection with End mode on  
   Keys for selecting cells that have special characteristics  
  
   Keys for selecting cells, columns, or rows
   Select the current region around the active cell (the current region is a data area enclosed by blank rows and blank columns)  CTRL+SHIFT+* (asterisk)
  Extend the selection by one cell  SHIFT+arrow key
   Extend the selection to the last nonblank cell in the same column or row as the active cell  CTRL+SHIFT+arrow key
   Extend the selection to the beginning of the row SHIFT+HOME
   Extend the selection to the beginning of the worksheet  CTRL+SHIFT+HOME
   Extend the selection to the last used cell on the worksheet (lower-right corner)  CTRL+SHIFT+END
  Select the entire column (remains valid in Excel 2003)  CTRL+SPACEBAR
  Select the entire row (remains valid in Excel 2003)  SHIFT+SPACEBAR
  Select the entire worksheet
     (the grey button to the left of column headings (A-B-C), and above the
      row headings (1-2-3) is similar but does change the active cell)
 CTRL+A (unless you have Excel 2003)
   Select only the active cell when multiple cells are selected  SHIFT+BACKSPACE
  Extend the selection down one screen  SHIFT+PAGE DOWN
  Extend the selection up one screen  SHIFT+PAGE UP
   With an object selected, select all objects on a sheet (Excel 2003 behavior is broken by design just like Excel 2003 Alt+A)  CTRL+SHIFT+SPACEBAR (broken by Excel 2003)
   Alternate between hiding objects, displaying objects, and displaying placeholders for objects  CTRL+6
  Show or hide the Standard toolbar  CTRL+7
   Turn on extending a selection by using the arrow keys F8
   Add another range of cells to the selection; or use the arrow keys to move to the start of the range you want to add, and then press F8 and the arrow keys to select the next range  SHIFT+F8
   Extend the selection to the cell in the upper-left corner of the window  SCROLL LOCK, SHIFT+HOME
   Extend the selection to the cell in the lower-right corner of the window  SCROLL LOCK, SHIFT+END
  
  Return to top
  
   Tip   When you use the scrolling keys (such as PAGE UP and PAGE DOWN) with SCROLL LOCK turned off, your selection moves the distance you scroll. If you want to keep the same selection as you scroll, turn on SCROLL LOCK first.
   
   Keys for extending the selection with End mode on
  Turn End mode on or off END
   Extend the selection to the last nonblank cell in the same column or row as the active cell  END, SHIFT+arrow key
   Extend the selection to the last cell used on the worksheet (lower-right corner)  END, SHIFT+HOME
   Extend the selection to the last cell in the current row. This keystroke is unavailable if you selected the Transition navigation keys check box on the Transition tab (Tools menu, Options command).  END, SHIFT+ENTER
  
  Return to top
  
   Keys for selecting cells that have special characteristics
   Select the current region around the active cell (the current region is a data area enclosed by blank rows and blank columns)  CTRL+SHIFT+* (asterisk)
   Select the current array, which is the array that the active cell belongs to  CTRL+/
  Select all cells with comments  CTRL+SHIFT+O (the letter O)
   Select cells in a row that don't match the value in the active cell in that row. You must select the row starting with the active cell.  CTRL+\
   Select cells in a column that don't match the value in the active cell in that column. You must select the column starting with the active cell.  CTRL+SHIFT+|
   Select only cells that are directly referred to by formulas in the selection  CTRL+[ (opening bracket)
   Select all cells that are directly or indirectly referred to by formulas in the selection  CTRL+SHIFT+{ (opening brace)
   Select only cells with formulas that refer directly to the active cell  CTRL+] (closing bracket)
   Select all cells with formulas that refer directly or indirectly to the active cell  CTRL+SHIFT+} (closing brace)
 Select only visible cells in the current selection  ALT+; (semicolon)
  
  
 Keys for selecting charts and chart items
   Keys for selecting a chart sheet
   Select the next sheet in the workbook, until the chart sheet you want is selected  CTRL+PAGE DOWN
   Select the previous sheet in the workbook, until the chart sheet you want is selected  CTRL+PAGE UP
  
   Keys for selecting an embedded chart
   Note   The Drawing toolbar must already be displayed.  
  1. Press F10 to make the menu bar active.  F10
   2. Press CTRL+TAB or CTRL+SHIFT+TAB to select the Drawing toolbar.  CTRL+TAB
 CTRL+SHIFT + TAB
   3. Press the RIGHT ARROW key to select the Select Objects button on the Drawing toolbar.  RIGHT ARROW
   4. Press CTRL+ENTER to select the first object. CTRL+ENTER
   5. Press the TAB key to cycle forward (or SHIFT+TAB to cycle backward) through the objects until sizing handles appear on the embedded chart you want to select.  TAB
   6. Press CTRL+ENTER to make the chart active. CTRL + ENTER
  
   Keys for selecting chart items
  Select the previous group of items  DOWN ARROW
  Select the next group of items  UP ARROW
  Select the next item within the group  RIGHT ARROW
  Select the previous item within the group  LEFT ARROW
   
   There are also keys to use with PivotChart reports.  
  
 Keys to use with databases and lists
   Note   To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. To restore the window to its previous size and location, press ALT+SPACEBAR and then press R. To print this topic, press ALT+O and then press P.  ALT+SPACEBAR then X
 ALT+SPACEBAR then R
  
  This topic lists:
    Keys for working with a data form
    Keys for using AutoFilter
  
   Keys for working with a data form
  Select a field or a command button  ALT+key, where key is the underlined letter in the field or command name
  Move to the same field in the next record  DOWN ARROW
   Move to the same field in the previous record UP ARROW
   Move to the next field you can edit in the record TAB
   Move to the previous field you can edit in the record  SHIFT+TAB
  Move to the first field in the next record  ENTER
   Move to the first field in the previous record SHIFT+ENTER
  Move to the same field 10 records forward  PAGE DOWN
  Move to a new record  CTRL+PAGE DOWN
  Move to the same field 10 records back  PAGE UP
  Move to the first record  CTRL+PAGE UP
  Move to the beginning or end of a field  HOME or END
  Extend a selection to the end of a field  SHIFT+END
   Extend a selection to the beginning of a field SHIFT+HOME
   Move one character left or right within a field  LEFT ARROW or RIGHT ARROW
  Select the character to the left  SHIFT+LEFT ARROW
  Select the character to the right  SHIFT+RIGHT ARROW
  
   Keys for using AutoFilter
   Display the AutoFilter list for the current column  Arrow keys to select the cell that contains the column label, and then press ALT+DOWN ARROW
   Select the next item in the AutoFilter list DOWN ARROW
   Select the previous item in the AutoFilter list UP ARROW
   Close the AutoFilter list for the current column ALT+UP ARROW
   Select the first item (All) in the AutoFilter list HOME
   Select the last item in the AutoFilter list END
   Filter the list by using the selected item in the AutoFilter list  ENTER
  
 Keys for outlining data
   Note   To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. To restore the window to its previous size and location, press ALT+SPACEBAR and then press R. To print this topic, press ALT+O and then press P.  ALT+SPACEBAR then X
 ALT+SPACEBAR then R
  Group rows or columns  ALT+SHIFT+RIGHT ARROW
  Ungroup rows or columns  ALT+SHIFT+LEFT ARROW
  Display or hide outline symbols  CTRL+8
  Hide selected rows CTRL+9
  Unhide selected rows  CTRL+SHIFT+( (opening parenthesis)
  Hide selected columns  CTRL+0 (zero)
  Unhide selected columns  CTRL+SHIFT+) (closing parenthesis)
  
  
 Keys to use with PivotTable and PivotChart reports
   Note   To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. To restore the window to its previous size and location, press ALT+SPACEBAR and then press R. To print this topic, press ALT+O and then press P.  ALT+SPACEBAR then X
 ALT+SPACEBAR then R
  
  This topic lists:
   Keys for the PivotTable and PivotChart Wizard
   Keys for page fields in a PivotTable or PivotChart report
   Keys for laying out a PivotTable or PivotChart report
   Keys for grouping and ungrouping PivotTable items
  
   Keys for the PivotTable and PivotChart Wizard
   Select the previous or next field button in the list  UP ARROW or DOWN ARROW
   Select the field button to the left or right in a multicolumn field button list  LEFT ARROW or RIGHT ARROW
   Move the selected field into the Column area ALT+C
  Move the selected field into the Data area  ALT+D
  Display the PivotTable Field dialog box  ALT+L
  Move the selected field into the Page area  ALT+P
  Move the selected field into the Row area  ALT+R
   
   Keys for page fields in a PivotTable or PivotChart report
  Select the entire PivotTable report  CTRL+SHIFT+* (asterisk)
   Display the list for the current field in a PivotTable report  Arrow keys to select the cell that contains the field, and then ALT+DOWN ARROW
   Display the list for the current page field in a PivotChart report  Arrow keys to select the page field in a PivotChart report, and then ALT+DOWN ARROW
  Select the previous item in the list  UP ARROW
  Select the next item in the list  DOWN ARROW
  Select the first visible item in the list  HOME
  Select the last visible item in the list  END
  Display the selected item ENTER
  Select or clear a check box in the list  SPACEBAR
   
   Keys for laying out a PivotTable or PivotChart report
  1. Press F10 to make the menu bar active.  F10
   2. Press CTRL+TAB or CTRL+SHIFT+TAB to select the PivotTable toolbar.  CTRL+TAB
 CTRL+SHIFT+TAB
   3. Press the LEFT ARROW or RIGHT ARROW key to select the menu to the left or right or, when a submenu is visible, to switch between the main menu and submenu.  LEFT ARROW
 RIGHT ARROW
   4. Press ENTER (on a field button) and the DOWN ARROW and UP ARROW keys to select the area you want to move the selected field to.  ENTER* + DOWN ARROW
 ENTER* + UP ARROW
  
   Note   To scroll to the top or bottom of the field list, press ENTER on the More Fields or button
  
   Keys for grouping and ungrouping PivotTable items
  Group selected PivotTable items  ALT+SHIFT+RIGHT ARROW
  Ungroup selected PivotTable items  ALT+SHIFT+LEFT ARROW
  
  Return to top
   Keys for working in Microsoft Office
10   Keys for menus and toolbars
   Note   To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. To restore the window to its previous size and location, press ALT+SPACEBAR and then press R. To print this topic, press ALT+O and then press P.  ALT+SPACEBAR then X
 ALT+SPACEBAR then R
   Make the menu bar active, or close a visible menu and submenu at the same time  F10 or ALT
   Select the next or previous button or menu on the toolbar  TAB or SHIFT+TAB (when a toolbar is active)
  Select the next or previous toolbar  CTRL+TAB or CTRL+SHIFT+TAB (when a toolbar is active)
   Open the selected menu, or perform the action assigned to the selected button  ENTER
  Show a shortcut menu SHIFT+F10
   Show the program icon menu (on the program title bar)  ALT+SPACEBAR then X
 ALT+SPACEBAR then R
   Select the next or previous command on the menu or submenu  DOWN ARROW or UP ARROW (with the menu or submenu displayed)
   Select the menu to the left or right or, with a submenu visible, switch between the main menu and the submenu  LEFT ARROW or RIGHT ARROW
   Select the first or last command on the menu or submenu  HOME or END
   Close the visible menu or, with a submenu visible, close the submenu only  ESC
  Display the full set of commands on a menu  CTRL+DOWN ARROW
  
   Tip   You can select any menu command on the menu bar or on a visible toolbar with the keyboard. To select the menu bar, press ALT. (Then to select a toolbar, press CTRL+TAB repeatedly until you select the toolbar you want.) Press the underlined letter in the menu name that contains the command you want. In the menu that appears, press the underlined letter in the command name that you want.
  
11   Keys for windows, dialog boxes, and edit boxes
   Note   To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. To restore the window to its previous size and location, press ALT+SPACEBAR and then press R. To print this topic, press ALT+O and then press P.  ALT+SPACEBAR then X
 ALT+SPACEBAR then R
  
   This topic lists shortcut keys for:
   Keys for windows
   Keys for dialog boxes
   Keys for edit boxes in dialog boxes
  
  Keys for windows
  Switch to the next program  ALT+TAB
  Switch to the previous program  ALT+SHIFT+TAB
  Show the Windows Start menu  CTRL+ESC
  Close the active workbook window  CTRL+W or CTRL+F4
  Restore the active workbook window size  CTRL+F5
   Move to the next pane in a workbook that has been split F6
   Move to the previous pane in a workbook that has been split  SHIFT+F6
  Switch to the next workbook window  CTRL+F6
  Switch to the previous workbook window  CTRL+SHIFT+F6
   Carry out the Move command (workbook icon menu, menu bar), or use the arrow keys to move the window  CTRL+F7
   Carry out the Size command (workbook icon menu, menu bar), or use the arrow keys to size the window  CTRL+F8
  Minimize the workbook window to an icon  CTRL+F9
  Maximize or restore the workbook window  CTRL+F10
   Copy the image of the screen to the Clipboard PRTSCR
   Copy the image of the active window to the Clipboard  ALT+PRINT SCREEN
  
  Return to top
  
  Keys for dialog boxes  
  Move to the next option or option group  TAB
   Move to the previous option or option group SHIFT+TAB
  Switch to the next tab in a dialog box  CTRL+TAB or CTRL+PAGE DOWN
  Switch to the previous tab in a dialog box  CTRL+SHIFT+TAB or CTRL+PAGE UP
   Move between options in the active drop-down list box or between some options in a group of options  Arrow keys
   Perform the action assigned to the active button (the button with the dotted outline), or select or clear the active check box  SPACEBAR
  Move to an option in a drop-down list box  Letter key for the first letter in the option name you want (when a drop-down list box is selected)
   Select an option, or select or clear a check box  ALT+letter, where letter is the key for the underlined letter in the option name
  Open the selected drop-down list box  ALT+DOWN ARROW
   Perform the action assigned to the default command button in the dialog box (the button with the bold outline — often the OK button)  ENTER
   Cancel the command and close the dialog box ESC
  
  Return to top
  
  Keys for edit boxes in dialog boxes  
  Move to the beginning of the entry  HOME
  Move to the end of the entry END
  Move one character to the left or right  LEFT ARROW or RIGHT ARROW
  Move one word to the left  CTRL+LEFT ARROW
  Move one word to the right  CTRL+RIGHT ARROW
   Select or unselect one character to the left SHIFT+LEFT ARROW
   Select or unselect one character to the right  SHIFT+RIGHT ARROW
  Select or unselect one word to the left  CTRL+SHIFT+LEFT ARROW
  Select or unselect one word to the right  CTRL+SHIFT+RIGHT ARROW
   Select from the insertion point to the beginning of the entry  SHIFT+HOME
   Select from the insertion point to the end of the entry  SHIFT+END
   
12   Keys for using the Office Assistant
   Get Help. Displays the Assistant balloon if the Assistant is turned on.  F1
   Select a Help topic from the list the Assistant displays  ALT+number (ALT+1 is the first topic, ALT+2 is the second, and so on)
  See more Help topics  ALT+DOWN ARROW
  See previous Help topics  ALT+UP ARROW
  Close an Assistant message or a tip  ESC
  
13   Keys for working with the Open and Save As dialog boxes
  
   Note   To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. To restore the window to its previous size and location, press ALT+SPACEBAR and then press R. To print this topic, press ALT+O and then press P.  ALT+SPACEBAR + x
 ALT+SPACEBAR + R
  
  Display the Open dialog box  CTRL+F12 or CTRL+O
  Save the active workbook  ALT+F2 or F12 or CTRL+S
  Display the Save as dialog box  ALT+SHIFT+F2 or SHIFT+F12
  Go to the previous folder ()  ALT+1
   Open the folder up one level from the open folder (Up One Level button )  ALT+2
   Close the dialog box, and open your World Wide Web search page (Search the Web button )  ALT+3
   Delete the selected folder or file (Delete button ) ALT+4
   Create a new subfolder in the open folder (Create New Folder button )  ALT+5
   Switch between List, Details, Properties, and Preview views  ALT+6
  Show the Tools menu (Tools button)  ALT+7
  
14   Keys for sending e-mail messages
   To use keys to send e-mail messages, you must configure Microsoft Outlook as your default e-mail program. If Outlook Express is your default e-mail program, you cannot use most of these keys to send e-mail messages.  [OE shortcuts]
  
   Note   To enlarge the Help window to fill the screen, press ALT+SPACEBAR and then press X. To restore the window to its previous size and location, press ALT+SPACEBAR and then press R. To print this topic, press ALT+O and then press P.  ALT+SPACEBAR then X
 ALT+SPACEBAR then R
   Move to the e-mail message header. Cell A1 must be the active cell when you press these keys.  SHIFT+TAB
   Send the active spreadsheet as an e-mail message ALT+S
  Open the Address Book  CTRL+SHIFT+B
   Check the names in the To, Cc, and Bcc boxes against the Address Book  ALT+K
  Open the Address Book in the To box  ALT+PERIOD
  Open the Address Book in the Cc box  ALT+C
  Open the Address Book in the Bcc box  ALT+B
  Go to the Subject box ALT+J
   Open the Outlook Message Options dialog box (View menu, Options command in a message)  ALT+P
  Create a message flag  CTRL+SHIFT+G
  
15   Keys for working with drawing objects, AutoShapes, WordArt, and other objects
  
   Inserting drawing objects
  Insert an AutoShape ALT+U
  Insert a text box 
  Insert a WordArt object  
   
  Selecting drawing objects  
  Select a drawing object  F10 for toolbar
   
  Editing drawing objects  
  Rotate a drawing object  
  Change the size of a drawing object  
  Copy the attributes of a drawing object  
  
   Rotate a drawing object by using the keyboard
   1. Use the keyboard to select the drawing object you want to rotate.
   2. On the Format menu, select the command for the type of object selected — for example, AutoShape or Text Box — and then select the Size tab.
   3. In the Rotation box, enter the amount of rotation you want.
  
   Change the size of a drawing object by using the keyboard
   1. Use the keyboard to select the drawing object you want to resize.
   2. On the Format menu, select the command for the type of object selected — for example, AutoShape or Text Box — and then choose the Size tab.
  
   Select the options you want. For help on an option, select the option, and then press SHIFT+F1.
  
   Copy the attributes of a drawing object by using the keyboard
   1. Use the keyboard to select the drawing object with the attributes you want to copy.
   If you select an AutoShape with attached text, the look and style of the text as well as the attributes of the AutoShape are copied.
  2. to copy the object attributes.  Press CTRL+SHIFT+C
   3. to select the object you want to copy the attributes to.  Press TAB or SHIFT+TAB
  4. to copy the attributes to the object.  Press CTRL+SHIFT+V
  
   This webpage was created via XL2HTML macro available at 02/27/2001 10:56 via HL2HTML
 http://www.mvps.org/dmcritchie/excel/xl2htmlx.txt
   Will handle Right Justified, Font Color, bold, italic, Font size, merged cells -- tested only in XL2000. Think vertically merged was added in XL2000.
   Will handle hyperlink when it is the only value in a cell.
   Will not handle: Interior color, hyperlinks when not only value in a cell
  
xx  Shortcuts NOT documented in Excel 2000 (see menus)   Find [Ctrl+F], Replace [Ctrl+H], GoTo [Ctrl+G] are not found in HELP
* Find Ctrl+F
  Replace Ctrl+H
  
xx Shortcuts added in later versions of Excel
   reveal the smart tag menu  ALT+SHIFT+F10
A similar table, Loughborough University - Excel 2000 Keyboard Shortcuts (92.4 KB / 20 pages / Dreamweaver)

Microsoft Office Assistance: Keyboard shortcuts  for Excel 2003, be sure to click on “Show All” to see all descriptions (27.24KB, 22 pages).  (for things to come in Excel 12 see David Gainer -- Charlie's list).


The following include keys not found in Excel 2000 Help but are available: Ctrl+{2,3,4,6,7,8}
A table by Key and auxiliary key(s), Chip Pearson, Excel Keyboard Shortcuts (163KB / 2 pages, produced via Front Page)
A table by key and auxiliary keys(s) (72 KB / 8 pages), Russel Proctor - Better Solutions, Microsoft Excel > Shortcut Keys,
A single page reference by category, Debra Dalgleish, Microsoft Excel Keyboard Shortcuts (1.3KB / 1 page)
Just as a point of reference the page you are looking at is 128 KB produced manually with help from XL2HTML, size as determined by the Lori Firefox extension and though not intended to be printed would be 33 pages (2006-03-18). (see Right-Click menus in Internet Explorer manual composition, and XL2HTML for tables). (formerly IE Booster was last used here to find space 2003-09-18, but IEB is no longer free, you may find additional alternatives in bookmarklets)

Excel Cheat Sheet (PDF), Deb Sklar (PDF, 23 KB, print 2 pages).  Technology Traning Resources, University of Washington, Tacoma

Euro Currency Symbol (#euro)

You can key in the Euro with Alt+0128 (on the numeric keypad).  Outside of the US there are other choices involving the AltGr key. Euro Currency Symbol, FAQ 12

Excel 2002 additions   (#new2002)          Excel 2002 additions

Excel 2002 includes keyboard shortcuts to access the border styles buttons on the Border tab of the Format Cells dialog box.  (Q277581)   Use the following keyboard commands to select the specified border styles:

    ALT+T   Top Border
    ALT+B   Bottom Border
    ALT+L   Left Border
 
    ALT+R   Right Border
    ALT+D   Diagonal and Down
    ALT+U   Diagonal and Up
 
    ALT+H   Horizontal
    ALT+V   Vertical

Q288981 XL2002: How to Use Speech Recognition to Select Cells, Rows, and Columns

Excel 2003 additions   (#foobar)

Restore normal Ctrl+A before risking your data.  Ctrl+A has always meant one thing (Select everything) in all PC applications that have any selection or editing ability.  Excel 2003 has deviated from this standard.  The following macro uses application.RecordMacro to generate the code that you would not otherwise see within a recorded macro when a macro was invoked (ability was lost in recording a macro in versions after Excel 95). ; Of course if you have macros disabled then even this macro is not going to help you with Excel 2003.  Though not shown in the shortcuts for this Ctrl+Shift+SpaceBar will also NOT select all cells like Ctrl+A in Excel 2003, though it still at least does not change the active cell – if it is a cell(s) selection that you start with.
Sub Ctrl_A()
  'Excel 2003 Ctrl+A is FUBAR·ed in Excel 2003
  '  use this shortcut to cut your loses, (D.McR 2004-06-16)
  '  BEFORE you destroy your data integrity.
  'Ctrl+A is fixed on this machine if assigned to Ctrl+A
  'You must preserve the active cell or use of Ctrl+A
  '  for normal use such a preselecting a cell before Ctrl+A, then sort
    Dim acell As Range
    Set acell = ActiveCell
    Cells.select
    Application.RecordMacro "'Comment from Ctrl_A in " _
      & ThisWorkbook.Name
    Application.RecordMacro "Cells.Select          ' Ctrl_A"
    acell.Activate
    Application.RecordMacro "Range(""" & acell.Address(0, 0) _
      & """).activate  ' Ctrl_A" 
    Beep   'if you want to indicate restored usage
End Sub
When recording a macro, these lines will be inserted in the recorded macro:
    'Comment from Ctrl_A in personal.xls if C8 was the active cell
    Cells.Select          ' Ctrl_A
    Range("C8").Activate  ' Ctrl_A
Excel 2003 has eliminated all or most of the context menu (Shift+F1).  You can no longer use Help, What's this (Shift+F1)  contexthelp  to:

Also see Excel 2003 Review, by John Walkenbach and he didn't even go into what's broke to not recommend it.  Actually he did touch on the Help system without actually saying that a lot of it didn't work anymore.

Excel 2007 (Ctrl+A gets worse)
If the worksheet contains data, CTRL+A selects the current region (Ctrl+*).
  Pressing CTRL+A a second time selects the current region and its summary rows.
  Pressing CTRL+A a third time selects the entire worksheet. 
 
The only valid bypass (non solution) is to make sure that you invoke Ctrl+A at least three times as there is no problem with hitting this shortcut more than three times.  Failure to change the way you invoke Ctrl+A will result in the ultimate destruction of a worksheet in a worksheet when you fail to change your habit(probably a very large worksheet) after sorting data, unless you can reverse (UNDO) the changes or exit without saving.  There is no visual indication that you have selected the entire worksheet, nor is it likely that you would always for such an indication if there were.

 
You can click on the "Select All" button between the row headers and the column headers, but it will change the selected cell as well.  Ctrl+A (times 3) does not change the selected cell which is an important distinction.
 
See Excel 2007 Ergonomic Hell, A not so smooth conversion to Excel 2007 from previous versions. 
 
For those of you stuck with Excel 2007, your best bet is to learn as many keyword shortcuts as you can and to make heavy use of the Context menus, which have been slightly improved but will problably see the same "improvements" as you've seen with ribbons destroying functional main menus.

OnKey to Reassign a key or shortcut (#onkey)

Deactivate a Shortcut key (#deactivate)

    ' Disable Copy keyboard shortcut
        Application.OnKey "^c", ""
    ' Reactivate  Copy  keyboard shortcut 
        Application.OnKey "^c"
Use of ONKEY to invoke a macro from a Function Key (#onkey)
Reference “OnKey Method [Excel 2003 VBA Language Reference]” http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vbaxl11/html/xlmthOnKey1_HV05203370.asp

Would not really suggest changing your basic keys, and keyboard shortcuts, but here is how you can change the HOME key not use of braces in the following (not parens).

Sub botchup_home()
    Application.OnKey "{HOME}", "Alternative_Home"
end sub
sub unbotch_home()
   application.onkey "{HOME}",  ""
end sub
Sub alternative_Home()
   range("F14").activate
end sub
For more information on Onkey and codes used see Onkey Method and Onkey Method Example in your VBA Help.

Some of my own additions -- Creating your own shortcut keys   (#mykeys)

Listed above were all of the shortcut keys for Excel.  You can also make your own short cut keys.

To create a shortcut key for a macro
   Alt+F8 (Tools, macro, macros), select the macro, options, key in shortcut key. 

You will get a warning if you attempt to change an existing shortcut.  But there could be
shortcuts in other non open workbooks.

Actually I invoke most of my own macros from menus or toolbar buttons.  Also see summary of how to invoke macros).

Enter data using shortcut keys
User added Shortcut Keys
Join, join cells together by words (see join in join doc) Ctrl+J (lowercase)
PasteSpecialvalues, Paste Special Values     Ctrl+SHIFT+V
PasteSpecialFormats, Paste Special Formats (like Format Painter) Ctrl+SHIFT+P
Reset the last cell (see lastcell doc) Ctrl+K (lowercase)
ReversI, reverse order of cells (see ReversI in join doc) [wipes out fill to right_ Ctrl+Shift+R
SepTerm, separate first word (see SepTerm in join doc) Ctrl+T (lowercase)
SepLastTerm, separate last word (see SepLastTerm) Ctrl+L (lowercase)
PreviousDay, macro with Activecell.value = now - 1 Ctrl+M (lowercase)
Available keys for own usage:  (if you've not already used them yourself)
    Ctrl+           available are: E, F, G, H, J, L through T, Y
    Ctrl+Shift+ available are: C thru F, H thru N, Q thru T, and Y
Some additional personal shortcuts that will probably prove of interest

Addins to simulate Shortcut keys for Formatting (#formatting)

Macros to simulate Shortcut keys for formatting (#macros)

Windows Shortcut – Moving a Window (#winmove)

Windows such as the Excel Window, and the workbook Window(s) within Excel can be moved around by Right clicking and dragging the window.  Sometimes the window gets moved so that the blue title bar is hardly visible or can't be dragged from top or upper corners.  To solve that
   Alt+Spacebar   for Excel Window, or
   Alt+minus         for Workbook Window   (with NumLock key OFF)
look at the menu, choose Move, then move the window around with arrow keys.

For more information refer to Excel Window, Workbook Window, Worksheet Window, Moving a Window

WINKEY shortcuts (#winkey) *winkey*

The Winkey works even if Explorer or the Shell doesn't have the focus.   

Customising Explorer and the Start Menu

 

Key Description
Winkey or Ctrl + EscOpens the Start Menu
Winkey + D Minimises or Unminimises all windows, SHIFT reverses
Winkey + EStarts Explorer
Winkey + FStarts Find Files or Folders
Winkey + Ctrl + FStarts Find Computer
Winkey + M Minimises all windows [leaves dialogs up]
Winkey + Shift + MUnminimises all windows
Winkey + RStarts the Run Dialog
Winkey + F1 Starts Windows Help (F1 start help for the current application, if the focus is in Explorer
or the desktop F1 also starts Windows Help)
Winkey + Tab Cycles through open windows with out bringing the Window to the top (press Enter)
Winkey + BreakStarts System Properties
xxx
 
Assigning your own shortcut for FIND in your own personal folder:
or see Set up a Search shortcut in your Start Menu for a search of your hard drive

AutoFit of Columns and Rows (#autofit)

You can autofit row(s), or column(s) by selecting a range of either or Select All (Ctrl+a, unless you have Excel 2003) then double-clicking on the boundary between the heading letters or numbers.  There is also a Select All button (gray/grey) located at the intersection of the row number headings and column letter headings.  More information on use of mouse.  VBA: Cells.EntireColumn.AutoFit

Calculate and recalculation   (#calc)

Tools, Options, Calculation (tab), calculation: [x] Automatic
The following is based on a Rob Bovey (7 Jan 1999) reply post on the difference between F9, CTRL+ALT+F9, and VBA 'Calculate'Note: Function key 9 items have been changed to match XL95 HELP.
Application.Calculate    calculates all open workbooks.
Range.Calculate calculates the specified range
F9Calculates all sheets in all open workbooks.
Ctrl+F9 (Minimize the worksheet)
Shift+F9Calculate the active worksheet.
Ctrl+Alt+F9Recalculates all cells on all worksheets in all open workbooks.
Ctrl+Alt+Shift+F9For Excel 2002 will rebuild all dependency trees.

The common thread running through all but Ctrl+Alt+F9 of the above is that the recalculation occurs *only* on the cells that the Excel calculation engine thinks are dirty.

Since the calculation engine occasionally gets this wrong, we also have
Ctrl+Alt+F9 which forces a recalculation of *everything* in all open workbooks whether or not Excel *thinks* recalculations are needed.

Status Bar may continue to show "Calculate", try the Ctrl+Alt+F9, make sure tools, options is on automatic calculation, you can try clearing the status bar (  Application.StatusBar = ""  ) to see if problem goes away and it may be stuck because of code which has to be recalcualted having to do with volatile coding.  Also check for MS KB articles on the statusbar link.

Volatile functions are one way to force a recalculation.  Generally it will help to avoid volatile functions, but it is available if needed.  For instance a change to a format of a cell is not detected and will not cause a recalculation in a user defined function that simply references the correct cell.  The builtin Volatile functions are not as bad: CELL(), INDIRECT(), INFO(), OFFSET(), NOW(), RAND(), TODAY() as those in a user defined function.

 ABCDE
 1  222   GetFormula It would take Ctrl+Alt+F9 to update cell A3 (or reopenig workbook, or rentry of formula)
 2 222   =$A$1  
'-- recalcated for referencec
Function volt1(cell As Range)
  volt1 = cell.Value
End Function
 
'--not automatically recalculated
Function volt2()
  volt2 = Range("a1").Value
End Function
 
Function volt3()
  Application.Volatile True
  volt3 = Range("a1").Value
End Function
 3 222   =volt1($A$1)
 4 111   =volt2()
 5 222   =volt3()
Information from Excel Help:   HELP --> ans. wiz. --> calculate
Recalculate all open cells, worksheets, and workbooks
To recalculate all cells on all worksheets in all open workbooks, press CTRL+ALT+F9

Note   Recalculation of all formulas may take considerable time.  To recalculate only the current worksheet, press SHIFT+F9

Warning:  This is one way to learn that the A1 or other cell reference in the formula =CELL("filename",A1) really is needed.  Without the cell reference, recalculate will cause the active worksheet to appear instead of the name of the worksheet where the formula resides.  Another problem with displaying the active sheet instead of the sheet with the formula would be using
    SheetName = ActiveSheet.Name instead of
    SheetName = Application.Caller.Parent.Name
Reference to article posted by John Green.

If you have XL97 and do not have SR-2, checkout   XL97 recalculation problem in the MS KB.

The following is from a posting by Tom Ogilvy (Jun 1, 1999) for code to simulate Ctrl+Alt+F9
For more information see SendKeys Statement in your VBE HELP.

Sub tester3()
Application.SendKeys "^%{F9}"
End Sub

Back when the recalc problem was so prevalent, some people mapped this
to the F9 key use
Application.onkey "{F9}","xlmisc68.xls!Tester3"
John Walkenbach then reported that in XL2000 the Ctrl+Alt+F9 gets recorded as:
    Application.CalculateFull

The following summarizes Programming use (Charles Wilson, 2000-11-10 programming)

In Excel 2000:
Application.calculate      ' f9
application.calculatefull  ' ctrl-alt-f9

in Excel 97
application.calculate      ' f9
SendKeys "%^{F9}", True    ' ctrl-alt-f9

For more information on Sendkeys see this MSDN article, "Sendkeys Method"  —  ^ for Ctrl,   % for Alt,  + for Shift,   {F8} for F8

For information on XL97 Recalculation patch for SR-1 see
  http://support.microsoft.com/default.aspx?scid=kb;en-us;Q174868
problem was corrected in XL97 SR-2.

Q224183 - XL2000: Certain Functions Calculate Differently in Early Versions of Excel
  http://support.microsoft.com/default.aspx?scid=kb;en-us;Q224183
Summary: When you use certain functions, you may receive a different value depending on the version of Microsoft Excel that you are using.

CalculateFull Method Example
  http://msdn.microsoft.com/library/officedev/off2000/xlmthcalculatefullx.htm
Summary: MSDN Library - Office Developer Documentation - Office 2000. Excerpt: CalculateFull Method Example This example compares the version of Microsoft Excel with the version of Excel that the workbook was last calculated in.

Auto_Open set to guarantee Calculation is turned on (#autocalc)

I had trouble with Recalculation being turned off that I put code into Auto_Open to fix it.  Turned out that it was an Addin that I wasn't even using that was causing this.


    Sub auto_open()
      If Application.Calculation <> -4105 Then
         '-4105 automatic, -4135 manual, 2 semi-automatic
         MsgBox Application.Calculation & " <calculation in> " & _
            ActiveWorkbook.FullName
         Application.Calculation = xlAutomatic
         MsgBox Application.Calculation
      End IF
    End Sub

Special Characters   (#specialcharacters)

HTML
name
Description  MS illegal
(128-159)
 &euro; Euro Symbol €  &#128;
 &hellip; ellipsis (horiz.) …  &#133
 &dagger; dagger † &#134;
 &Dagger; double dagger ‡  &#135;
 &rsquo; apostrophe ’  &#146;
 &ldquo; open double quote “  &#147;
 &rdquo; close double quote ”  &#148;
 &lsquo; open single quote ‘  &#145;
 &rsquo; close single quote ’  &#146;
 &bull; bullet • &#149;
 &mdash; em-dash — &#151;
 &ndash; en-dash – &#150;
 &tilde; tilde ˜ &#152;
 &trade; Trademark (tm)  ™  &#153;
 &cent; Cent Sign ¢ &#162;
 &pound; Pound Sterling                £  &#163;
 &yen; Yen Symbol                      ¥  &#165;
 &copy; Copyright  (c)            ©  &#169;
 &reg; Registered (r)  ®  &#174;
 &deg; Degree               °  &#176;
 &plusmn; Plus/Minus          ±  &#177;
 &para; Pilcrow ¶ &#182;

ALT keystroke sequences, ALT+nnnn, for Special Characters   via Operating System (#altnnnn)

In order to type a character that is not on your keyboard you can use the CharMap in Windows, Excel excapes, or ALT keystroke sequences.  For example, in order to enter a Copyright sysmbol you have some choices in Excel. When typing the decimal digits you must use the numeric keypad. 

Laptops may not have a full complement of keys (#laptops)

No key to left of 1-2-3 to toggle Formula view (Ctrl+`), solution use a macro and assign shortcut key -- or use Tools, Options, View Tab, Format (Alt+[T,O], view tab, Alt+R)
Sub Toggle_DisplayFormulas()
    ActiveWindow.DisplayFormulas = Int(ActiveWindow.DisplayFormulas + 1)
End Sub

Keying in a Non-breaking space CHAR(160) (#nbsp)

To manually Replace a  Char(160)  value which is known as a non-breaking space (&nbsp;) in HTML or a required blank (RBL) in rich text formatted documents use one of the following:
 
on a desktop Ctrl+H then
Find what -- hold the Alt and key in 0160 with Alt+0160 on the numeric keypad (Not the number row)
Replace with -- leave the to field empty and use Replace All
on a laptop Ctrl+H then
Find what -- hold the Alt and key in 0160 with Fn+0160 on the numeric keypad
Replace with -- leave the to field empty and use Replace All

Right-Click (Context) or Pop-Up Menu to Paste Formulas   (#rclick)

Chip Pearson uses a Right-Click menu to copy the formula of a single cell and to paste the formula unchanged to another cell.  Requires coding in your Auto_Open macro.
  http://google.com/groups?threadm=uNR1fmHt%24GA.287%40cppssbbsa05

Right-Click context menu areas in Excel: 

   title bar, menu bar, column headers, row headers, worksheet, worksheet tabs, scroll bars, status bar, navigation arrows,

Some shortcut cursor techniques, evidently not considered shortcuts (#cursor)

Fill Handle   (#fillhand)

fillhand The fill-handle is one of the most powerful tools in Excel, and normally alleviates the need to type in formulas similar to the previous lines.  Used to replicate content (values, formulas, formatting, color), copy cells, fill in a series (Mon, Tue, ...; 1, 2, 3, ...).

Moving a group of rows or columns to another location (#move)

On the worksheet you can, select the row(s) to be moved then Hold the SHIFT key and grab the upper or lower boundary with the left mouse key and drag to between the rows you want to move it to.  Similar for columns instead.  (for more information see mouse topic on my Fill Handle page.)

I guess this is not considered a shortcut, and theses tips are not easily shown in the above table.  You will find it in Excel HELP (F1) --> index --> move --> move or copy cells

Sheet Tab navigation arrows (#sheettabs)

Read about More sheets by right-click on navigation arrows.

Hold shift key down and click on sheet navigation arrows and you go to next set of worksheet tabs not currently visible.

Important Excel 2000 keys picked by MSDN (Microsoft Developer Network) (#msdnchoice)

 

   B C
18 Excel 2000 Shortcut keys in --       http://office.microsoft.com/downloads/2000/O2kkeys.aspx
19 Activity Shortcut Keys
20  Alternate between displaying cell values and displaying cell formulas  CTRL+` (single left quotation mark)
21  Calculate all sheets in all open workbooks F9
22 Calculate the active worksheet  SHIFT+F9
23 Copy CTRL+C  ccc
24  Create a chart that uses the current range F11 or ALT+F1
25 Display the Format Cells dialog box  CTRL+1
26 Display the Go To dialog box  F5
27  Fill the selected cell range with the current entry CTRL+ENTER
28 Insert the current time CTRL+:
29 Insert today's date CTRL+;
30 Move to the beginning of the worksheet  CTRL+HOME
31  Move to the last cell on the worksheet, which is the cell at the intersection of the  rightmost used column and the bottommost used row (in the lower-right corner), or  the cell  opposite the home cell, which is typically A1  CTRL+END
32 Open CTRL+O
33 Paste    CTRL+V
34 Paste a function into a formula  SHIFT+F3
35 Print CTRL+P
36 Save CTRL+S
37  Select all (when you are not entering or editing a formula)  CTRL+A (unless you have Excel 2003
38 Select the current column  CTRL+SPACEBAR
39 Select the current row  SHIFT+SPACEBAR
xx Select all cells leaving active cell still the active cell.  (broken by design in Excel 2003 where it works same as broken Alt+A in Excel 2003)   CTRL+SHIFT+SPACEBAR
40 Undo  CTRL+Z
41  When you enter a formula, display the Formula Palette after you type a  function  name  CTRL+A

Some Interesting Web Searches

Was looking for list of described icons to go with the tables here.  Did not find what I was looking for and all the icons would probably really affect your time in seeing this page but did turn up a lot of interesting links with the following Google Web Search:

Error Messages in Windows (#ErrMsgs)

Reporting an Error message as plain text can be tedious.  If you have software that grabs a screen shot and converts to text (SnagIT) you can save time.  There is a shortcut key combination that sometimes works to copy the text from an error message -- Ctrl+Alt+C.  An alternative for dialog messages that don't come from Windows if you don't have SnagIT can be found in How To Copy Text or Error Messages from Any Dialog Boxes in Windows » Raymond.CC Blog, which lists several applications that can grab a dialog message.

Using the HELP files with your Excel Software (#help)

See General Information on Getting HELP within Excel software, in other words using your HELP file.

HELP files at Microsoft in HTML universally available (#MS_Help)

Help reference to Office products (including Excel) can be found online, and match the help files in your products, with the advantages of HTML use of Find and hopefully Search that should become better than the Answer Wizard in Help.

It can be a bit confusing that MS maintains the same information in various web pages and is continually changing the names of those web pages, so I will include some of the multiple places, specifically note some begin with www, some with office, and some with support.

True to form it has been two weeks, so NONE of the following links work.
 
  http://www.microsoft.com/office/techinfo/productdoc/default.htm
  http://support.microsoft.com/support/Office/InProdHlp/contents/Excel/tocxldefault.asp

Excel 2000Excel 2002

These are currently (for the rest of this month - Jun 30, 2002) good links:

http://www.microsoft.com/office/techinfo/productdoc/2000/en/excel/
http://www.microsoft.com/office/excel/using/default.asp
http://office.microsoft.com/assistance/offhelp/off2000/excel/
http://office.microsoft.com/assistance/offhelp/off2000/excel/xlmain9/html/xlread9.htm

http://www.microsoft.com/office/techinfo/productdoc/2002/en/excel/
http://www.microsoft.com/office/excel/using/default.asp
http://office.microsoft.com/assistance/offhelp/offxp/excel/
http://office.microsoft.com/assistance/offhelp/offxp/excel/xlmain10/html/xlstart.htm

compare offxp/excel/xlmain10   to   off2000/excel/xlmain9

Once you get the specific HELP file you want you should notice some buttons from left to right.  TOC only, TOC and topics, Topic only; Specific URL (for bookmarking); Show all[/hide all] topics.

Excel HELP information at Microsoft (#selfdestruct)

Since everything on the Microsoft site gets trampled on very frequently you may have better luck using a search where offered for: Excel 2000 specifications

Excel 2000 Shortcut keys: 
    http://www.microsoft.com/office/techinfo/productdoc/2000/en/excel/xlrefUsingshortcutkeys.htm [former link]
    http://office.microsoft.com/assistance/offhelp/off2000/excel/ -- as seen on 2002-02-10
Excel 2001 Shortcut keys:Shortcut key information for Macintosh is rather limited on the web
   XL2001: Shortcut Keys Available in Excel 2001 for Mac (Part 1)
   http://support.microsoft.com/kb/275633/EN-US/ -- as seen on 2006-09-28
Excel 2002 Shortcut keys:  http://office.microsoft.com/assistance/offhelp/offxp/excel/default.asp?URL=/assistance/offhelp/offxp/excel/xlmain10/html/xlrefUsingshortcutkeys.htm
-- valid 2002-02-10 but script is broken they just can't get web pages to work properly
Excel 2003 Shortcut keys:  (not complete) Microsoft Office Assistance: Excel shortcut and function keys
http://office.microsoft.com/assistance/preview.aspx?AssetID=HP011116591033&CTT=4&Origin=CH062527951033
 
Excel 2000 Specification:  [What's New] http://www.microsoft.com/office/techinfo/productdoc/2000/en/excel/xldecMicrosoftExcelSpecifications.htm
Excel 2002 Specification:  [What's New]
  http://www.microsoft.com/office/techinfo/productdoc/2002/en/excel/xlrefChartingSpecifications.htm
 
  Microsoft Office 97/Visual Basic Programmer's Guide
 

Product Documentation, Get the Help files for Microsoft Office programs— online. Word, Excel, Outlook, PowerPoint, Access, FrontPage, Publisher, MapPoint.


Hidden Menu Items exposed with SHIFT key (#hidden)

Shift Key menus

Also see these pages:  toolbars, rightclick, logoshd

Accessibility / Disability / Impaired Sight / Keyboard Access (#accessibility)

Working with disabilities / accessibility options:  Some documentation found in the Microsoft Knowledge DataBase (MS KB) for Windows 2000 looking for disabilities & mouse turns up some items of interest.

Information from Microsoft

Additional corporate sites on disability and workplace environment

Additional accessibility webpages/websites

Text to Speech

General Resources

Presentations involving Excel worksheets -- location bar hard to see in back of room.


Excel to HTML conversions, the XL2HTML macros generate a smaller file and let HTML do it's own thing rather than simulate Excel.

Toolbar menus.  One way to learn most of the important features in Excel or any other software is to become familiar with each of the items in the menus.  Microsoft Excel 97 Menus « provides a description of each menu item

Caps Lock, 2004-09-20, akyhne, uses GetKeyboardState keys(0)

disable keyboard keys, the most effective way to to disable the "Caps Lock" is to pry it off and throw it away or misplace it.  To disable other keys see posting 2004-12-20 by Jim Thomlinson.  i.e. Application.OnKey "^{c}", ""

Caps Lock on a laptop:  For a laptop you probably don't want to remove a key, but you want a system wide method of avoiding the problem -- Windows Control Panel, accessibility, ToggleKeys option will provide sound when invoking/revoking Caps Lock, Scroll Lock, or NumLock keys. (in Windows Vista, ToggleKeys is set in Control Panel, Ease of Use, Eases of Access Center, Keyboard).

XL97: How to Disable Shortcut Menus (#kb161440), also see Visual Basic Example to Disable All Shortcut Menus (#kb131257)

Move a Column or Row techniques can be found on the Fill Handle page under topic: Use of Mouse and keys to move, and insert rows or columns.  Another technique is to double-click the fill handle to copy the formula or sequence down as far as the column to the left is filled with adjacent data/formula.

Navigating within a Sheet Click to Save as Adobe Acrobat (.PDF) using
Adobe® Distiller, using this button, if available in your application; otherwise, using printer if you have the Distiller  Keyboard Shortcuts for Windows -- portions of the "Adobe® Acrobat® 4.0 Tips for Business Professionals" for use with MS products (displayed in HTML format).  Warning: just like MS site, if a page displays 404 "Not Found" or "The page cannot be displayed" -- try Refresh once more. <Insert 24x24 bit B&W picture of a skunk here alt="HTML compatibility of site stinks">

Keyboard Layouts, Keyboard Maps select a country (Canada, Canada, UK, US), turn off popup stoppers and use the shift key on the layout to see those requiring a Shift key.

Keyboard Problems (#hardware),
Try a different keyboard.  Laptops have a PS/2 connention for auxiliary keyboard.
Pop off key cover, remove hair and crud, then vacuum entire keyboard before replacing any cover(s) removed.  Place cover carefully into position and gently press down til it pops in.  [also see Replacing Laptop Keys (and keyboards), and manufacturer's own site]
Cleaning Laptop Keyboard, be careful with liquids and use only in well ventilated area, if the dry spray is Teflon make sure it does not burn. 
Also do a search including your own brand name of laptop and the following search arguments:  remove +laptop +keyboard fix* OR repair*  [additional optional words:  clean* pop* ] Wison Mar, layouts of shortcuts, and other related tips and accessibility information.

Software Problems with Keyboard shortcuts (#problems)

Function Key(s) does not work in Excel 2003, check out this entire thread involving macros, safe mode, addins, trusted publisher.

Specific code for personal function keys and keyboard shortcuts can be found earlier on this page [onkey, foobar].

How to install/use a macro can be found on my Getting Started with Macros page.

How to install toolbar buttons can be found on throughout my Toolbars, Custom Buttons and Menus page.

Worksheet Function names, where to find lists of and examples of usage.

Utilities related to Shortcut Keys and Toolbars (#utilities)

Desktop Shortcuts (#desktop)

Problem invoking Excel from a desktop shortcut.  Solution: Got to tools -> options -> general -> uncheck "ignore other applications".

Create a shortcut to a specific file to the desktop, start bar, or quick launch, drag the file with the right mouse button from the directory (in Explorer) to the desktop, and chose "create shortcut here". Explorer to the desktop. 

To use VBA to place a shortcut to a specific file to the desktop, see posting Re: Short cuts? (Bob Phillips, 2005-03-31, misc).  Actually Tom Ogilvy posted links to several programming methods ( 2000-12-10, programming).  Typical of Microsoft the lnks to the MSKB pages no longer work and the articles are missing as well, but there are still the links to 3 newsgroup posts.

Create a desktop shortcut to Excel itself, find Excel in Windows Start and drag to the Desktop (should see the shortcut arrow on the shortcut).

-Or- find "Microsoft Excel" in the Windows Start, Programs then drag with right mouse button to desktop, then choose "Create Shortcut(s) Here".

Keyboard things, other than shortcuts (#keys)

Additional Shortcut Information « (#more)

Summary of Shortcut key webpages to be worked into the area below.

Other Excel shortcut pages:
   Offsite:  VBA Shortcut Keys (builtin) for Excel «, on Chip Pearson's site (38.7 KB, 3 pages).  Assigning Shortcut keys in VBA programmatically rough posting See Previous topic:  MS_Help">HELP files at Microsoft in HTML universally available
Keyboard Shortcuts & Accessiblity,
Also see Keyboard Shortcuts in
   http://office.microsoft.com/assistance/2000/TipsExcel.aspx
A downloadable Excel workbook with Shortcut keys for Excel and other office products can be downloaded from (think of a folder to store in, i.e. h:\exceldocs ).  I think it leaves a lot to be desired, you can make your own judgment, I included the Excel 2000 portion in the topic above.
   http://office.microsoft.com/downloads/2000/O2kkeys.aspx

Excel Shortcuts a summary as seen in Excel 2002 HELP.
   Onsite:   Mouse Operations in Excel:  Use of Mouse and keys to move, and insert rows or columns Mouse (#mouse)
   Onsite:   OE
   Onsite:   IE RClick Menu Additions for IE
   Offsite:  Explorer (have to expand them)
   Offsite:  Keyboard Shortcuts [alt], some general shortcuts, most are global working in several applications, or systems.
  Keyboard Shortcuts, in Microsoft Products (microsoft.com)

Other Excel shortcut pages:
Shortcuts, clicks, in Excel and other applications:  Right-click:  Excel, IEShort Cuts (keyboard shortcuts):  Excel (this page); IE, OE, Win2000ToolbarsExcelDrag/Fillhandle: Excel Fill Handle, Windows drag files;   Accessibility Options: MouseKeys; Event Macros: Excel

For most Office applications to show keyboard shortcuts:
   Help --> Index --> Keyboard
and to show accessibility options (also see accessibility mentioned in previous topic)
   Help --> Index --> accessibility
Comprehensive list of keyboard shortcuts for Microsoft Products see « Keyboard Assistance « [up through OFFICE XP (2000)]
     includes links to products and versions including:  Excel 2000 (109 KB / 19 pages) ,  Excel 2002 (133 KB / 23 pages) [size on MS pages does not include images, due to scripting errors].  Excel 2003 ( 51 KB / 5 pages: ctrl & F keys only) The intrusive sidebar (loss of real estate) includes valuable links "Guide by Disability", "Step by Step Tutorials".  For more Windows and MS applications Shortcuts, A.R.Miller ( 8.2 KB / 2 pages, * see his other pages).

Desktop and Start Menu Shortcuts, Ctrl+Alt+(letter), created by right-click on desktop icon, Properties, Assign Shortcut -- i.e. Mozilla (Ctrl+Alt+M), IrfanView(Ctrl+ALT+I), and you already have Lockup while away from desk (Ctrl+Alt+Del, Enter)
and you have Winkey+(letter) for a quick launch, also see Winkey Shortcuts (above).


This page was introduced on September 08, 2000. 
[My Excel Pages -- home]    [INDEX to my site and the off-site pages I reference] 
[Site Search -- Excel]     [Go Back]    [Return to TOP

Please send your comments concerning this web page to: David McRitchie send email comments


Copyright © 1997 - 2009,  F. David McRitchie,  All Rights Reserved