MS Excel Shortcuts

Shortcuts	Description
F2	edit the selected cell
F5	go to specified sale 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 + I	italic highlighted selection
Ctrl + k	insert link
Ctrl + u	underline the selection
Ctrl + 5 Ctrl + Z	strikethrough highlighted selection Undo Changes
Ctrl +F9	minimise the current window
Ctrl + F10	maximize currently selected Windows
Ctrl + F6	switch between open workbooks / Windows
Ctrl + page up	move between excel worksheet s in the same Excel document
Ctrl + page down	between shit 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 the cell currently selected
Ctrl + shift +!	format number in comma format
Ctrl + shift +$ Ctrl + shift + # -	format number in currency format 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

150 CMD TRICKS