Excel Print Problem

[thefox149]

Hi guys Hopefully one of you guys can lend a hand

I have a couple of named ranges in excel the named range is
8 columns long (A:H) . I have another named range 8 Col long (J:Q) and another in (R:X)

I want to Print all on one page going down then over

So it would look like this

(A:H) (R:X)
(J:Q)

but what I am getting is (A:H) (J:Q) (R:X)in ver small font (damn print to fit)

This is dynamic data and every month another line is added to the report. Is is a formating issue or should this data be stacked on top of one another to begin with (hopefully not the answer as this data is being pulled from various Access Queries and uses different groupings etc so stacking the queries side by side is much easier)

 

[PHV]

what I am getting is (A:H) (J:Q) (R:X)in ver small font
Even in Landscape orientation ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[SkipVought]

If your Print Range is

(A:H) (R:X)
(J:Q)

1) it certainly WILL be very small font to fit on 1 page!

(65,536 rows by 23 columns on 1 page????)

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}

 

[thefox149]

Even when Print Area is selected it is very small

May I should insert another worksheet
that can format the data
like so


(A:H)
(J:Q)
(R:X)

Can I Call a named range in another worksheet and format it ??

 

[thefox149]

solved the problem with this create piece of work

http://www.tek-tips.com/faqs.cfm?fid=1161

 

[SkipVought]

I should have remembered Dale Watson's EXCELLENT FAQ from Waaaaaaaay back in 2001.

Be sure to RATE his FAQ as feedback to others, if this was valuable to you.

Skip,

_{[red]Be Advised![/red]
The band of elderly oriental musicians, known as Ground Cover, is, in reality...
Asian Jasmine!}