Missing rows

K

KK

I am missing rows 1 thru 73 on a worksheet. Row 74 is my first row on the
spreadsheet and contains the contents that would be in Row 1. I do not have
the option to click on Unfreeze Panes (it is grayed out). I tried copying
and pasting into a new worksheet, but that doesn't work either. The
formatting is not correct (even when I choose 'Paste Special'). When I try
to re-size the row height on the new worksheet, the row I am trying to
re-size disappears.
 
D

Dave Peterson

It could mean that the worksheet is filtered. Do you see arrows on any of the
"header" cells (row 1???)

Look at the row numbers. Are they grey or blue?

If they're blue, it's autofilter.
Try this (xl2003 menus):
Data|Filter|show all

I'm not sure what "hide is grayed" means, but if it's not autofilter, then try
this next.

F5 (same as Edit|goto)
type:
1:65536 (or whatever you need)
and hit enter

Then on the toolbar:
Format|row|unhide
 
E

Eduardo

Hi,
click on the mouse on row 74 and holding it go up, then right click on the
mouse unhide

hope this solve your problem
 

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

Mark Rows for scrolling 2
Excel 2003 - deleting trailing empty rows 5
custom views / macros 1
Excel VBA For excel 0
Excel graphics 4
Smaller worksheet 3
Problem with Auto fill 3
Can't delete rows 18

Top