Here are some of the shortcut keys which are useful while working with Microsoft Excel.
- F1 Key Help
- F2 Key Edit current Cell
- F5 Key Goto
- F7 Key Spell Check
- F12 Key Save file as
- CTRL and A Select 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 Shortcuts Result in Excel 2000 – Formulas
- ALT and = Autosum
- ALT and F8 Macros
- CTRL and ; Insert Current Date
- CTRL and : Insert Current Time
Keyboard Shortcuts 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 Shortcuts 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
Nice Shortcut Keys every body must try it