Can you protect certain cells in excel

In addition to protecting workbooks and worksheets, you can also protect formulas. If you want to lock cells or protect specific areas, click Open in Excel and lock cells to protect them or lock or unlock specific areas of a protected worksheet. You can always ask an expert in the Excel Tech Community or get support in the Answers community.

Lock or unlock specific areas of a protected worksheet. Protect a worksheet. Protect a workbook. Display or hide formulas. Follow these steps to lock cells in a worksheet: Select the cells you want to lock.

Need more help? Expand your skills. Thanks again. I want to lock indivisual column and row. Thank you!!!!!!!!! It helped me a lot. Now I am able to work on excel sheet in the safe mode. Shelford S. Thank you so much for the nice assistance. Thanks for the information.

May need to clarify 6 as I found it better if I unchecked one additional box. Brilliant tutorial!! Thank you very much. After looking at several tutorials on this subject, all of which were very confusing, I found this one. I followed the tutorial step by step and it works great. Thank you for making it so easy for this old timer that is high tech deficient. It is a nice and crispy description. I like it. After going through this process of locking specific cells and protecting the sheet with a password, height and length of the rows and columns respectively of the sheet can't be changed.

Any way out? Need help urgently. Thousand thanks for this easy to follow guide in locking the specific cells in Microsoft Excel.

It really works.. I was searching for the same for so many days. Thank u. It's great help in very easy steps without confusing the user. I understand how to protect a worksheet, and I know how to "unlock" certain cells in a worksheet, so that users of the worksheet can enter information into these unlocked cells. I have a worksheet where all I want the users to be able to do in certain cells is to be able to 'put in or insert' numbers.

I don't want the users of this worksheet to be able to change the font, font color, font size, borders, etc. In other words, I want to create a worksheet where only numbers can be entered into certain cells, but no changes whatsoever can be made to the cell formatting of these cells. Thanks for your assistance. 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. Delete rows. Deleting rows. Use AutoFilter. Using the drop-down arrows to change the filter on ranges when AutoFilters are applied. Users cannot apply or remove AutoFilters on a protected worksheet, regardless of this setting. Use PivotTable reports.

Edit objects. Doing any of the following: Making changes to graphic objects including maps, embedded charts, shapes, text boxes, and controls that you did not unlock before you protected the worksheet. By default, when you protect cells in a sheet or workbook, all of the cells will be locked. This means they can't be reformatted or deleted, and the content in them can't be edited. By default, the locked cells can be selected, but you can change that in the protection options.

Click Protect Sheet. In the Protect Sheet window, enter a password that's required to unprotect the sheet optional and any of the actions you want to allow users.

The cells can only be unlocked when the sheet is unprotected by going to the Review tab again, choosing "Unprotect Sheet," and entering the password, if required. There might be times when you want to lock certain cells from being changed but still allow users to adjust other cells in a worksheet.