Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Formatting Problem
I am trying to change the formatting in a cell, but when I try clicking on
Formatcell, nothing happens. There's no protection or conditional formatting on the worksheet, and I am able to format other cells in the worksheet. Any idea of why I can't change a formatting of some cells but not others? I don't get any error messages. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Formatting Problem
Is your sheet or workbook protected? If so, unprotect...
Tools - Protection... Are you editing the cell when you attempt to format it? If so, hit Esc to get out of editing mode. "Darlene" wrote: I am trying to change the formatting in a cell, but when I try clicking on Formatcell, nothing happens. There's no protection or conditional formatting on the worksheet, and I am able to format other cells in the worksheet. Any idea of why I can't change a formatting of some cells but not others? I don't get any error messages. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Formatting Problem
The worksheet is not protected and I am not editing while formatting it.
"Sean Timmons" wrote: Is your sheet or workbook protected? If so, unprotect... Tools - Protection... Are you editing the cell when you attempt to format it? If so, hit Esc to get out of editing mode. "Darlene" wrote: I am trying to change the formatting in a cell, but when I try clicking on Formatcell, nothing happens. There's no protection or conditional formatting on the worksheet, and I am able to format other cells in the worksheet. Any idea of why I can't change a formatting of some cells but not others? I don't get any error messages. Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Formatting Problem
Have you got any conditional formatting on that cell?
Click on the cell & check conditional formatting under the format menu -- John MOS Master Instructor Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Darlene" wrote: I am trying to change the formatting in a cell, but when I try clicking on Formatcell, nothing happens. There's no protection or conditional formatting on the worksheet, and I am able to format other cells in the worksheet. Any idea of why I can't change a formatting of some cells but not others? I don't get any error messages. Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Formatting Problem
There is no conditional formatting on that cell.
"john the confused" wrote: Have you got any conditional formatting on that cell? Click on the cell & check conditional formatting under the format menu -- John MOS Master Instructor Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Darlene" wrote: I am trying to change the formatting in a cell, but when I try clicking on Formatcell, nothing happens. There's no protection or conditional formatting on the worksheet, and I am able to format other cells in the worksheet. Any idea of why I can't change a formatting of some cells but not others? I don't get any error messages. Thanks |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Formatting Problem
what formatting are you trying to change, what is in the cell now and is it
connected to any other cells? -- John MOS Master Instructor Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Darlene" wrote: There is no conditional formatting on that cell. "john the confused" wrote: Have you got any conditional formatting on that cell? Click on the cell & check conditional formatting under the format menu -- John MOS Master Instructor Please reply & rate any replies you get Ice Hockey rules (especially the Wightlink Raiders) "Darlene" wrote: I am trying to change the formatting in a cell, but when I try clicking on Formatcell, nothing happens. There's no protection or conditional formatting on the worksheet, and I am able to format other cells in the worksheet. Any idea of why I can't change a formatting of some cells but not others? I don't get any error messages. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell References | Excel Discussion (Misc queries) | |||
Cell formatting problem | Excel Discussion (Misc queries) | |||
Excel 2003 print problem with conditional formatting cell selected | Excel Discussion (Misc queries) | |||
Cell Limitations ? Formatting and Size when exporting to Tab based Text file? | Excel Worksheet Functions | |||
cell formatting problems | New Users to Excel |