Paste Special

  • Thread starter Thread starter SJT
  • Start date Start date
S

SJT

I have copied a range that includes a number of hidden rows. When I paste it
the hidden rows also appear. How do I suppress the hidden rows when I paste?
Thank you in advance for your assistance.
 
While copying do the following;

Edit->Go To->Special->Visible Cells only
Edit->Copy

Then Edit->Paste Special...
 
Back
Top