Pasting, but leave hidden rows out

J

j-dawg

I want to copy a worksheet with multiple hidden rows and paste to a new
worksheet without pasting all of the hidden rows as well. How can I do
this?
 
M

Michael R Middleton

j-dawg -
I want to copy a worksheet with multiple hidden rows and paste to a new
worksheet without pasting all of the hidden rows as well. How can I do
this? <
Click to expand...

Edit | Go To | Special | Visible Cells Only

Edit | Copy

new worksheet

Edit | Paste

- Mike

www.mikemiddleton.com
 
J

JE McGimpsey

Select the range you want to copy. Choose Edit/Goto/Special and select
the Visible cells only radio button. Click OK.

Copy and Paste.
 
Top