ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I exlude hidden cells when copying data (https://www.excelbanter.com/excel-discussion-misc-queries/38055-how-do-i-exlude-hidden-cells-when-copying-data.html)

Bully Ram

How do I exlude hidden cells when copying data
 
I have a spreadsheet with some hidden columns. I want to copy and paste only
the columns that I can see. How do I achieve this.

Earl Kiosterud

Bully,

First select your range. Edit - Go to - Special - Visible Cells only. Now
copy and paste.
--
Earl Kiosterud

"Bully Ram" <Bully wrote in message
...
I have a spreadsheet with some hidden columns. I want to copy and paste
only
the columns that I can see. How do I achieve this.





All times are GMT +1. The time now is 03:32 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com