- 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
Wednesday, 22 February 2017
Shortcut Keys of MS-Excel
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment