 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / May 2008unhide row does not unhide the hidden rows
hi, I run into this problem where I have hidden rows 1 - 3 and now I can't seem to unhide them. I found the below in online help. however, it still does not unhide the hidden rows. If the first row or column of a worksheet is hidden, click Go To on the Edit menu. In the Reference box, type A1, and then click OK. On the Format menu, point to Row or Column. and then click Unhide. Instead of being hidden, the height or width of the first row or column of a worksheet may have been set to zero. In this case, point to the border of the Select All button until the cursor changes to or , and then drag to widen the row or column. Any ideas are highly appreciated! thanks! Two thoughts, If your rows are hidden by a filter then you can't simply unhide them you must remove the filter. Or Tap F5 and type A1 in the dialogbox and click OK. Then Format|Row|Height set the height to 12.75. Mike > hi, I run into this problem where I have hidden rows 1 - 3 and now I can't > seem to unhide them. [quoted text clipped - 10 lines] > > Any ideas are highly appreciated! thanks! Mike, thanks for your input. I have no filters I am aware of and show all appears greyed out. Your second thought is what I tried from online help and it did not unhide either. (I have tried again anyhow with the same result) In fact I do not see the somewhat thicker line indicating hidden rows, but my sheet starts with row 4 and with "go to" I can edit content in the hidden rows. However, I still can not unhide the hidden rows. thanks! > Two thoughts, > [quoted text clipped - 20 lines] > > > > Any ideas are highly appreciated! thanks! Try going to Window/Unfreeze Panes, I had a similar problem, which led me to find this thread, and in reading it, I thought of that solution. Jim > Mike, thanks for your input. > [quoted text clipped - 33 lines] > > > > > > Any ideas are highly appreciated! thanks! Jim, thanks for the tip. However, I unfreeze also does not let me unhide the rows. same problem as before. thanks. > Try going to Window/Unfreeze Panes, I had a similar problem, which led me to > find this thread, and in reading it, I thought of that solution. [quoted text clipped - 38 lines] > > > > > > > > Any ideas are highly appreciated! thanks! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.