Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: How to protect collumn formula

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Dear,

    I setup a formula for collumn, and I don't want anyone to change it.

    But I don't know how to setup it.

    Lyvia

  2. #2
    Guest

    Default

    On 2002-03-10 19:51, LyviaChung wrote:
    Dear,

    I setup a formula for collumn, and I don't want anyone to change it.

    But I don't know how to setup it.

    Lyvia

    do you just want to protect that column? if so select all columns except the one you don't want to be changed,(hold down the ctrl key to select multiple columns, or if you're selecting all columns to the right of the one you want to protect hold down ctrl+shift and press the right arrow key)and go to format menu>cells>protection tab and uncheck the 'locked' checkbox. then go to tools menu>protection and protect the sheet as instructed. then any cell except those in your protected column can be edited. is that what you wanted?

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •