Posted by cls On June - 10 - 2009
 |
Keyboard Shortcuts are very useful tool for fast working with programmes. This is a list of Microsoft Excel keyboard shortcuts. Use and remember them while working and you will feel and love MS Excel to work with. |
Keyboard Shortcut
|
Result in Excel 2000 – General
|
| F1
|
Help |
| F2
|
Edit current Cell |
| F5
|
Goto |
| F7
|
Spell Check |
| F12
|
Save file as |
| CTRL+A |
Select entire worksheet. |
| CTRL+B |
Toggle Bold Text. |
| CTRL+C |
Copies the item or items selected to the Clipboard and can be pasted using CTRL and V. |
| CTRL+F |
Displays the Find dialog box. |
| CTRL+H |
Displays the Replace dialog box. |
| CTRL+I |
Toggles Italic Text. |
| CTRL+N |
New File. |
| CTRL+O |
Open File. |
| CTRL+P |
Print. |
| CTRL+S |
Save File. |
| CTRL+U |
Toggles Underlined Text. |
| CTRL+V |
Paste the contents of the clipboard. |
| CTRL+X |
Cut the selected item. |
| CTRL+Y |
Redo the last undone action |
| CTRL+Z |
Undoes the last action. |
| CTRL+1 |
Displays Format Cells Dialogue Box |
| CTRL+5 |
Toggles Strikethrough Text |
Keyboard Shortcut
|
Result in Excel 2000 – Formulas
|
| ALT+= |
Autosum |
| ALT+F8 |
Macros |
| CTRL+; |
Insert Current Date |
| CTRL+: |
Insert Current Time |
Keyboard Shortcut
|
Result in Excel 2000 – Movement
|
| Left Arrow |
One Cell Left (also SHIFT and TAB) |
| Right Arrow |
One Cell Right (also TAB) |
| Up Arrow |
One Cell Up |
| Down Arrow |
One Cell Down |
| Home |
Go to End of row |
| CTRL+left Arrow |
Go to End of Column |
| CTRL+Home |
Go to Top of Worksheet (A1) |
| CTRL+End |
Go to End of Worksheet |
| CTRL+Page Down
|
Go to Next Worksheet |
Keyboard Shortcut
|
Result in Excel 2000 – Cell Selection
|
| CTRL+Spacebar |
Select the entire Column |
| SHIFT+Spacebar |
Select the entire Row |
| CTRL+A |
Select Entire Worksheet |
| SHIFT+Left Cursor |
Select all cells to the left of the active one |
| SHIFT+Right Cursor |
Select all cells to the right of the active one |
Popularity: 4% [?]
