ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do you print selected columns on one page? (https://www.excelbanter.com/excel-discussion-misc-queries/45146-how-do-you-print-selected-columns-one-page.html)

Roadhand

How do you print selected columns on one page?
 
I want to print columns that are not adjacent to each other. Currently Excel
wants to print each selection as a separate page. I want to print on one
page. Is there a way to do this?

Gord Dibben

Road

Hide the intervening columns.

Excel will print only the visible columns.


Gord Dibben Excel MVP

On Tue, 13 Sep 2005 09:46:39 -0700, "Roadhand"
wrote:

I want to print columns that are not adjacent to each other. Currently Excel
wants to print each selection as a separate page. I want to print on one
page. Is there a way to do this?



Dave Peterson

If you hide the columns that separate the ranges, then you'll be ok.



Roadhand wrote:

I want to print columns that are not adjacent to each other. Currently Excel
wants to print each selection as a separate page. I want to print on one
page. Is there a way to do this?


--

Dave Peterson

Roadhand

Thanks, that worked fine...appreciate your assistance.

"Dave Peterson" wrote:

If you hide the columns that separate the ranges, then you'll be ok.



Roadhand wrote:

I want to print columns that are not adjacent to each other. Currently Excel
wants to print each selection as a separate page. I want to print on one
page. Is there a way to do this?


--

Dave Peterson


Roadhand

Thank you for your assistance, your suggestion worked fine.

"Gord Dibben" wrote:

Road

Hide the intervening columns.

Excel will print only the visible columns.


Gord Dibben Excel MVP

On Tue, 13 Sep 2005 09:46:39 -0700, "Roadhand"
wrote:

I want to print columns that are not adjacent to each other. Currently Excel
wants to print each selection as a separate page. I want to print on one
page. Is there a way to do this?





All times are GMT +1. The time now is 08:46 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com