row won't unhide
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 |
Answer: row won't unhide
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:
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. |
row won't unhide
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 |
row won't unhide
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 |
row won't unhide
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 |
row won't unhide
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 |
All times are GMT +1. The time now is 02:55 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com