Thread: How do I NOT copy hidden rows to a new worksheet?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Duke Carey
 
Posts: n/a
Default How do I NOT copy hidden rows to a new worksheet?
After selecting, and before copying, use Edit-Goto-Special and click
Visible Cells Only, followed by OK. Now you can copy and paste as you wish

"Steve" wrote:

I have a large spreadsheet and have hidden rows. I do not want to copy the
hidden rows into a new spreadsheet. How do I do that?
Reply With QuoteReply With Quote