Excel4Business - Our Blog

Excel Tips and Tricks from our Experts

Excel Help - How to Insert Multiple Rows or Columns in Excel 2013

In this video you’ll learn how to insert multiple rows and columns at the same time. Normally, you would insert a single row by clicking on a cell in the row above which you would like to insert the new row, right-clicking, selecting Insert and clicking on Insert Cells. However, if you need to add more than one blank row or column to your spreadsheet, you may find it very time-consuming to add them one by one. Luckily, there is a much quicker way to do this.

To insert several blank rows or columns, simply highlight the same number of preexisting rows or columns already in your spreadsheet.

Right-click the cells and click Insert.

In the Insert dialog box, click the direction in which you want to shift the surrounding cells.

A new set of blank rows corresponding to the number of preexisting rows you selected will appear.