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
0 Comments