ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   I cannot see some columns and some menu items are grayed out (https://www.excelbanter.com/excel-discussion-misc-queries/110770-i-cannot-see-some-columns-some-menu-items-grayed-out.html)

LORI ROBINSON

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.

tom

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.


Richard M Burton

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.


Gord Dibben

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.




All times are GMT +1. The time now is 01:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com