Paste Special
 

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.

Paste Special
 

While copying do the following;

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

Then Edit-Paste Special...

"SJT" wrote:

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.

Paste Special
 

Thank you Sheelo.

"Sheeloo" wrote:

While copying do the following;

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

Then Edit-Paste Special...

"SJT" wrote:

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.

Paste Special
 

You are welcome and thanks for your feedback.

Pl. mark the post as answered.

"SJT" wrote:

Thank you Sheelo.

"Sheeloo" wrote:

While copying do the following;

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

Then Edit-Paste Special...

"SJT" wrote:

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.