Headings in Excel ?

  Ray5776 16:08 03 Mar 2007

Hello everyone,
when using Excel I would like to know how to carry over the column headings automatically to the next page, I have tried doing it manually using copy and paste but then all columns below show errors.
I`m sure it`s easy if someone would be good enough to tell me.


  VoG II 16:11 03 Mar 2007

If you mean when you print then File > Page Setup > Sheet tab. In 'Rows to repeat at top' enter 1:2 to repeat rows 1 and 2, or 1:1 to repeat just row 1.

  megat193 22:54 03 Mar 2007

Thanks for that.

  Ray5776 12:25 04 Mar 2007

Thanks VoG.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

The Evil Within 2 review-in-progress

Photoshop CC 2018 released with new Curvature Pen and better brush tools

Camera tips to take better iPhone photos

Les meilleures applications de covoiturage 2017