Some basic Keys Common Tasks
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)
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
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
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)
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
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