Un-Hide Rows Help!!

  • Thread starter Thread starter Mepol
  • Start date Start date
M

Mepol

HELP! I inherited several workbooks from an x-co worker that left the
company
lets say under a dark cloud..

In trying to see what is going on in some of the files the rows are locked
somehow..
I try to un-hide them, but nothing happens.. I set the permission for me to
make modifications
to the selected rows and still nothing happens..

The sheet is not protected that I can tell, what am I missing here.. this is
XP Pro 2002 Excel.

TIA
 
Mepol said:
HELP! I inherited several workbooks from an x-co worker that left the
company
lets say under a dark cloud..

In trying to see what is going on in some of the files the rows are
locked somehow..
I try to un-hide them, but nothing happens.. I set the permission for
me to make modifications
to the selected rows and still nothing happens..

The sheet is not protected that I can tell, what am I missing here..
this is XP Pro 2002 Excel.

TIA
Click to expand...

Any chance the row height is set to zero? Select a few rows, including the
hidden rows, and set the row height to some number (i.e. 15). Perhaps your
missing rows will now be visible.

Dave
dvt at psu dot edu
 
If freeze panes is set (windows|Freeze panes), then you might be unhiding the
rows, but you can't see the change, because you've got that Freeze panes set.

It's irritating with columns, too.
 
Nope none of these things work at all..


Dave Peterson said:
If freeze panes is set (windows|Freeze panes), then you might be unhiding the
rows, but you can't see the change, because you've got that Freeze panes set.

It's irritating with columns, too.
Click to expand...
 
That was it!!!!!!!!!!

Now off to fix the problems!!

Thanks all this is what the internet is for... pooling knowledge for solving
life's little bumps!


nobody said:
data - filter - autofilter maybe?
Click to expand...
 
Back
Top