• CTRL + A : Select all the cells of the active worksheet.
  
  
• SHIFT + F11: To insert a new worksheet
  
  
• CTRL + PgDn key : Moves to the next worksheet
  
  
• CTRL + PgUp key : Moves to the previous worksheet
  
  
• CTRL + N : Opens new workbook window
  
  
• CTRL + D: Copies the contents of previous cell to current cell.
  
  
• SHIFT + Space bar key : Selects the current row.
  
  
• CTRL + Space bar key : Selects the current column.
  
  
• CTRL + Tab key : Moves to the next opened workbook.
  
  
• CTRL + K : Insert hyperlink
  
  
• F2 : Edit the selected cell
  
  
• CTRL + F2 / F4: Print preview of current sheet
  
  
• CTRL + F4 : Closes the current workbook
  
  
• ALT + F2 : Opens the "Save as" window
  
  
• ALT + F11 : Opens the workbook in Visual Basic
  
  
• F1 : Opens the Microsoft Help window
  
  
• CTRL + F : Finds a particular text in the sheet
  
  
• CTRL + H : Finds a particular text and replaces it with the given text
  
  
• CTRL + S : Saves the workbook
  
  
• CTRL + 1 : Opens the Format dialog
  
  
• CTRL + - (Minus key) : Opens the delete window
  
  
• CTRL + T / CTRL + L : Creates a table
  
  
• CTRL + O : Opens the Open file window
  
  
• CTRL + P : Opens the Print file window
  
  
• CTRL + G : Opens the Goto window

• Written by Meean.
• In category Software.
• 15 years ago.

Hot Hits: 1613

Like it on Facebook, Tweet it or share this article on other bookmarking websites.