Hello, I've started a new job and the Excel settings here are different than the computer I used to have.
Before, I could filter a list and copy/paste formatting into all the cells in the filtered list. When I cleared the filter, normally the cells that were just filtered are the only ones that have the formatting I just pasted.
However, instead, when I clear the filter, every cell in that range has that formatting.
Any help with updating/changing the settings for this would be great.
Thanks!
Before, I could filter a list and copy/paste formatting into all the cells in the filtered list. When I cleared the filter, normally the cells that were just filtered are the only ones that have the formatting I just pasted.
However, instead, when I clear the filter, every cell in that range has that formatting.
Any help with updating/changing the settings for this would be great.
Thanks!