Can't unhide rows

[Kristie L. Falvey]

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

 

[RagDyeR]

You probably have a filter in force.
Try:
<Data> <Filter>
And *Uncheck* - "AutoFilter".
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

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