When I filter out a row in excel, if I edit the entire range (including the cell that is filtered out), only visible cells get edited. When my boss does this on his computer, the entire range gets edited, including what is hidden... There must be an option somewhere to change this.
A more visual example: Here are some cells:
A 1 1 2 0 3 0 4 1
If I filter column A to only keep the 1s, here is what I get:
A 1 1 4 1
I now select everything (the 1s) and I type ZZZ and press CTRL + ENTER to edit the entire range. I now unhide everything, here is my result:
A 1 ZZZ 2 0 3 0 4 ZZZ
Here is my boss's result:
A 1 ZZZ 2 ZZZ 3 ZZZ 4 ZZZ
What setting do I have to edit to make it so that we have the same answer?