How the Insert row in Excel error occurs and what to watch out for.
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
Advanced Excel Course – June 2013 in South Africa Our next advanced excel course is running during June 2013 in Johannesburg. During the week of the 10th June we offer the following options. You can either attend the full 5 … Continue reading
A very popular chart is the waterfall chart which shows the impact of various items on a total e.g. the various components that explain the move from budgeted profit to actual profit. A common way to build this is using … Continue reading
“Data accuracy and consistency has improved dramatically across Absa Capital, so much so that it has become compulsory within certain areas for all staff to complete Adrian’s Data Analyses Spreadsheet Techniques course.”– Absa Capital