Separate formatting layer
It would be nice if after setting up the format of my table (color of certain cells, different fonts borders), I could hit a button and it would "freeze" the formatting and when I copy, move or drag down some cells to some cells with different formatting, the original formatting of the destination ell would remain. I know such option is possible by using Paste special, but when I'm doing this with hundreds of cells, it matters a lot whether I have to make 4 clicks per cell or just one
I just posted about it on twitter: https://twitter.com/dave_stewart/status/1066738359593250821
A layers system which would allow to work on any of the below:
- borders / styles
- conditional formatting
- print area
That way, we could drag cells around to our heart's content without constantly having to think about how to preserve styling.
Additionally, there could be some kind of list on the right when editing a layer which show you a list of all the individual entities (ranges, styles, etc) on that layer so you could edit by clicking and editing rather than needing to reselect the whole range.