Thursday, March 19, 2015

Computer: Important Short-Cut Key for Competitive Exams

Important 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

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

Get Study Materials in Your E-Mail


0 comments:

Post a Comment

Leave your comment but never use bad words otherwise you will be blocked.