Excel Keyboard Shortcut Keys

[Kalyan]

Excel Keyboard Shortcut Keys

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

ALT and =    Autosum
ALT and F8    Macros
CTRL and ;    Insert Current Date
CTRL and :    Insert Current Time

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

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