# How to Lock a Sheet in Google Sheets

Viewport: 1920x951 @0.75x

Playback: autoplay=false durationMs=3000 navBar=false arrows=true callouts=true browserBar=false browserTheme=light

1. [Intro] How to Lock a Sheet in Google Sheets
   - body: Follow this detailed walkthrough to lock a sheet in Google Sheets to prevent unwanted edits. This guide will cover each step you need to take to secure your data.
   - voiceover: This guide provides a detailed, step-by-step walkthrough on how to lock a sheet in Google Sheets, ensuring only permitted users can edit it.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gr3ayn001clg0cchkfrhno/cm6gragwa000d0cjo3kfd4isw.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
1. step_01 [image] - Click on Data tab
   - source type: IMAGE
   - description: Open the Google Sheet you wish to lock.
   - target: (358.15052099962486, 24.121706398996224), rect: top=34 left=299.75 width=47.5 height=24
   - hotspots: 1
     - hotspot_01 (358.15052099962486, 24.121706398996224), rect: top=34 left=299.75 width=47.5 height=24
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: Navigate to the top menu in Google Sheets and click on the 'Data' tab to access various data-related options.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gr3ayn001clg0cchkfrhno/cm6graldt000f0cjogbkx7jmn.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gr3ayn001clg0cchkfrhno/cm6gr3u6v0000033phxtpohbc.png
2. step_02 [image] - Click on Protect sheets and ranges
   - source type: IMAGE
   - description: Navigate to the specific sheet tab you want to lock.
   - target: (539.206966039614, 297.57594221331294), rect: top=-209 left=-257.91668701171875 width=1754 height=1366
   - hotspots: 1
     - hotspot_01 (539.206966039614, 297.57594221331294), rect: top=-209 left=-257.91668701171875 width=1754 height=1366
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: In the 'Data' tab dropdown menu, find and click on 'Protect sheets and ranges' to open the protection settings panel.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gr3ayn001clg0cchkfrhno/cm6gralem000g0cjogoza4p9q.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gr3ayn001clg0cchkfrhno/cm6gr3vo20001033pc3yzg24o.png
3. step_03 [image] - Click on Add a sheet or range
   - source type: IMAGE
   - description: Click on the sheet tab to select it.
   - target: (2194.0638747889952, 128.93976048798072), rect: top=138.0625 left=2261 width=137.58334350585938 height=17.33333396911621
   - hotspots: 1
     - hotspot_01 (2194.0638747889952, 128.93976048798072), rect: top=138.0625 left=2261 width=137.58334350585938 height=17.33333396911621
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: In the protection settings panel that appears on the right, click on 'Add a sheet or range' to start specifying which sheet or range you want to protect.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gr3ayn001clg0cchkfrhno/cm6gralfh000h0cjo3t1072ok.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gr3ayn001clg0cchkfrhno/cm6gr3wzo0002033ptq8s55d7.png
4. step_04 [image] - Choose Sheet option
   - source type: IMAGE
   - description: Open the Data menu located at the top of the screen.
   - target: (2358.0625419830794, 192.1518079775849), rect: top=192.33334350585938 left=2436.75 width=39.9375 height=32
   - hotspots: 1
     - hotspot_01 (2358.0625419830794, 192.1518079775849), rect: top=192.33334350585938 left=2436.75 width=39.9375 height=32
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: Select the 'Sheet' option to specify that you want to protect an entire sheet rather than just a range of cells.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gr3ayn001clg0cchkfrhno/cm6gralg9000i0cjo9mha3mur.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gr3ayn001clg0cchkfrhno/cm6gr3y330003033p88u26amf.png
5. step_05 [image] - Choose the sheets you want to protect
   - source type: IMAGE
   - description: From the dropdown menu, select 'Protected sheets and ranges'.
   - target: (2194.003668761802, 236.90965994902265), rect: top=251 left=2249.33349609375 width=254.45834350585938 height=20
   - hotspots: 1
     - hotspot_01 (2194.003668761802, 236.90965994902265), rect: top=251 left=2249.33349609375 width=254.45834350585938 height=20
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: From the dropdown menu, choose the specific sheet you want to protect from the list of sheets available in your Google Sheets document.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gr3ayn001clg0cchkfrhno/cm6gralh1000j0cjo3wm50jqh.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gr3ayn001clg0cchkfrhno/cm6gr3zo10004033ph89r7dce.png
6. step_06 [image] - Click on Set permissions
   - source type: IMAGE
   - description: In the sidebar that appears, click on 'Add a sheet or range'.
   - target: (2344.6386959633974, 342.39396821413123), rect: top=337.3333435058594 left=2369.041748046875 width=158.95834350585938 height=36
   - hotspots: 1
     - hotspot_01 (2344.6386959633974, 342.39396821413123), rect: top=337.3333435058594 left=2369.041748046875 width=158.95834350585938 height=36
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: After selecting the sheet, click on 'Set permissions' to define who can view and/or edit the protected sheet.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gr3ayn001clg0cchkfrhno/cm6grali4000k0cjobx4a74i3.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gr3ayn001clg0cchkfrhno/cm6gr40sk0006033ppsgikfc0.png
7. step_07 [image] - Choose from the different options
   - source type: IMAGE
   - target: (1511.8335193371772, 612.7084038628473), rect: top=520.7084038628473 left=1061.1668526705105 width=450.6666666666667 height=184
   - hotspots: 1
     - hotspot_01 (1511.8335193371772, 612.7084038628473), rect: top=520.7084038628473 left=1061.1668526705105 width=450.6666666666667 height=184 style=STYLE2
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: You will see multiple permission options. You can choose to show a warning when editing, or restrict editing to only certain users.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gr3ayn001clg0cchkfrhno/cm6gralj0000l0cjo8d8sf08h.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gr3ayn001clg0cchkfrhno/cm6gr45nl0007033py5bhvz4f.png
8. step_08 [image] - Choose who can edit this sheet
   - source type: IMAGE
   - description: Set the permissions as needed by clicking on 'Set permissions'.
   - target: (1257.331241198455, 634.5457360149929), rect: top=639.375 left=1143.166748046875 width=241.375 height=20
   - hotspots: 1
     - hotspot_01 (1257.331241198455, 634.5457360149929), rect: top=639.375 left=1143.166748046875 width=241.375 height=20
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: Specify the users or groups who will be allowed to edit the sheet while others will be restricted from making changes.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gr3ayn001clg0cchkfrhno/cm6grall5000m0cjofbsuclz6.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gr3ayn001clg0cchkfrhno/cm6gr46aw0008033pmutkkqmd.png
9. step_09 [image] - Click Done button
   - source type: IMAGE
   - description: Finally, click on the 'Done' button to confirm the changes.
   - target: (1315.244666706437, 720.1818818333696), rect: top=716.7083740234375 left=1397.416748046875 width=86.08333587646484 height=36
   - hotspots: 1
     - hotspot_01 (1315.244666706437, 720.1818818333696), rect: top=716.7083740234375 left=1397.416748046875 width=86.08333587646484 height=36
   - dimensions: 1920x951 @0.75x
   - layout: 1 (full)
   - voiceover: Once you have set all desired permissions, click the 'Done' button to save and apply the protection settings to your selected sheet.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gr3ayn001clg0cchkfrhno/cm6gralmh000n0cjo6fyvgfv7.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM
   - image: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gr3ayn001clg0cchkfrhno/cm6gr46yj0009033psund9mub.png
11. [Outro] Next Steps
   - body: Now that your sheet is locked, verify that the permissions are correctly set and inform your team about the changes to avoid any confusion. If you need to make additional changes or unlock the sheet, follow the same steps in reverse.
   - voiceover: You have successfully locked the sheet. Next, you can manage other sheets or ranges, or share the document with others knowing that your data is protected.
   - audio: https://cdn.layerpath.com/cm5zam9200008kv0cjrs8mqyj/cm6gr3ayn001clg0cchkfrhno/cm6graj00000e0cjogaub51i5.mp3
   - voice: 21m00Tcm4TlvDq8ikWAM

Source: https://share.layerpath.com/share/cm6gr3ayn001clg0cchkfrhno/tour