I can't unhide rows?

[Barry Katcher]

Hi, Peoples.

I have a workbook in which I can't unhide 10 hidden rows (91 thru 100). The workbook and worksheet are unprotected. There is no VBA code in the workbook. Does anyone know why this may be happening?

Thanks,

Barry

 

[ctrlaltdel]

Do you have panes frozen?

 

[Andrew Poulsom]

Maybe someone's set the row height to a very low number, which is not the same as hiding it. Try Format|Row|Height instead of Unhide.

 

[TheBuGz]

try by adjusting row height, rather than un-hide

 

[Barry Katcher]

Sorry, my internet connection keeps going kaploooie....

Nope, neither one. No frozen panes, and I tried formatting the row height; doesn't expose the rows. Any other ideas?

Barry

 

[Andrew Poulsom]

Try this.

Right click the header of the row above the hidden rows, choose Row Height and click OK. Hold down Shift, click the header of the row below the hidden rows and press F4.

 

[Tom Urtis]

Also, check to make sure your sheet is not in Filter mode. Click on Data > Filter and see if Show All needs to be selected.

 

[Barry Katcher]

Thanks, Andrew & Tom. I checked Filter first and, sure 'nuff, that was what it wuz. The filter-unfilter code in my print macro was wacked. Oh well, another day, another screw-up.

Thanks again.

 

[HAPN]

Thank you for this thread. It helped me also.

 

[mhc3379]

Me too!