unhiding left most columns (excel 2000)

Topic

New Reply

i am working on sheet2 of a worksheet and have hidden columns a-u. I want to unhide them.
I know column a is present, because when i do a find on some data, I get the a1 cell showing up in my cell indicator on the formula bar. but it does not display column a. Likewise I can “find” data in f1. I have tired “auto format width” entire worksheet. I have tried unhide entire worksheet. I can’t click on the left surrounding cell since column A is the first column.

Reply | Quote

Replies

Select the entire worksheet then menu Format Column Unhide.

Reply | Quote

worked like a charm – thanx

Reply | Quote