Headings in Excel ?

  Ray5776 16:08 03 Mar 07
Locked

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.

Ray

  VoG II 16:11 03 Mar 07

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 07

Thanks for that.

  Ray5776 12:25 04 Mar 07

Thanks VoG.

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

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac