Results 1 to 3 of 3

Thread: Excel

  1. #1
    Senior Member
    Join Date
    Jul 2003
    Posts
    12,116
    Thanks
    906
    Thanked
    583 times in 408 posts

    Excel

    Is it possible to print out the column headings out on each page printed.
    A bit like when u freeze a row so when u scroll down u can still see the title for that cell...?

  2. #2
    Member
    Join Date
    Jan 2004
    Location
    Berkshire
    Posts
    180
    Thanks
    1
    Thanked
    0 times in 0 posts
    Yes it's fairly easy, In Excel 2003 with the workbook open you

    Click the worksheet then in the File menu, click Page Setup, and then click the Sheet tab. Then select the Colums to repeat at the top or the row to repeat on the LHS
    Last edited by CoDa; 12-08-2004 at 10:38 AM.

  3. #3
    Senior Member
    Join Date
    Jul 2003
    Posts
    12,116
    Thanks
    906
    Thanked
    583 times in 408 posts
    Nice one, I was lookin in the right place but it was greyed out..... :beer:

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel - Office XP
    By KDH in forum Software
    Replies: 0
    Last Post: 04-08-2004, 11:08 PM
  2. Quick, boring, excel noob problem
    By klarrix in forum General Discussion
    Replies: 4
    Last Post: 19-07-2004, 07:04 PM
  3. OCR - Excel
    By Raz316 in forum Software
    Replies: 0
    Last Post: 30-04-2004, 12:05 PM
  4. Excel Form Label Errors
    By Tomahawk in forum Software
    Replies: 4
    Last Post: 08-04-2004, 03:41 PM
  5. Weird Excel Calculations
    By Allen in forum Software
    Replies: 1
    Last Post: 30-01-2004, 12:31 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •