ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   HOW DO I PREVENT HIDDEN CELLS FROM DISPLAYING WHEN I COPY (https://www.excelbanter.com/excel-discussion-misc-queries/14603-how-do-i-prevent-hidden-cells-displaying-when-i-copy.html)

Tes

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

"Tes" wrote in message
...




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 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