#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

  • Please review our instructions carefully. ITS will also have a pop-up Help Desk at the Clock April 17, 19 and 20 from noon-1pm for students who need help.
  • The Box team recently announced a new and improved, more personalized user experience with interface changes and backend improvements. Read on for more details