#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.

 

Contact

Systems Availability

  • Our online services may not be available during these maintenance periods.

    Regularly
    Fridays: 5pm-midnight
    2nd & 4th Tuesdays: 5pm-7pm

    Occasionally
    Tuesdays: 5am-7am
    Thursdays: 5pm-7pm

    Notices
    https://twitter.com/pennlawitsalert

image
Bug 00