Some basic Keys Common Tasks
Control - Keys + Function Keys
Shortcut Keys of MS-Excel
- Ctrl + Shift + Spacebar - Create a non breaking space
- Ctrl + B - Make letters bold
- Ctrl + I - Make letters italic
- Ctrl + U - Make letters underline
- Ctrl + Shift+ < - Decrease font size one value
- Ctrl + Shift + > - Increase the font size one value
- Ctrl + [ - Increase the font size by 1 point
- Ctrl + ] - Decrease the font size by 1 point
- Ctrl + Spacebar - Remove paragraph or character formatting.
- Ctrl + C - Copy the selected text or object
- Ctrl + X - Cut the selected text or object
- Ctrl + V - Paste text or an object
- Ctrl + Alt + V - Paste special
- Ctrl + Shift + V - Paste formatting only
- Ctrl + Z - Undo the last action
- Ctrl + Y - Redo the last action
Control - Keys + Function Keys
- Ctrl+F2 - Choose the print preview command (Microsoft office Button)
- Ctrl+F3 - Cut on the spike
- Ctrl+F4 - Close the window
- Ctrl+F6 - Go to the next window
- Ctrl+F9 - Insert an empty field
- Ctrl+F10 - Maximise the document window
- Ctrl+F11 - Lock a field
- Ctrl+F12 - Choose the Open command (Microsoft Office Button)
- Ctrl+F2 - Choose the print preview command (Microsoft office Button)
- Ctrl+F3 - Cut on the spike
- Ctrl+F4 - Close the window
- Ctrl+F6 - Go to the next window
- Ctrl+F9 - Insert an empty field
- Ctrl+F10 - Maximise the document window
- Ctrl+F11 - Lock a field
- Ctrl+F12 - Choose the Open command (Microsoft Office Button)
- Ctrl+F2 - Choose the print preview command (Microsoft office Button)
- Ctrl+F3 - Cut on the spike
- Ctrl+F4 - Close the window
Shortcut Keys of MS-Excel
- 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