How to add multiple rows or columns in one go [Microsoft Excel Guide]

Looking for how to add more than one row or column while you are working on Excel sheets. As you play around with your data, sometimes you might need a shortcut to insert or add multiple rows or columns in Microsoft Excel, it can be tens or even hundreds of rows or columns which you want to add at a time. As you know doing it one by one would be a tedious job and takes a lot of time, why don’t you try this quick workaround to add multiple rows or columns in one go in Microsoft Excel.

How to add multiple rows or columns in one go [Microsoft Excel]

If you are an Excel user, you already know how to add a row or column, simply right-click on the top of the row (or column) to bring the drop-down menu, choose Insert to add a row (or column). But what if you want to add multiple rows or columns? You don’t want to stuck with adding them one by one, right? so here’s what you need to do.

  • Step 1: To add multiple rows or columns in a spreadsheet, highlight the same number of pre-existing rows or columns to add.
  • Step 2: Now right-click on the selected rows or columns to bring the drop-down menu that lets you insert, choose Insert to add multiple rows or columns in Excel.

For instance, if you want to add three extra rows, just highlight three existing rows and then insert them from the right-click menu.

  • Alternatively, you can go to Home -> Insert -> Insert Sheet Rows or Insert Sheet Columns.

That’s how you can add more than one row or column at the same time in Microsoft Excel. Liked our content? More guides and tutorials related to Windows are right below, check them out.