I have hidden rows in a 1200 item spreadsheet. Today when I opened it and
went to unhide some rows, it won't let me. The freeze pane is not on. I
have tried to unhide individual rows and also highliting the entire
spreadsheet and doing an "unhide". Nothing seems to work. I cannot figure
why this has happened, never had this before. HELP!!!
--
terie

Hi Terie,

I'm sorry to hear that you're having trouble unhiding rows in your Excel spreadsheet. Here are a few things you can try to fix the issue:

1. Check if the rows are actually hidden: Sometimes, it can be easy to mistake hidden rows for deleted rows. To check if the rows are actually hidden, try selecting the rows above and below the hidden rows, right-clicking on them, and selecting "Unhide". If the hidden rows appear, then they were indeed hidden.
   
2. Check if there are any filters applied: If you have filters applied to your spreadsheet, it can prevent certain rows from being visible. To check if there are any filters applied, go to the Data tab and look for the "Filter" button. If it's highlighted, click on it to turn off the filter and see if the hidden rows appear.
   
3. Check if there are any grouping or outlining applied: If you have grouped or outlined any rows in your spreadsheet, it can prevent certain rows from being visible. To check if there are any grouping or outlining applied, look for the small plus or minus signs on the left-hand side of your spreadsheet. If there are any, click on them to expand or collapse the grouped or outlined rows and see if the hidden rows appear.
   
4. Check if the rows are protected: If the worksheet or certain cells are protected, it can prevent you from unhiding rows. To check if the rows are protected, go to the Review tab and look for the "Protect Sheet" button. If it's highlighted, click on it to unprotect the sheet and see if the hidden rows appear.

I hope one of these solutions works for you. Let me know if you have any other questions or if there's anything else I can help you with.

Maybe the row is not actually hidden. Try selecting all cells by clicking
the blank block next to your column header A and above Row 1. This should
select all cells in the sheet. Then go to Format-Row-AutoFit.

HTH,
Paul

"terie" wrote in message
...
I have hidden rows in a 1200 item spreadsheet. Today when I opened it and
went to unhide some rows, it won't let me. The freeze pane is not on. I
have tried to unhide individual rows and also highliting the entire
spreadsheet and doing an "unhide". Nothing seems to work. I cannot
figure
why this has happened, never had this before. HELP!!!
--
terie

Perhaps it only appears to be hidden and in fact is just set to a minimal Row
Height.

Vaya con Dios,
Chuck, CABGx3



"terie" wrote:

I have hidden rows in a 1200 item spreadsheet. Today when I opened it and
went to unhide some rows, it won't let me. The freeze pane is not on. I
have tried to unhide individual rows and also highliting the entire
spreadsheet and doing an "unhide". Nothing seems to work. I cannot figure
why this has happened, never had this before. HELP!!!
--
terie

Maybe
Data|filter|show all
would help.

terie wrote:

I have hidden rows in a 1200 item spreadsheet. Today when I opened it and
went to unhide some rows, it won't let me. The freeze pane is not on. I
have tried to unhide individual rows and also highliting the entire
spreadsheet and doing an "unhide". Nothing seems to work. I cannot figure
why this has happened, never had this before. HELP!!!
--
terie

--

Dave Peterson

Yes it did. I found that right after I ask the question. I don't know how a
filter got applied, but I guess it did. Thanks
--
terie


"Dave Peterson" wrote:

Maybe
Data|filter|show all
would help.

terie wrote:

I have hidden rows in a 1200 item spreadsheet. Today when I opened it and
went to unhide some rows, it won't let me. The freeze pane is not on. I
have tried to unhide individual rows and also highliting the entire
spreadsheet and doing an "unhide". Nothing seems to work. I cannot figure
why this has happened, never had this before. HELP!!!
--
terie

--

Dave Peterson