At 06:57 20/05/2016 -0700, Ron Patterson wrote:
On 5/20/2016 12:00 AM, Brian Barker wrote:
At 22:26 19/05/2016 -0700, Ron Patterson wrote:
I have a column in my spread sheet ...
May I respectfully suggest that your problem may be that this is
not your spreadsheet but someone else's - in other words that the
difficulties are presented by aspects put in place by another.
... with only one entry in it at the top cell - I have tried
everything to clear this cell - nothing works, not delete, not
turning off cell protection in the Format Menu, not reformatting
it, not writing over it, and not even deleting the column. It is a
dead cell with "LL" in it and nothing less than a bomb will clear this cell.
This sounds as if the cell is protected. You cannot disable cell
protection until you have (possibly temporarily) disabled sheet
protection. Go to Tools | Protect Document > | Sheet... to toggle
off sheet protection. If you need to provide a password, the
document's author wants to prevent you making these changes.
Thanks Brian,
I am the only one with access to this computer.
Thanks for trying to help.
Hey, not so fast!
First, no-one suggested that an interloper was interfering with your
system! Instead, I assumed that if you had entered the "LL" yourself
and caused it to be difficult to modify, then you would know what you
had done and why you had done it and how to undo it - and you would
not be asking for help. The obvious guess is that this spreadsheet
was not created from scratch by you but was perhaps provided to you
by someone else - that you were sent it or downloaded it as an
existing spreadsheet. And the original author may have intentionally
protected some parts of the spreadsheet in order to prevent or hinder
your modifying them - whether by accident or by design.
Do you mean, then, that you haven't checked to see if the sheet is
indeed protected, as explained? That's not the way to learn.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
