When you need a new sheet row in Excel, how do you handle it? Instead of completely re-arranging all of the data, it’s better to use Excel’s features to insert new areas to work with.
In this tutorial, you’ll learn to insert sheet rows in Excel. This will help give you new space to work with without creating a complete redesign.
Insert a Sheet Row in Excel
Remember that rows are the horizontal areas that you see in Excel, each of which has a unique number. Rows and columns (shown with letters at the top of Excel) intersect and create cells.
When you need a new row, right-click on a row and choose Insert. This will add a new row above the one you selected.
As you can see, the spreadsheet adapts by moving everything else down a single row. No matter how large your spreadsheet is, Excel will handle rewriting the the formula references so that the spreadsheet works normally.
Insert Multiple Sheet Rows in Excel
Let’s say that you need more than a single row added to your spreadsheet. Maybe you’re completely redesigning the structure of your workbook and need much more room to work. In that case, it helps to know how to insert multiple sheet rows with one swift command.
The approach is similar. In this case, we’re going to highlight as many rows as we wish to add. In the example below, notice that we start by highlighting two rows, rows 8 and 9. Then, I’ll use the right-click Insert menu to add new rows. Two new rows are added, and all other content shifts accordingly.
That’s all there is to it: highlight the number of rows you need to add, then right-click and choose Insert. Excel reshuffles your workbook, shifting the cells down so that you have the new space you need to work within.