Printing non-adjacent cells on a single sheet

[Steve Walker]

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

 

[Guest]

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.

 

[Steve Walker]

Hi Andy,

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

Regards,

Steve