Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locked Formatting
I have "inherited" a spreadsheet that has borders in some of the cells to
simulate a form. The problem I am having is in the cells that abut a border I cannot change the cell's format. The cells that do not abut a border can be changed. Is there some "switch" or option somewhere that can be "flipped" that will allow the changing of these cells' format? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locked Formatting
Is the worksheet protected?
-- David Biddulph "SteveB" wrote in message ... I have "inherited" a spreadsheet that has borders in some of the cells to simulate a form. The problem I am having is in the cells that abut a border I cannot change the cell's format. The cells that do not abut a border can be changed. Is there some "switch" or option somewhere that can be "flipped" that will allow the changing of these cells' format? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locked Formatting
No, it's not protected. Sorry, that would have been a useful piece of info to
include in the original post! As a matter of fact, the only cells I cannot alter are the cells that abut the borders, the only thing I cannot change is the formatting. I can delete them, change the contents, do anything I want or need to do, except change the format! So you may ask, what's the issue? This is a multiple sheet workbook that needs to be updated annually (for the annual budget cycle). If you cut / copy / paste and you mess up the formatting, you can't fix it! "David Biddulph" wrote: Is the worksheet protected? -- David Biddulph "SteveB" wrote in message ... I have "inherited" a spreadsheet that has borders in some of the cells to simulate a form. The problem I am having is in the cells that abut a border I cannot change the cell's format. The cells that do not abut a border can be changed. Is there some "switch" or option somewhere that can be "flipped" that will allow the changing of these cells' format? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locked Formatting
is there a conditional format being applied? (this overrides some other
formatting) "SteveB" wrote: No, it's not protected. Sorry, that would have been a useful piece of info to include in the original post! As a matter of fact, the only cells I cannot alter are the cells that abut the borders, the only thing I cannot change is the formatting. I can delete them, change the contents, do anything I want or need to do, except change the format! So you may ask, what's the issue? This is a multiple sheet workbook that needs to be updated annually (for the annual budget cycle). If you cut / copy / paste and you mess up the formatting, you can't fix it! "David Biddulph" wrote: Is the worksheet protected? -- David Biddulph "SteveB" wrote in message ... I have "inherited" a spreadsheet that has borders in some of the cells to simulate a form. The problem I am having is in the cells that abut a border I cannot change the cell's format. The cells that do not abut a border can be changed. Is there some "switch" or option somewhere that can be "flipped" that will allow the changing of these cells' format? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locked Formatting
I have inherited similar worksheets in the past.
In my case there was a picture object placed behind the cell. Is it definitely not an object of some sort rather than just cell formatting? Kind regards, Dan Sanford Lefkowitz wrote: is there a conditional format being applied? (this overrides some other formatting) "SteveB" wrote: No, it's not protected. Sorry, that would have been a useful piece of info to include in the original post! As a matter of fact, the only cells I cannot alter are the cells that abut the borders, the only thing I cannot change is the formatting. I can delete them, change the contents, do anything I want or need to do, except change the format! So you may ask, what's the issue? This is a multiple sheet workbook that needs to be updated annually (for the annual budget cycle). If you cut / copy / paste and you mess up the formatting, you can't fix it! "David Biddulph" wrote: Is the worksheet protected? -- David Biddulph "SteveB" wrote in message ... I have "inherited" a spreadsheet that has borders in some of the cells to simulate a form. The problem I am having is in the cells that abut a border I cannot change the cell's format. The cells that do not abut a border can be changed. Is there some "switch" or option somewhere that can be "flipped" that will allow the changing of these cells' format? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locked Formatting
I can find no evidence of a picture object, but I might not know
exactly where and how to look! Nor can I find any conditional formating. And since the formating doesn't change when I make changes to the cell, I doubt that is it. One thing I have discovered. If I select the entire worksheet I can turn off all of the borders, then I can alter each cell as you would expect to be able to do. I really don't want to have to clear the formatting and start over but that's beginning to look like my only option. The workbook has 24 individual sheets, each formatted differently! On Oct 20, 2:53 pm, "Dan" wrote: I have inherited similar worksheets in the past. In my case there was a picture object placed behind the cell. Is it definitely not an object of some sort rather than just cell formatting? Kind regards, Dan Sanford Lefkowitz wrote: is there a conditional format being applied? (this overrides some other formatting) "SteveB" wrote: No, it's not protected. Sorry, that would have been a useful piece of info to include in the original post! As a matter of fact, the only cells I cannot alter are the cells that abut the borders, the only thing I cannot change is the formatting. I can delete them, change the contents, do anything I want or need to do, except change the format! So you may ask, what's the issue? This is a multiple sheet workbook that needs to be updated annually (for the annual budget cycle). If you cut / copy / paste and you mess up the formatting, you can't fix it! "David Biddulph" wrote: Is the worksheet protected? -- David Biddulph "SteveB" wrote in message ... I have "inherited" a spreadsheet that has borders in some of the cells to simulate a form. The problem I am having is in the cells that abut a border I cannot change the cell's format. The cells that do not abut a border can be changed. Is there some "switch" or option somewhere that can be "flipped" that will allow the changing of these cells' format? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting: "handwritten" circles? | Excel Discussion (Misc queries) | |||
Conditional formatting : amount of decimals | Excel Discussion (Misc queries) | |||
Paste Link - retaining formatting | Excel Discussion (Misc queries) | |||
conditional formatting with formula | Excel Worksheet Functions | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |