#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

  • AirPennNet-Guest Wifi will be upgraded on April 27th. Device registration will require just an email address and guests will need to renew registration daily. Penn Law faculty, staff and students should all be using AirPennNet – not AirPennNet-Guest for Wifi.
  • The Penn Law Directory is available for members of the law school community to share contact information. Here are some important reminders.