I am using a header to make my multi-page worksheet look nice when it is
printed. Unfortunately, that header only shows up when I am working with the
Excel document if I have the view set to Page Layout. That view does not work
so good when I am working with the spreadsheet.

The header contains information pertinent to the worksheet I am on, but if I
am not in the Page Layout view, I don't see it. If I choose to include the
pertinent information and just put it in a cell at the top of the worksheet,
then the information is duplicated when I print. I would like to just be able
to hide that row or cell when I print. Any way to do this?

Thanks.

OEM-Chad wrote:
I am using a header to make my multi-page worksheet look nice when it is
printed. Unfortunately, that header only shows up when I am working with the
Excel document if I have the view set to Page Layout. That view does not work
so good when I am working with the spreadsheet.

The header contains information pertinent to the worksheet I am on, but if I
am not in the Page Layout view, I don't see it. If I choose to include the
pertinent information and just put it in a cell at the top of the worksheet,
then the information is duplicated when I print. I would like to just be able
to hide that row or cell when I print. Any way to do this?

Thanks.
Search Excel help for "hide row."
Hide the row before printing, print, then unhide it.

Bill

Hi Bill,

Thanks for the advice. I actually knew about the hide row trick, but that is
a manual thing. The problem is that there will be many users opening and
printing this spreadsheet and I was kind of hoping to make that process
automatic. It would not be realistic to expect that everyone who opened it,
would know to do that.

Thanks anyway,

Chad

OEM-Chad wrote:
Hi Bill,

Thanks for the advice. I actually knew about the hide row trick, but that is
a manual thing. The problem is that there will be many users opening and
printing this spreadsheet and I was kind of hoping to make that process
automatic. It would not be realistic to expect that everyone who opened it,
would know to do that.

Thanks anyway,

Chad

Your original post didn't say anything about multiple users.

Bill

In Normal View

To have a Title row appear on each printed page go to FilePage SetupSheetRows
to repeat at top.

Enter $1:$1 or just point to row 1


Gord Dibben MS Excel MVP

On Thu, 29 May 2008 08:15:04 -0700, OEM-Chad
wrote:

I am using a header to make my multi-page worksheet look nice when it is
printed. Unfortunately, that header only shows up when I am working with the
Excel document if I have the view set to Page Layout. That view does not work
so good when I am working with the spreadsheet.

The header contains information pertinent to the worksheet I am on, but if I
am not in the Page Layout view, I don't see it. If I choose to include the
pertinent information and just put it in a cell at the top of the worksheet,
then the information is duplicated when I print. I would like to just be able
to hide that row or cell when I print. Any way to do this?

Thanks.

Hi Gord,

This could work to some extent. It is not ideal because it does not offer
the same formatting flexibility that a header offers, but I supposed if this
is the best possible option, I can work with it.

Thanks,
Chad

Don't understand what you say.

Formatting a "header" offers less flexibility than formatting cells in a row.


Gord

On Thu, 29 May 2008 08:50:03 -0700, OEM-Chad
wrote:

Hi Gord,

This could work to some extent. It is not ideal because it does not offer
the same formatting flexibility that a header offers, but I supposed if this
is the best possible option, I can work with it.

Thanks,
Chad