Bookings Sheet

Copper Contributor

I have a xcel booking sheet shared on google drive to about 20 others. Can anyone advise once a booking is made by a person, how would you would ensure that no one else can edit that cell accept the person who made the booking? Appreciate any advice and assistance.

1 Reply

@KoroT1965 
there is an option for protecting and secure in excel.
hence, we can protect sheets or the customized area we want.

say the user can edit only few range of cells in sheet

step 1 choose the area you want user to edit. in my case its cell A1:F10 
step 2 right click and find format cell.

harshulz_0-1645668311580.png

step 3 goto proctection and uncheck locked cell

harshulz_1-1645668366070.png

step 4 goto sheet tab , right click and choose protect sheet

harshulz_2-1645668452680.png

step 5 you may secure by entering password and press ok 

harshulz_3-1645668717260.png

 

conclusion : you can edit only and only cells a1:f10 in the whole sheet

i have attached file where you cant edit cells beyond f10