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?