MICROSOFT EXCEL SHORTCUT KEYS

MICROSOFT EXCEL SHORTCUT KEYS

•  F2 Edit the selected cell
•  F3 After a name has been created F3 will paste names
•  F5 Go to a specific cell. For example, C6
•  F7 Spell check selected text or document
•  F11 Create chart from selected data
•  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 section
•  Ctrl + I Italic highlighted section
•  Ctrl + K Insert link
•  Ctrl + U Underline highlighted section
•  Ctrl + 1 Change the format of selected cells
•  Ctrl + 5 Strike through highlighted section
•  Ctrl + P Bring up the print dialogue box to begin printing
•  Ctrl + Z Undo last action
•  Ctrl + F3 Open Excel Name Manager
•  Ctrl + F9 Minimize current window
• Ctrl + F10 Maximize currently selected window
•  Ctrl + F6 Switch between open work books or windows
•  Ctrl + Page up Move between Excel work sheets in the same Excel document
•  Ctrl + page down Move between Excel worksheets in the same Excel document
•  Ctrl + Tab Move between two or more open Excel document
•  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 the next selection on text
•  Ctrl + Space Select entire column
•  Shift + Space Select entire row
•  Ctrl + - Delete the selected column or row
•  Ctrl + shift + = Insert a new column or row
•  Ctrl + Home Move to cell A1
•  Ctrl + ~ Switch between showing Excel formulas or their values in cells..!!