I can’t figure it out. I have two different background colors changed via two different cell formats on a sheet I’m constantly editing, yet when I use the bottom right box to drag, or copy and paste, that format gets replaced.
If I “protect sheet”, I have to deal with passwords which I don’t want to deal with, and seems I’m also protecting more than I want.
What am I missing?
You can leave the password blank.
For a perfect separation of data, processing, layout and formatting you need a database rather than a spreadsheet which an arithmetic calculator in the first place.
Thanks, but even leaving password blank then prevents me from changing the values in the cell.
I can’t believe nobody else has asked about this in the last two decades, and I refuse to believe you need a database for it.
All I’m asking is for simple, clear checkboxes for the protection of “cell content” and “cell formatting” separately.
Use Cell Styles instead of the manual (direct) formatting method. Then you will able to restore the cell properties in a simple way - when you modified them accidentally.
Paste Special offers Number or Formula on the right click menu. Clicking either of them won’t change the format of the receiving cell. They can be made into a keyboard shortcut in Tools > Customise > Keyboard