How can i locked cell in excel

Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon. Pictures helped. Didn't match my screen.

Incorrect instructions. Too technical. Not enough information. Not enough pictures. Any additional feedback? Submit feedback. Thank you for your feedback! Clear this check box. To prevent users from. Select locked cells. Select unlocked cells. Format cells. Format columns. Format rows. Insert columns. Insert rows. Insert hyperlinks. Delete columns. Deleting columns. Lock Cells. Lock All Cells By default, all cells are locked.

Select all cells. Chapter Protect. Download Excel File lock-cells. Next Chapter Count and Sum Functions. Select all the cells you don't want to be locked. These will be the specific cells that can be edited even after the sheet is protected. Right-click on your selection, select Format Cells, and click on the Protection tab. Alternatively, under the Home tab, click on the expansion icon next to Alignment, and in the Format Cells window go to the Protection tab.

Uncheck "Locked" which is checked by default and click OK. Any cells you didn't unlock under the Format Cells option step 3 above will be locked, while the unlocked cells will be editable:. Note that locking or unlocking specific cells won't take effect until you do step 4, protecting the sheet.

Free and premium plans. Sales CRM software. Customer service software. Content management system software. Premium plans. Operations software. Connect your favorite apps to HubSpot. See all integrations. We're committed to your privacy. HubSpot uses the information you provide to us to contact you about our relevant content, products, and services. You may unsubscribe from these communications at any time. For more information, check out our privacy policy. Written by Martina Bretous martinabretous.

Ever left something perfectly fine and came back to a total disaster? Any pet owner will probably say, " yes. At work, the same can happen when collaborating on a shared document. It's usually an accidental keyboard stroke that does it.