The risks posed by hidden cells (either rows or columns) in Excel.
HIDDEN rows or columns can cause their own problems. Especially if you are working on someone else’s spreadsheet, or you have worked on a spreadsheet a while back and this is the first time you are coming back to it
For example you’ve got a very simple spreadsheet here, what you’d like to do is just add up the total expenses and that’s fairly simple
If you look at that you’ll see that what seems to be happening is that it’s saying that 2 + 1 + 1 is actually 6, which is clearly wrong, and by you looking along the side you see that you actually have some hidden rows
when you unhide them,
You’ll see that this is effectively a subtotal, and by just simply adding up the entire section you’ve included, you’ve double counted numbers. This is an easy error to make especially as mentioned previously if it’s not your spreadsheet.
What can also happen is you can overwrite hidden columns by just copying over them and this can cause problems
Its useful to avoid hidden rows especially while you’re building a spreadsheet, and if you receive a spreadsheet from someone else it might be useful as a first guess, just to open up all hidden rows and columns just to make sure that you know what is actually being looked at.
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
I actually told Gavin this morning that I want to send you an e-mail. It was excellent. I have personally asked most of the people who were there what they thought about it, and everybody was really positive and confirmed that they learned a lot.– Melco Conveyor Equipment (Pty) Ltd