I'm wondering if you can lock certain things on a spread sheet so they cant be changed.

Copper Contributor



I'm wanting to know if I can lock the Grid outline of a spread sheet as well as the colour of 1 column? so that it cant be changed? I need to keep a particular column highlighted, but still have the ability to input data into it. Unfortunately at times other users remove the color when highlighting a row of details then unhighlighting at a later date. Is there anything I can do to achieve this? I have added a screenshot of my spreadsheet for reference, I'm wanting to lock just the pink to that column.


Thank you 


1 Reply


You can lock certain elements in an Excel spreadsheet to prevent them from being changed by other users. Here's how you can achieve this:

  1. Locking Cells:
    • You can lock specific cells or ranges to prevent them from being edited. To do this:
      • Select the cells you want to lock.
      • Right-click on the selected cells and choose "Format Cells."
      • In the Format Cells dialog box, go to the Protection tab.
      • Check the "Locked" checkbox.
      • Click OK.
    • After you've locked the cells, you need to protect the worksheet to enforce the locking:
      • Go to the Review tab on the Excel ribbon.
      • Click on "Protect Sheet."
      • In the Protect Sheet dialog box, you can set a password if you want to restrict who can unprotect the sheet.
      • Click OK.
  2. Protecting Specific Columns:
    • If you want to protect only certain columns, you can use a combination of cell locking and worksheet protection:
      • Lock the cells in the columns you want to protect as described above.
      • Protect the entire worksheet using the "Protect Sheet" option in the Review tab.
      • In the Protect Sheet dialog box, you can specify which actions are allowed for users (such as selecting locked cells, formatting cells, etc.).
      • Make sure to uncheck the "Select locked cells" option if you want to prevent users from selecting the locked columns.
  3. Keeping Column Color:
    • Unfortunately, Excel's built-in protection features do not allow you to lock the formatting (such as cell colors) of specific columns while still allowing data input. However, you can use data validation to ensure that users input data correctly without changing the column color:
      • Select the cells in the column you want to keep highlighted.
      • Go to the Data tab on the Excel ribbon.
      • Click on "Data Validation."
      • In the Data Validation dialog box, choose "Custom" from the Allow dropdown.
      • Enter a formula to validate the input (e.g., =ISNUMBER(A1)).
      • Click OK.

By using these techniques, you can lock specific elements in your Excel spreadsheet to prevent unwanted changes while still allowing users to input data. The text was created with the help of AI.


Add. Info: Protection


My answers are voluntary and without guarantee!


Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.