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

Share