Printing non-adjacent cells on a single sheet

I'm no Excel expert so I'm hoping someone here can help
me.

I need to print non-adjacent cells / ranges in an MS
Excel worksheet onto a single sheet. It is possible to
select rages and set the print area to include those
ranges; the problem being though is that each range is
printed on a separate sheet. The only way I've found to
get the various ranges to print on a single sheet is to
hide the columns separating the ranges. I want to avoid
having to hide unwanted cells each time we want to print
a separate report. It's a spreadsheet that serves many
uses and I'd like to be able to name a range / ranges and
just print those out as a report; separate pages is no
good.

Thanks

Steve

Hi

It sounds like you need View / Custom View - where you can set up a number
of custom settings - including printing and hidden rows/columns.

--
Andy.


"Steve Walker" wrote in message
...
I'm no Excel expert so I'm hoping someone here can help
me.

I need to print non-adjacent cells / ranges in an MS
Excel worksheet onto a single sheet. It is possible to
select rages and set the print area to include those
ranges; the problem being though is that each range is
printed on a separate sheet. The only way I've found to
get the various ranges to print on a single sheet is to
hide the columns separating the ranges. I want to avoid
having to hide unwanted cells each time we want to print
a separate report. It's a spreadsheet that serves many
uses and I'd like to be able to name a range / ranges and
just print those out as a report; separate pages is no
good.

Thanks

Steve

Hi Andy,

Thanks for your reply. We'll give it a go.

Regards,

Steve
-----Original Message-----
Hi

It sounds like you need View / Custom View - where you
can set up a number
of custom settings - including printing and hidden
rows/columns.

--
Andy.


"Steve Walker"
wrote in message
...
I'm no Excel expert so I'm hoping someone here can help
me.

I need to print non-adjacent cells / ranges in an MS
Excel worksheet onto a single sheet. It is possible to
select rages and set the print area to include those
ranges; the problem being though is that each range is
printed on a separate sheet. The only way I've found
to
get the various ranges to print on a single sheet is to
hide the columns separating the ranges. I want to
avoid
having to hide unwanted cells each time we want to
print
a separate report. It's a spreadsheet that serves many
uses and I'd like to be able to name a range / ranges
and
just print those out as a report; separate pages is no
good.

Thanks

Steve


.