copy and past Rows with exception of Hidden Rows

  • Thread starter Thread starter Molly
  • Start date Start date
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!
 
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
 
Back
Top