Keeping Certain Constant Information from being Changed/Deleted

Occasional Visitor

Hi,

I'm creating an estimation worksheet for painting, and I have certain titles and such that I will never change. I want to know if there's a way to keep all these things from being deleted, but I can delete all of the other information I input with "Select All" + "Delete"?

 

I'm not sure how to attache a picture, so I'll have to explain what I'm dealing with as best I can:

So, let's say I have 5 columns that all have 10 rows, each with a title:

"Height" - "Width" - "Length" - "Feet" - "Inches"

(these are arbitrary names)

 

Let's also say that my "Width" column is always going to be 5 in every row:

:WIDTH:

5

5

5

5

5

5

5

5

5

5

...and I never wanted that 5 to change, either.

So, everything that I have so far will never change, but all OTHER information that I input, I want to be able to delete it all at the same time by "Select All" + "Delete" without worrying about the constant stuff mentioned above being affected.

 

Is there a way to do this?

1 Reply

@AlexWhite532 

Not quite, but you can do the following:

  • Select the entire sheet.
  • Press Ctrl+1 to activate the Format Cells dialog.
  • Activate the Protection tab.
  • Clear the Locked check box.
  • Click OK.
  • Select all cells that should never be changed.
  • Press Ctrl+1 to activate the Format Cells dialog again.
  • Activate the Protection tab.
  • Tick the Locked check box.
  • Click OK.
  • Activate the Review tab of the ribbon.
  • Click 'Protect Sheet'.
  • Use the check boxes to specify what the users will be allowed to do.
  • At the very least, leave the 'Select unlocked cells' check box ticked.
  • If you want to specify a password that will be needed to unprotect the sheet, enter it in the Password box. Don't forget it.
  • Click OK.
  • If you specified a password, enter it again as confirmation.
  • Save the workbook.