Results 1 to 3 of 3

Thread: Excel 97

  1. #1
    2 Star Lounger
    Join Date
    Feb 2003
    Location
    Melbourne, Victoria, Australia
    Posts
    139
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel 97

    Hi all
    I use Excel 97 from Office 97 on Windows 95.
    This is my first post, and I hope somebody here can help me.

    I am preparing monthly business activity reports.

    The recipients would like the Header and Footers to be in a different colour to that in the body of the reports.

    We have a HP Laserjet 4500 Colour printer.

    Can I apply colour formatting to Headers and Footers?

    Regards
    Michael

    [img]/w3timages/icons/crazy.gif[/img]

  2. #2
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Excel 97

    It's been awhile since I've thought about this - but couldn't zinger use a cell reference (formatted cells) for his header/footer. you know - like the 1-2-3 workaround![img]/w3timages/icons/laugh.gif[/img]
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excel 97

    You can use a range of cells as a header (with all their formatting), but as far as I know there is no way to use a range as a footer. You need to have a seperate range for each worksheet, ie you can't have a standard header this way.

    To use 1 or more rows as a header, you need to give them a range name of Print_Titles. Just select the rows you want (by clicking on the first row number at the left, holding the mouse button down, and dragging down until you have all of the rows you want). Then go to the Insert menu and select Name>Define. Type Print_Titles and click on Add, and then Close.

    These rows will now appear at the top of every page for that worksheet. As I said, you need to define these for every worksheet.

    Jon

Posting Permissions

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