I have a worksheet with about 860 rows in it. Just data, no functions,
formulas or anything.
The problem is, I can see rows 1, 2, & 3, then right below, row 869.
What I have tried:
*selecting and unhiding the all the rows at the same time. DIDN'T work.
*selecting and setting row height, or AUTOFIT for all the rows at the same
time. DIDN't work.
*GO TO [hidden cell] (like A4), and setting AUTOFIT. That did work, but of
course, for only that row. Of course, I can't go through and do each one at
a time.
Also, some of the row numbers are now in blue. I don't know what that
means, but hope it is significant.
Thanks in advance!
K
Bookmarks