![]() |
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