Hiding columns and getting them back

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I hide columns in a spreadsheet, updated it and then I could not get my
columns back I did not save it while I was making the changes.
 
Hi
select the columns left and right to the hidden ones and goto 'Format -
columns - unhide)
 
Linda

Hit CRTL + A(twice in XL2003)to select all.

Format>Column>Unhide

Gord Dibben Excel MVP
 
You must log in or register to reply here.

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

Macros - variable columns 1
To retrieve hide columns after u saved the excel doc 2
How to delete column without deleting title across top? 1
I cannot delete the extra rows or columns in Excel 2007 2
One-click hiding/unhiding of many non-adjacent columns/rows? 4
Hiding Columns 2
Excel How to preserve column fields in a specific order in a pivot table? 2
Excel EXCEL - using a date dependant formula to hide rows 3

Back
Top