HOW DO I PREVENT HIDDEN CELLS FROM DISPLAYING WHEN I COPY
|
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 "Tes" wrote in message ... |
Using all caps is considered rude and posting the question in the subject
line likewise http://www.cpearson.com/excel/newposte.htm use gotospecial and visible cells only when copying -- Regards, Peo Sjoblom ` "Tes" wrote in message ... |
All times are GMT +1. The time now is 03:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com