| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
format cell does not work
When I right click on a cell and select "format cells" the normal dialog box
does not appear. There are some cells that it works ok on. Some of these have protection turned on and some are off. The workbook protection is turned OFF. The "format cells" menu selection is not grayed out |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
format cell does not work
Are all protections turned off? Sheet/workbook/etc? Or only workbook?
"Kruppy" wrote: When I right click on a cell and select "format cells" the normal dialog box does not appear. There are some cells that it works ok on. Some of these have protection turned on and some are off. The workbook protection is turned OFF. The "format cells" menu selection is not grayed out |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
format cell does not work
Yes, ALL protections are turned off. This file was "imported" from Quattro
Pro. It was a long time ago and I'm not sure what version. Would that have something to do with it ?? "Sean Timmons" wrote: Are all protections turned off? Sheet/workbook/etc? Or only workbook? "Kruppy" wrote: When I right click on a cell and select "format cells" the normal dialog box does not appear. There are some cells that it works ok on. Some of these have protection turned on and some are off. The workbook protection is turned OFF. The "format cells" menu selection is not grayed out |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Format won't open for cell in Excel
Hi,
Just had this happen to me. Not sure what caused it, however I got it to work by finding a cell that allowed me to choose and use the Format Option. I copied the good cell and did a Paste Special - Formats in all of the affected cells. Seems to have worked. Thanks, Katy |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format .txt file contents to numeric format will not work - help! | Excel Discussion (Misc queries) | |||
| Number Format Code won't work | Excel Discussion (Misc queries) | |||
| currency format doesn't work first try | Excel Discussion (Misc queries) | |||
| format a drop-down box from a range of cell from another work... | Excel Worksheet Functions | |||
| My date format will not work. | Excel Discussion (Misc queries) | |||
Hybrid Mode
