Excel Shortcuts

Basics

• Control-C = Copy • Control-F = Find text

• Control-V = Paste • Control-B = Bold text

• Control-X = Cut • Control-I = Italic

Nagivating

• Control-Page down = Jump to the next worksheet

• Control - Down arrow = move to the last row in the dataset

• Control-Home = Navigates to cell A1

• Control-End = Navigates to the last cell that contains data

• Alt Tab = Navigate through open items without using a mouse

And more...

· Alt-&-= : Autosums the cells above the current cell


· Shift-F11 : Creates a new blank worksheet


· F2 : Opens the cell for editing in the formula bar


· Control-~ : Displays formulas