#213 Create and Edit Spreadsheets Faster in Excel

February 12, 2014

Here are some shortcuts to save time setting up and editing spreadsheets in Excel:

 

Select an Entire Row

  • PC: Select any cell in the row and press Shift+Spacebar
  • Mac: Select any cell in the row and press Shift+Spacebar

 

Select an Entire Column

  • PC: Select any cell in the column and press Ctrl+Spacebar
  • Mac: Select any cell in the column and press Control+Spacebar

 

Insert a Row or Column

  • PC: Select a row or column and hold Ctrl+Shift and press +
  • Mac: Select a row or column and hold Control and press I

 

For more information on Excel, please see our previous ITS Tips or visit our guide on ITS Online.

 

Latest News

  • The Center for Computer Assisted Legal Instruction, also known as CALI, provides online interactive tutorials on various legal subjects.  Tutorials are authored by law faculty and peer reviewed by a member of the CALI Editorial Board.  Here is information on how to create an account and access the materials.
  • With so many digital tools that require passwords, it’s difficult to create memorable passwords that are both unique and hard to guess. Use LastPass to get control of your passwords for National Cyber Security Awareness Month!