Useful Shortcut Keys for MS Excel

Below is a list of some of the useful shortcut keys for MS Excel for increased productivity by saving time. MS Excel is such a great application and lot of us who is more involved in financial and project management job tends to use MS Excel a lot. So, this list of shortcut keys for MS Excel will be very useful for any type of Excel users.

HELP:
F1 Key :-  Need Help in Excel, press F1 Key

EDITING:
F2 Key :- Press F2 to edit the current cell
Ctrl + B :- To toggle bold text
Ctrl + C :- To  copy the selected items
Ctrl + X :- To cut the selected item
Ctrl + V :-  To paste the items from clipboard
Ctrl + U :- To toggle underlined Text
Ctrl + Y :- Redo the last undone action
Ctrl + Z :-  Undoes the last action
F12 Key :- To open file "Save As" dialog
Ctrl + A :- To select entire worksheet
F7 Key :- Press F7 Key to start spell check
Ctrl + F :- To display Find dialog box
Ctrl + H :- To display the Replace dialog box.
Ctrl + I :- To toggle italic Text
CTRL + S :- To save file
CTRL + 1 :- To displays Format Cells Dialogue Box
CTRL + 5 :- Toggles Strikethrough Text
Ctrl + Left Arrow :- To go to end of column
Ctrl + Home :- To go to top of Worksheet (A1)
Ctrl + End :-  To to the end of Worksheet
Ctrl + Pg Dn :-  To go to the next Worksheet

MISC:
F5 Key :- Goto
Ctrl + N :- To open New file
Ctrl + O :- To open existing file
Ctrl + P :- To print

FOR FORMULAS:
Alt + = :- Adds Autosum in the current cell
Alt + F8 :- To open macros dialog

DATE & TIME:
CTRL + ; :- To insert current date
CTRL + : :- To insert current time

CELL SELECTION:
Home Key :-  To go to start of the row
Ctrl + Spacebar :- To select the entire Column
Shift + Spacebar :-  To select the entire Row
Ctrl + A :- To select entire Worksheet
Shift + Left Cursor :- To select all cells to the left of the active one
Shift + Right Cursor :- To select all cells to the right of the active one

Comments

Popular posts from this blog

Linux System Accounting and Logging Basics

How to Make Money Online - A Beginner's Guide

Hide Files and Folders in Windows using attrib DOS Command