HOW DO I PREVENT HIDDEN CELLS FROM DISPLAYING WHEN I COPY

[JulieD]

Hi Tes

select the range you want to copy, choose edit / goto / special - choose
visible cells only
then copy
then paste as normal

cheers
JulieD

 

[Peo Sjoblom]

Using all caps is considered rude and posting the question in the subject
line likewise

http://www.cpearson.com/excel/newposte.htm

use goto>special and visible cells only when copying


--

Regards,

Peo Sjoblom
`