+ Reply to Thread
Results 1 to 2 of 2

How to I set up a sheet to print colums/rows on every page in exce

  1. #1
    Michelle
    Guest

    How to I set up a sheet to print colums/rows on every page in exce

    I have a spreadsheet in excel and want several rows and columns to print on
    every page. It will display by freezing panes but I need it to print that
    way also.

  2. #2
    David McRitchie
    Guest

    Re: How to I set up a sheet to print colums/rows on every page in exce

    see http://www.mvps.org/dmcritchie/excel/freeze.htm

    file, page setup, sheets,
    Rows to Print at top: $1:$2
    columns to print at left: $A:$A
    ---
    HTH,
    David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
    My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
    Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

    "Michelle" <[email protected]> wrote in message news:[email protected]...
    > I have a spreadsheet in excel and want several rows and columns to print on
    > every page. It will display by freezing panes but I need it to print that
    > way also.




+ 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