I use the fill handle (bottom right corner of the cell) to drag and copy the formula over to the cells on the right (let's say, copied 100 cells, 80 visible and 20 hidden). When I do that, I only want to update the visible cells, and don't want to update the hidden cells.
Is there any settings I can use to skip those hidden cells?
Thanks for the help.
Is there any settings I can use to skip those hidden cells?
Thanks for the help.