Looking to save time when setting up and editing spreadsheets in Excel? Here are some shortcuts for quickly inserting or selecting entire rows or columns.
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.