Forum Discussion
Keeping Certain Constant Information from being Changed/Deleted
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?
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.
