Microsoft Excel Shortcut Keys

  

Here is a list of most useful and common shortcuts used in microsoft excel.

These shortcut or hotkeys will help you to work in excel at lightning speed .

Shortcut Key	Functions
F2	Edit the selected cell
F5	Goto a specific cell. For example, C6.
F7	Spell check selected text and/or document
F11	Create chart
Ctrl + Shift + ;	Enter the current time
Ctrl + ;	Enter the current date
Alt + Shift + F1	Insert New Worksheet
Shift + F3	Open the Excel formula window
Shift + F5	Bring up search box
Ctrl + A	Select all contents of the worksheet
Ctrl + B	Bold highlighted selection
Ctrl + I	Italic highlighted selection
Ctrl + K	Insert link
Ctrl + U	Underline highlighted selection
Ctrl + 5	Strikethrough highlighted selection
Ctrl + P	Bring up the print dialog box to begin printing
Ctrl + Z	Undo last action
Ctrl + F9	Minimize current window
Ctrl + F10	Maximize currently selected window
Ctrl + F6	Switch between open workbooks / windows
Ctrl + Page up	Move between Excel work sheets in the same Excel document
Ctrl + Page down	Move between Excel work sheets in the same Excel document
Ctrl + Tab	Move between Two or more open Excel files
Alt + =	Create a formula to sum all of the above cells
Ctrl + ‘	Insert the value of the above cell into cell currently selected
Ctrl + Shift + !	Format number in comma format
Ctrl + Shift + $	Format number in currency format
Ctrl + Shift + #	Format number in date format
Ctrl + Shift + %	Format number in percentage format
Ctrl + Shift + ^	Format number in scientific format
Ctrl + Shift + @	Format number in time format
Ctrl + Arrow key	Move to next section of text
Ctrl + Space	Select entire column
Shift + Space	Select entire row

Posted in: Key Board Shortcut Keys