Pls page down to see the table
Keyboard Shortcuts |
Result in Excel - General |
F1 Key |
Help |
F2 Key |
Edit current Cell |
F5 Key |
Go to |
F7 Key |
Spell Check |
F12 Key |
Save file as |
CTRL and A |
Select entire worksheet |
CTRL and B |
Bold Text |
CTRL and C |
Copy |
CTRL and F |
Displays the Find dialog box. |
CTRL and H |
Displays the Replace dialog box |
CTRL and I |
Italic Text |
CTRL and N |
New File |
CTRL and O |
Open File |
CTRL and P |
Print |
CTRL and S |
Save File |
CTRL and U |
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 |
Undo the last action |
CTRL and 1 |
Displays Format Cells Dialogue Box |
CTRL and 5 |
Strikethrough Text |
Keyboard Shortcuts |
Result in Excel - Formula |
ALT and = |
Autosum |
ALT and F8 |
Macros |
CTRL and ; |
Insert Current Date |
CTRL and : |
Insert Current Time |
Keyboard Shortcuts |
Result in Excel - 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 |
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 - 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 |
