How performing a delete cell in Excel can results in errors in not only that cell but other cells within the spreadsheet
DELETING individual cells and moving their relative position can also have a serious effect and result in situations that cause delete cell errors.
Again here’s a very simple spreadsheet, what you’ve got here is the Gross Profit being calculated by subtracting Cost of Sales from Sales, and that flows all the way through.
As you are typing, you forgot and you actually put Product B’s sales into Product C as well and you typed on. So you realize that F12 needs to go, what you can do is
And again you need to be very careful when deleting individual cells and moving the relative position of it. I don’t recommend you do it at all, but if you are going to, it make use of the Auditing Toolbar and look around the deleted area, just to see how the various formula have reacted
Occasionally when you have a spreadsheet that will be used for presentation you may want to neaten it up by either showing zeros in Excel or not showing the zero in cells that have a zero in them. We typically … Continue reading
If I understand the query below correctly, the one idea is to type some words in a cell, and then, while holding the ALT key down, click ENTER. Within the cell you will get another line. Hope this helps. Original query Hi, … Continue reading
"The best Excel course I've ever attended. Thanks!"- F. Swanepoel Sun International– F. Swanepoel – Sun International