How the Insert row in Excel error occurs and what to watch out for.
- For updated video clips in structured Excel courses with practical example files, have a look at our MS Excel online training courses . You can even try the Free MS Excel tips and tricks course.
- To see if this video matches your skill level (see the suggested skill score below) do our free MS Excel skills assessment.
- If you are based in South Africa look at the live courses we offer in Johannesburg and Cape Town.
Insert row in excel error
The ability to INSERT ROWS is another one of Excel’s very useful features however it does have a risk. Here we show the insert row in excel error.
So for example here we have a typical spreadsheet. This is a Subtotal of those cells, and this adds up a number of cells, and that is just a total of the two subtotals.
Now let’s say you realize you’ve forgotten to include the labour component, so what you can do
you can go to this line,
you can insert a row
put in a Labour Cost
and put in a number
Similarly you can go here
insert a row,
put in a labour cost,
and insert your number
However if you left it at that,
when you look at these subtotals, you realize not only is it not picking up there,
if you click here, you’ll see its not being picked up in this section as well,
It’s very important to realize that depending on where you make the insertion, any formula that refer to the cells close by, might not actually do what you expect it to do.
Again I highly recommend you use the Auditing Toolbar to make sure that sections that you want to include are included in your calculations.
The way I recommend that you do it is
you either you look at the subtotals,
or once you’ve made the insertion
just click on an inserted number
and use trace dependants
and it will quickly tell you that it is not being used in the correct cells