Hidden cells also get changed when I try to change a filtered cell
Solution 1:
And alternative to dragging the contents of a cell, you can Copy/Paste:
- Copy the first cell containing
South. - Select the cells of the 15 products to be changed.
- Hit Ctrl+K (Or F5) then click Special...
- Select "Visible cells only".
- Paste with Ctrl+V
Note: And alternate to steps 3 & 4 is to hit Alt+; (Hold down Alt when pressing ;).