• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Read-only & read write access for specific columns in excel 16

akika

New Member
Hi,
Pls help.
I have an excel doc in a share drive and 5 users have access to it.
I want that specific users e.g Kim, Kate and akika to get read-write access to the excelsheet column A to G
and other specific users (Sam, John) to have read-only access column H to L.

How can i do that pls?
 
Thxs.
Ive tried and for the first range its ok only user mention in list can edit.
Cell A TO G10 editable.
But once i select the first range, the option Allow users to edit ranges is disabled and i cannot make the cell H to L editable for another set of users.

is there somthing else to do??

cell A to G10 should take range 1
e.g Kim, Kate and akika to get read-write access to the excelsheet column A to G .. and they shouldnt be able to edit column H to L

Cell H to L should take range 2 config

e.g (Sam, John) to have read-write access column H to L but read-only for column A to G

upload_2018-11-20_20-41-40.png
 
Last edited:
yes i hve access..
Ive set my name in the range 1 permission for cell A to G10.
If i try to input in cell a12, then i get the message that cell is protected.. which is ok.

But if i try to input in cell H then its allowed .. which shouldnot be the case.
how should i make cell A to G take range 1 and other cell H to L range 2.
As when i select the first range, the option Allow users to edit ranges is disabled and i cannot make the cell H to L editable for another set of users.

Any idea?
 
Back
Top