ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can copy only the unhide rows and paste it another sheet (https://www.excelbanter.com/excel-discussion-misc-queries/170072-how-can-copy-only-unhide-rows-paste-another-sheet.html)

svstpl

How can copy only the unhide rows and paste it another sheet
 


Stephen[_2_]

How can copy only the unhide rows and paste it another sheet
 
Please ask your question in the text of your post, not the subject.

Select all the rows in the area of interest.
Then do:
Edit Go To Special button Visible cells only
Then Copy and Paste in the normal way.

"svstpl" wrote in message
...





All times are GMT +1. The time now is 12:28 AM.

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