I once overused cell hiding to make a report look nice. I wanted it to show only the print area. It looked like a professional report. Something very strange occurred at some point and I am only left with my speculation of what it could be. At first I noticed that the document was very slow. Slow to open, slow to scroll, slow to do anything at all really. Then after I saved it was clear that my 2MB report had ballooned to 12MB.
Then I tried to fix it. The columns would unhide but the rows... The rows never came back. I held a little funeral as I explained to my spreadsheet that it was over. I would move whoever was left to a new home in a new spreadsheet and leave this terrible mess behind. It's the least I could do after they lost so many of their uniformly divided brethren.
So what happened? I hid the rows by selecting all the unused rows and I hid the columns by selecting whole columns. Where these two commands intersected I believe a perverse cell hiding orgy took place where each cell was told to hide multiple times in some way that Microsoft never intended. This duplicitous duplication is irreversible. I do not recommend it even though it sure did look nice.
Keep Up with TechRepublic