Un-Hide Rows Help!!

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
 
D

dvt

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
 
D

Dave Peterson

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.
 
M

Mepol

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...
 
M

Mepol

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to hide rows if cell in another WS is ="No" 11
hide rows in workbook 1
Help - hiding multiple sets of rows based on two different cells 2
Hide Rows per criteria 7
Problem with searching through content and delete unwnated column 0
peculiar condition: form optionbuttons lose position and linkedcellon row hide 1
Hide Rows Between Specified Dates 4
hidden rows, column copy-paste 0

Top