ITS Online

#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

  • Image preview
    As an instructor, you can verify all external links throughout your course to ensure they are valid. You can check these links using the course link validator, which searches through course content and returns invalid or unresponsive external links in both published and unpublished content.
  • Image preview
    Join us Friday, January 22 at noon in Gittis 213 to learn how you can get started using Poll Everywhere. This solution is available to all Penn Law faculty and staff for unlimited polls.