Sep 21 2022 12:06 PM
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?
Sep 21 2022 02:07 PM
Not quite, but you can do the following: