Keyborad Shortcuts For MS Excel

General

F2 Key Edit current Cell

F5 Key Goto

F7 Key Spell Check

F12 Key Save file as

CTRL+A Select entire worksheet.

CTRL+B Toggle Bold Text.

CTRL+C Copies the item or items selected to the Clipboard.

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

Formulas

ALT+ = Autosum

ALT+ F8 Macros

CTRL+ ; Insert Current Date

CTRL+ : Insert Current Time

Movement

Left Arrow One Cell Left (also SHIFT+TAB)

Right Arrow One Cell Right (also TAB)

Up Arrow One Cell Up

Down Arrow One Cell Down

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

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