+ Reply to Thread
Results 1 to 2 of 2

how to get some rows and columns on every printed page

  1. #1
    helpwithXL
    Guest

    how to get some rows and columns on every printed page

    Hi all,
    Could someone please tell me how can I have a fixed number of rows and
    columns printed on every printed page? by this i mean that i want to
    have the first 5 rows (which contain calendar info like
    year,month,calendar week etc) and first 2 columns ( which have project
    names in first row and persons associated to that project in 2nd row)
    of my excel sheet in all the printed pages.
    i have a big excel sheet with 80-100 columns and 400-500 rows and
    largest sheet available to me for printing is A3. so when i try to
    print this my excel sheet, the first 5 rows and 2 columns only get
    printed in the first printed sheet and not on the subsequent printed
    sheets(so this is the normal or defualt print behaviour) and so i have
    to always need the first printed sheet to find out, for example, a
    month or a calendar week for printed sheets 2 onwards.
    so basically i want the first 5 rows and 2 columns to be printed on
    every printed sheet, something like top header and left header.
    Can someone guide me in the right direction please.
    TIA
    amit


  2. #2

    Re: how to get some rows and columns on every printed page

    Hi
    Look in File, Page SetUp... and choose the Sheet Tab. You will see the
    settings there.

    regards
    Paul


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1