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

  • Thread starter Thread starter Jason Chapman
  • Start date Start date
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
 
Hi Jason

After you select the range use
Alt ; or F5>Special>Visible cells only>OK to select only the Visible cells.
 
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.
 
Back
Top