Unhide rows
 

I have a spreadsheet that has 100 columns of data.
Unfortunetely rows 21 - 60 are hidden. The spreadsheet is
unprotected and I have tried to unhide these rows without
success. The only way to unhide it is to physically drag
one row at a time. I also noted that the numbers listing
rows 1 -20 (number of the row on the left side) are purple
color, where as rows 21+ are normal black color.

thanks

Comic_fly

Sounds like there is a filter on, do datafiltershow all


Regards,

Peo Sjoblom


" wrote:

I have a spreadsheet that has 100 columns of data.
Unfortunetely rows 21 - 60 are hidden. The spreadsheet is
unprotected and I have tried to unhide these rows without
success. The only way to unhide it is to physically drag
one row at a time. I also noted that the numbers listing
rows 1 -20 (number of the row on the left side) are purple
color, where as rows 21+ are normal black color.

thanks

Comic_fly

Hi

Try DataFilter
Show all

--
Regards Ron de Bruin
http://www.rondebruin.nl


" wrote in message ...
I have a spreadsheet that has 100 columns of data.
Unfortunetely rows 21 - 60 are hidden. The spreadsheet is
unprotected and I have tried to unhide these rows without
success. The only way to unhide it is to physically drag
one row at a time. I also noted that the numbers listing
rows 1 -20 (number of the row on the left side) are purple
color, where as rows 21+ are normal black color.

thanks

Comic_fly

Thanks. It worked
-----Original Message-----
Hi

Try DataFilter
Show all

--
Regards Ron de Bruin
http://www.rondebruin.nl


"
wrote in message
...
I have a spreadsheet that has 100 columns of data.
Unfortunetely rows 21 - 60 are hidden. The spreadsheet
is
unprotected and I have tried to unhide these rows
without
success. The only way to unhide it is to physically
drag
one row at a time. I also noted that the numbers
listing
rows 1 -20 (number of the row on the left side) are
purple
color, where as rows 21+ are normal black color.

thanks

Comic_fly


.