Excal shortcuts and functions


F2 Edit the selected cell
F5 Go to a specific cell
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 + K  Insert link
Ctrl + F  Open find and replace options
Ctrl + G  Open go-to options
Ctrl + H  Open find and replace options
Ctrl + U  Underline highlighted selection
Ctrl + Y  Underline selected text
Ctrl +5 Strikethrough highlighted selection
Ctrl + O Open options
Ctrl + N  Open new document
Ctrl + P  Open print dialog box
Ctrl + S  Save
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 & Page Down
Move between Excel worksheets in the same document
Ctrl + Tab Move between two or more open Excel files
Alt + = Create formula to sum all of above cells
Ctrl + '   Insert value of above cell into current cell
Ctrl + [  Decrease selected font -1
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 + ?  Move to next section of text
Ctrl + Space Select entire column
Shift + Space Select entire row
Ctrl + W  Close document