below are the top excel shortcut keys for everyone. you can use these shortcut keys in your daily work.
Keyboard Shortcut | Result in Excel 2000 – General |
| F1 Key | Help |
| F2 Key | Edit current Cell |
| F5 Key | Goto |
| F7 Key | Spell Check |
| F12 Key | Save file as |
| CTRL and A | Select the entire worksheet. |
| CTRL and B | Toggle Bold Text. |
| CTRL and C | Copies the item or items selected to the Clipboard and can be pasted using CTRL and V. |
| CTRL and F | Displays the Find dialog box. |
| CTRL and H | Displays the Replace dialog box. |
| CTRL and I | Toggles Italic Text. |
| CTRL and N | New File. |
| CTRL and O | Open File. |
| CTRL and P | Print. |
| CTRL and S | Save File. |
| CTRL and U | Toggles Underlined Text. |
| CTRL and V | Paste the contents of the clipboard. |
| CTRL and X | Cut the selected item. |
| CTRL and Y | Redo the last undone action |
| CTRL and Z | Undoes the last action. |
| CTRL and 1 | Displays Format Cells Dialogue Box |
| CTRL and 5 | Toggles Strikethrough Text |
Keyboard Shortcut | Result in Excel 2000 – Formulas |
| ALT and = | Autosum |
| ALT and F8 | Macros |
| CTRL and ; | Insert Current Date |
| CTRL and : | 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 and left Arrow | Go to End of Column |
| CTRL and Home | Go to Top of Worksheet (A1) |
| CTRL and End | Go to End of Worksheet |
| CTRL and PAGE-DOWN | Go to Next Worksheet |
Keyboard Shortcut | Result in Excel 2000 – Cell Selection |
| CTRL and Spacebar | Select the Entire Column |
| SHIFT and Spacebar | Select the Entire Row |
| CTRL and A | Select Entire Worksheet |
| SHIFT and Left Cursor | Select all cells to the left of the active one |
| SHIFT and Right Cursor | Select all cells to the right of the active one |
Post a Comment (0)