F2 Edit the selected cell.
F5 Go to a specific cell. For example, C6.
F7 Spell check selected text 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.
F5 Go to a specific cell. For example, C6.
F7 Spell check selected text 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.
No comments:
Post a Comment