copy to another tab headers and then 20 rows down

[freshfruit]

Hello. If I would like to copy and paste the headers (frozen screen) in a tab AND a table 20 rows down how would I do that. When I try to copy and paste it takes the header and all the rows in between.

[alansidman]

Try this:

Highlight the range above the freeze. Hold down the control key. Now highlight the table below while holding down the ctl key and then copy. both ranges should get the dancing ants.