By Dua Rashid March 15, 2022 11:41AM
You mightiness privation immoderate cells connected your Microsoft Excel spreadsheet to beryllium protected from editing. You tin easy fastener those cells to forestall them from being rewritten, and you tin fastener each cells oregon circumstantial ones. Let’s instrumentality a look astatine however to fastener cells successful Excel utilizing some methods.
If you instrumentality this route, Excel locks each cells connected your spreadsheet. However, locking cells has nary effect until you support the spreadsheet too. Here’s however to bash both.
Step 1: Select each cells connected your spreadsheet by pressing Ctrl + A connected your keyboard.
Step 2: Right-click connected 1 of the cells, and past click connected Format Cells. You tin besides property Ctrl + 1 connected your keyboard to execute this step.
Step 3: In the model that pops up, look nether the Protection tab to verify that each cells are locked by making definite that the Locked enactment container is checked. Click connected OK.
Step 4: With each the cells selected, spell to the Review tab from the toolbar astatine the top. Then click connected Protect Sheet.
Step 5: In the model that appears, participate a password to support your worksheet successful the blank abstraction provided. All the selected cells are present locked and protected.
You whitethorn privation lone definite cells to beryllium locked connected immoderate of your projects. Here’s however to fastener circumstantial cells successful your spreadsheet.
Step 1: If you person immoderate locked cells from erstwhile locking attempts, you request to unlock each the cells first. Start by selecting each cells by pressing Ctrl + A connected your keyboard.
Step 2: Right-click connected 1 of the cells and click connected Format Cells, oregon conscionable property Ctrl + 1 connected your keyboard.
Step 3: In the model that appears, uncheck the container nether the Protection tab that says Locked. Click connected OK erstwhile you’ve done that.
Step 4: Select the cells that you privation to fastener connected your spreadsheet.
Step 5: Right-click connected 1 of the cells and click connected Format Cells, oregon conscionable property Ctrl + 1 connected your keyboard.
Step 6: In the model that pops up, cheque the container that says Locked nether the Protection tab.
Step 7: The cells you selected are present locked but not protected. Go to the Review tab from the toolbar astatine the apical and prime Protect Sheet.
Step 8: In the model that shows up, participate a password successful the blank tract provided. You person present successfully locked and protected the cells that you selected.
- How to usage aggregate desktops connected your Mac
- How to region a representation inheritance successful Canva
- This Lenovo Chromebook is ONLY $89 contiguous — but hurry!
- How to marque a Mac surface easier to read
- How to make a drop-down database successful Excel