Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

cannont unhide cells in excel 2

Status
Not open for further replies.

deecee

Technical User
Aug 25, 2001
1,678
US
i have many rows hidden in excel...the document is not protected and not locked...i cannot unhide them..is there any thing else i can do becase there has been many many hours put into the work to get to this point.

deeeeceeeee X-)
 
The best way I know to unhide all rows is to click in the open block by the A coulmn header and row header 1. (or Crtl+A to select all). Goto Format/Row> Unhide Mike

 
If format row unhide does not work, it could be because somehow the rows in question have acquired a rowheight = 0.

Select all rows (Ctrl-A) and do Format, Row and click on AutoFit.

A.C.
 
Have you tried clicking on the column letters on either side of the hidden columns - i.e. first one side hold down the SHIFT key, and then the other side. Then right-click, and choose Unhide.

If your HIDDEN columns happen to be at the beginning (column A) or at the end (column IV), then: Hit the GoTo key <F5>, followed by the columns - BUT INCLUDE a column which is NOT hidden ...e.g. to unhide columns A to M, GoTo &quot;A:N&quot;. This will highlight those columns, including column &quot;N&quot; (not hidden). Then right-click on column &quot;N&quot;, and choose Unhide.

How this helps. :)

Regards, ...Dale Watson

HOME: nd.watson@shaw.ca
WORK: dwatson@bsi.gov.mb.ca
 
nothing worked
you can see the rows are hidden but it wont unhide them...if i hide something new then i cannot unhide that either
 
Did you try my suggestion.

A.C.'s suggestion was &quot;close&quot; - I think he meant that you should choose Format - Column - Unhide (After using <Control> A. :)

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
 
Daaaaaah !!! Sorry guys. I just realized the reference was to ROWS (not columns) - my apologies !!! :)

...Dale Watson dwatson@bsi.gov.mb.ca
 
Well they are hidden rows not hidden columns so the advice on unhiding columns won't work. Presumably you've tried highlighting a row above to a row below and going to unhide.

Is it the case that the row height has been set to zero as suggested earlier?

You can find your data. Simply set up some more cells with the formula =(X)(x) where X is the column and x is the row number that is hidden.

If you open a new workbook, can you hide and unhide in there? If not, sounds like an Excel fault.

If you copy the entire worksheet to a new worksheet, formulas only, does it unhide the rows? Yes, that will work, I just tried it. Good Luck!!
 
Another possibility...

...that the HIDDEN rows are resulting from Data - Filter - AutoFilter.

If this happens to be the case, using Data - Filter - Show All - will unhide the hidden rows.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca
 
Dale the filter thing worked thanks a lot man
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top