Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Oct 2002
    Posts
    47
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Make First 2 Columns Appear on Every Printed Page (2003)

    Is there an easy way (other than copy/paste and fit) to have the first two columns of a fairly large spreadsheet appear on every printed page as the first two columns of those pages? The first two columns contain the identification data for the reports and it would be a lot easier to read if that ID data were on every page similar to how Headers & Footers would look but on the left side instead.
    Thank You

  2. #2
    3 Star Lounger
    Join Date
    Dec 2000
    Location
    Vancouver, Br. Columbia, Canada
    Posts
    268
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Make First 2 Columns Appear on Every Printed Page (2003)

    File | Page Setup | Sheet tab | Columns to repeat at left
    (use "Rows to repeat at top" for page headers).

  3. #3
    Lounger
    Join Date
    Oct 2002
    Posts
    47
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Make First 2 Columns Appear on Every Printed Page (2003)

    Thank you Dean.

Posting Permissions

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