I cannot see some columns and some menu items are grayed out

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

Guest

we are missing some colums from our spreadsheet and we cant unhide them
beacuse the button is grayed out the information is still there because i can
do a mail merge and put in to a word document from that spreadsheet.
 
Lori,
Try selecting the entire sheet (the button between the "A" and the "1") in
the upper left hand corner. Then go to FORMAT > COLUMN > WIDTH and set to the
default width of 8.43. That should solve the problem if the columns are just
set so small that you can't see them.

Tom
 
Hello Lori,

On occassion I have found greyed out menu items when Excel thinks you are
doing something that is not compatible with the function of the item. So
check that you are not doing anything that would block unhiding.

Good luck
 
I would suggest that your sheet is protected.

Are there other functions that are not available?

Tools>Protection>UnProtect Worksheet


Gord Dibben MS Excel MVP

On Wed, 20 Sep 2006 05:56:01 -0700, LORI ROBINSON <LORI
 

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

Back
Top