Excel Tip of the Week #149 - Shortcuts: Working with rows and columns

Hello all and welcome back to the Excel Tip of the Week!  This week, we have a Basic User post in which we cover some very quick and essential shortcuts for working with entire rows and columns in Excel.



There are two relevant shortcuts here:

  • Ctrl and Spacebar selects the entire current column (or just the Table column if in a table; press again to select the whole column)
  • Shift and Spacebar selects the entire current row (same note on functionality within an Excel Table)


Insertion and deletion

After selecting your row(s) / column(s), the shortcuts you need are:

  • Ctrl and + to insert a new row / column (if you highlight multiple rows / columns beforehand, that is how many new rows / columns will be created)
  • Ctrl and - to delete the selected row(s) / column(s)

And that's all you need to know!

Previous post 
TOTW index 
Next post

This blog is brought to you by the Excel Community where you can find additional blogs, extended articles and webinar recordings on a variety of Excel related topics. In addition to live training events, Excel Community members have access to a full suite of online training modules from Filtered. There is also an online forum where you can ask questions and share ideas with other community members.