[mso] Re: Excel - locked cell
- From: "David Smart" <smartware@xxxxxxxxxxxxxxx>
- To: <mso@xxxxxxxxxxxxx>
- Date: Wed, 4 Apr 2007 08:35:33 +1000
Try deleting several rows, including the one with the cell in it.
Is there any VBA? If so have a look at that, or try answering "disable" if
it asks whether you want to enable macros.
Failing that, looks like you'll need to upload your sheet. Not sure how you
do that for this list, but just ask the owner/moderators and they'll help
you.
Regards, Dave S
----- Original Message -----
From: <caroledrake@xxxxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Sent: Wednesday, April 04, 2007 5:31 AM
Subject: [mso] Excel - locked cell
>I have a cell that is not exactly locked - I can type in it and erase that
>typing. I cannot delete the cell. If I try to delete the row, the cell just
>pops up in the next row. I cannot right click - It has all options blocked.
>I cannot choose to anything it. If I select all cells around it and delete,
>they delete but it stays. It kind of acts like a label or title because I
>can type in it. I cannot change the format - there are no options listed
>except to lock the whole worksheet or delete the whold worksheet. I tried
>'save as' like my book suggests to see if it would reset itself. Didn't
>work. How do I get rid of this monster cell?
> Carole
> caroledrake@xxxxxxxxxxx
>
> *************************************************************
> You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
> MicrosoftOffice@xxxxxxxxxxxxxxxx
>
> To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
>
> To Unsubscribe from this group, visit the group's homepage and use the
> dropdown menu at the top. This will allow you to unsubscribe your email
> address or change your email settings to digest or vacation (no mail).
> //www.freelists.org/webpage/mso
>
> If you are using Outlook and you see a lot of unnecessary code in your
> email messages, read these instructions that explain why and how to fix
> it:
> http://personal-computer-tutor.com/abc3/v28/greg28.htm
> *************************************************************
>
*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or
MicrosoftOffice@xxxxxxxxxxxxxxxx
To send mail to the group, simply address it to mso@xxxxxxxxxxxxx
To Unsubscribe from this group, visit the group's homepage and use the dropdown
menu at the top. This will allow you to unsubscribe your email address or
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso
If you are using Outlook and you see a lot of unnecessary code in your email
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
Other related posts:
