Key Description
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
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 + U Underline highlighted selection
Ctrl + P Bring up the print dialog box to begin printing
Ctrl + Z Undo last action
Ctrl + F9 Minimise current workbook
Ctrl + F10 Maximise currently selected workbook
Ctrl + F6 Switch between open workbooks / window
Ctrl + page up Move between Excel worksheet 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 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 + Arrow key Move to next section to text
Ctrl + Space Select entire column
Shift + Space Select entire row
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
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 + U Underline highlighted selection
Ctrl + P Bring up the print dialog box to begin printing
Ctrl + Z Undo last action
Ctrl + F9 Minimise current workbook
Ctrl + F10 Maximise currently selected workbook
Ctrl + F6 Switch between open workbooks / window
Ctrl + page up Move between Excel worksheet 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 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 + Arrow key Move to next section to text
Ctrl + Space Select entire column
Shift + Space Select entire row
No comments:
Post a Comment