ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cell Merge, didn't... (https://www.excelbanter.com/excel-discussion-misc-queries/130500-cell-merge-didnt.html)

Ron

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?


All times are GMT +1. The time now is 02:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com