In Excel, if you highlight several rows and columns, then apply formatting - say, make the text always centered- Excel propagates that formatting to everything that is highlighted. This is an easy way of keeping data in your spreadsheet readable.
I was copying something from a website and pasting it into a cell that I had pre-formatted, and it seems to turn all the formatting off. I then have to go back and reset the formatting just for that cell. It’s very clumsy. Anyone have a work around for this? TIA Mike