Keeping Certain Constant Information from being Changed/Deleted

[AlexWhite532]

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?

[#2]

@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.