Filter, clearing visible cells in a range, but leaving hidden cells

J

Jason Chapman

Hi,

I have a filtered worksheet. I want to be able to select a range and
clear the contents OR paste into the visible cells. Trouble is it
clears all of the cells in the range, visible or invisible.

Is there a way round this?

TIA
 
R

Ron de Bruin

Hi Jason

After you select the range use
Alt ; or F5>Special>Visible cells only>OK to select only the Visible cells.
 
J

Jason Chapman

Ron said:
After you select the range use
Alt ; or F5>Special>Visible cells only>OK to select only the Visible
cells.
Click to expand...
AMAZING - thank you, that will save me ages. Works a treat.
 
Top