Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to merge many cell to one cell with keeping all data | Excel Worksheet Functions | |||
mail merge excludes my headers and critical data in Word merge | Excel Discussion (Misc queries) | |||
How to merge one cell from many workbooks to one cell on one work | Excel Worksheet Functions | |||
Merge cell & Copy Data from different cell | Excel Discussion (Misc queries) | |||
How do I merge 2 cells for ex. DE (1 cell) & 01234 (2 cell) into . | Excel Discussion (Misc queries) |