Cell Merge, didn't...
I have a spreadsheet that shows cells with Merge Cells turned on. However,
when the "cell" is selected it shows a 'Sum=' in the status bar with the
total of the unseen values.
All indicators show that the cells are Merged but in fact they aren't. It
wasn't detected and my sheet had hidden values in excess of 1.5 million
dollars that caused totals to be reported incorrect.
How do I find out where these 'cosmetic only' merges are without hunting
through every single cell in the entire spreadsheet?
|