copy and past Rows with exception of Hidden Rows

M

Molly

Select the data you want to copy and copy it into the
clipboard. Include hidden rows or filtered data as
needed to include all visible data you want to copy.

Then use EDIT - PASTE SPECIAL

Assuming you wish to transfer your formulas, select radio
button for "Paste Formulas and Number Formats". This
will copy only the visible parts of your original data
selection and keep your data formats.

Hope this helps!
 
G

Gail

This actually will paste all rows -- not just the visible ones

To copy and paste only the visible, you need to select the area, F5 -Special-
toggle visible cells only, then paste or paste special
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy/Paste with Hidden Rows/Columns Excel 2007 3
COPY PASTE VALUES ONLY FROM/ON VISIBLE CELLS 6
Copy and pasting values of filtered rows 1
Copy and paste - filtered data 2
Copy and Paste with hidden columns remaining hidden 2
Copy (Formulas and Formatting ONLY) no values to other rows 1
copy and paste range of cells excluding hidden data in excel 3
copy rows and paste onto visible only 2

Top