| 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 :) ...