Headings in Excel ?

  Ray5776 16:08 03 Mar 07

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 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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

VFX Oscar nominees 2017: Discover how the visual effects were created

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…