Any way to hide a cell or row from printing?

[OEM-Chad]

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.

 

[Bill Sharpe]

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

 

[Gord Dibben]

In Normal View

To have a Title row appear on each printed page go to File>Page Setup>Sheet>Rows
to repeat at top.

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


Gord Dibben MS Excel MVP

 

[OEM-Chad]

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]

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

 

[Gord Dibben]

Don't understand what you say.

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


Gord

 

[Bill Sharpe]

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