Wednesday, 22 February 2017

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