Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default I cannot see some columns and some menu items are grayed out

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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
tom tom is offline
external usenet poster
 
Posts: 570
Default I cannot see some columns and some menu items are grayed out

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

"LORI ROBINSON" wrote:

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.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 19
Default I cannot see some columns and some menu items are grayed out

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


"LORI ROBINSON" wrote:

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.

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default I cannot see some columns and some menu items are grayed out

I would suggest that your sheet is protected.

Are there other functions that are not available?

ToolsProtectionUnProtect Worksheet


Gord Dibben MS Excel MVP

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

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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 02:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"