Excel Shortcut keys August 11th, 2005

Vinod Kumar
ENTER Complete a cell entry and move down in the selection
ALT+ENTER Start a new line in the same cell
CTRL+ENTER Fill the selected cell range with the current entry
SHIFT+ENTER Complete a cell entry and move up in the selection
TAB Complete a cell entry and move to the right in the selection
SHIFT+TAB Complete a cell entry and move to the left in the selection
ESC Cancel a cell entry
BACKSPACE Delete the character to the left of the insertion point, or delete the selection
DELETE Delete the character to the right of the insertion point, or delete the selection
CTRL+DELETE Delete text to the end of the line
Arrow keys Move one character up, down, left, or right
HOME Move to the beginning of the line
F4 or CTRL+Y Repeat the last action
SHIFT+F2 Edit a cell comment
CTRL+SHIFT+F3 Create names from row and column labels
CTRL+D Fill down
CTRL+R Fill to the right
BACKSPACE Edit the active cell and then clear it, or delete the preceding character in the active cell as you edit cell contents
ENTER Complete a cell entry
CTRL+SHIFT+ENTER Enter a formula as an array formula
ESC Cancel an entry in the cell or formula bar
CTRL+A Display the Formula Palette after you type a function name in a formula
CTRL+SHIFT+A Insert the argument names and parentheses for a function after you type a function name in a formula
CTRL+K Insert a hyperlink
ENTER (in a cell with a hyperlink) Activate a hyperlink
F2 Edit the active cell and position the insertion point at the end of the line
F3 Paste a defined name into a formula
SHIFT+F3 Paste a function into a formula
F9 Calculate all sheets in all open workbooks
CTRL+ALT+F9 Calculate all sheets in the active workbook
SHIFT+F9 Calculate the active worksheet
#NAME? Start a formula
ALT+= (equal sign) Insert the AutoSum formula
CTRL+; (semicolon) Enter the date
CTRL+SHIFT+: (colon) Enter the time
CTRL+SHIFT+” (quotation mark) Copy the value from the cell above the active cell into the cell or the formula bar
CTRL+` (single left quotation mark) Alternate between displaying cell values and displaying cell formulas
CTRL+’ (apostrophe) Copy a formula from the cell above the active cell into the cell or the formula bar
ALT+DOWN ARROW Display the AutoComplete list
ALT+’ (apostrophe) Display the Style dialog box
CTRL+1 Display the Format Cells dialog box
CTRL+SHIFT+~ 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+B Apply or remove bold formatting
CTRL+I Apply or remove italic formatting
CTRL+U Apply or remove an underline
CTRL+5 Apply or remove strikethrough formatting
CTRL+9 Hide rows
CTRL+SHIFT+( (opening parenthesis)  
  Unhide rows
CTRL+0 (zero) Hide columns
CTRL+SHIFT+) (closing parenthesis)  
  Unhide columns
F10 or ALT Make the menu bar active, or close a visible menu and submenu at the same time
TAB or SHIFT+TAB (when a toolbar is active)  
  Select the next or previous button or menu on the toolbar
CTRL+TAB or CTRL+SHIFT+TAB (when a toolbar is active)  
  Select the next or previous toolbar
ENTER  
SHIFT+F10 Show a shortcut menu
ALT+SPACEBAR Show the program icon menu (on the program title bar)

These are some interesting shortcuts you will enjoy knowing with Excel 2007 :) …

Tags:

This entry was posted on Thursday, August 11th, 2005 at 15:15 and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply