This should be an easy task, but somehow I'm struggling.

My spreadsheet has three pages. I have tried to mark
off the pages by adding page breaks and setting the print
area equal to all three pages. I even played around with
the "Scale to Fit" options in Excel 2010.

I am marking each page with page breaks. What settings
will force Excel to print each page on one sheet of paper
at 100% scale?? Thanks

Robert

This should be an easy task, but somehow I'm struggling.

My spreadsheet has three pages. I have tried to mark
off the pages by adding page breaks and setting the print
area equal to all three pages. I even played around with
the "Scale to Fit" options in Excel 2010.

I am marking each page with page breaks. What settings
will force Excel to print each page on one sheet of paper
at 100% scale?? Thanks

Robert

That can only happen if the 3 pages fit at 100% zoom. Otherwise, clear
the pagebreaks and the Fit To pages wide, then specify pages tall. This
work better when all 4 margins are minimal!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

"GS" wrote:

That can only happen if the 3 pages fit at 100% zoom. Otherwise, clear the
pagebreaks and the Fit To pages wide, then specify pages tall. This work
better when all 4 margins are minimal!


Do you mean I should clear the the "Fit To" pages wide?
How do I specify pages tall? Also, are these options that you're
talking about available in the Page Setup dialog box?

"GS" wrote:

That can only happen if the 3 pages fit at 100% zoom. Otherwise,
clear the pagebreaks and the Fit To pages wide, then specify pages
tall. This work better when all 4 margins are minimal!


Do you mean I should clear the the "Fit To" pages wide?
How do I specify pages tall? Also, are these options that you're
talking about available in the Page Setup dialog box?

Yes, these are in page setup. (Sorry for assuming you knew this!)

After posting I thought it might be better to specify 1 pages wide so
you don't get rightmost columns printig on another page.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

"GS" wrote:

Do you mean I should clear the the "Fit To" pages wide?
How do I specify pages tall? Also, are these options that you're
talking about available in the Page Setup dialog box?

Yes, these are in page setup. (Sorry for assuming you knew this!)


It's all good. I'm still learning all the minute details of MS Office and
VBA programming.


After posting I thought it might be better to specify 1 pages wide so you
don't get rightmost columns printig on another page.


Okay, I will play with that too. I was basically trying all different
combinations of settings on the Page Layout bar and I was struggling
to print each page at 100% scale on a single sheet. I will see how your
suggestions work today. Thanks again.

Hi Robert,

Am Mon, 1 Dec 2014 14:46:27 -0700 schrieb Robert Crandal:

Do you mean I should clear the the "Fit To" pages wide?

with FitToPages you can shrink a bigger area to one page. But if you
want a smaller area on one page you have to zoom.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

On 01/12/2014 20:15, Robert Crandal wrote:
This should be an easy task, but somehow I'm struggling.

My spreadsheet has three pages. I have tried to mark
off the pages by adding page breaks and setting the print
area equal to all three pages. I even played around with
the "Scale to Fit" options in Excel 2010.

I am marking each page with page breaks. What settings
will force Excel to print each page on one sheet of paper
at 100% scale?? Thanks

Designing the layout so that it fits the actual paper size?

I find it hard to see your problem. You can force scaling at the expense
of legibility to fit A3 sized content onto A4 if you want or any other
scale ratio you like.

The only problem I ever had with Office 2007 was that when printing to
A3 paper the first page in a session was fine but after that to get A3
physical printing output you had to select 6x4 postcard paper size.

(and inevitably I would forget from time to time)

--
Regards,
Martin Brown

"Martin Brown" wrote:

Designing the layout so that it fits the actual paper size?


Our spreadsheet is already pre-designed, so I'm trying to
work with what is provided.

I find it hard to see your problem. You can force scaling at the expense
of legibility to fit A3 sized content onto A4 if you want or any other
scale ratio you like.


Yes, I would like to force scaling at the expense of legibility, I just
can't seem to find the right combination of settings to accomplish this.

The best settings that are working for me right now are as follows:

* Set page breaks (to delineate the end of each page)
* Set width to 1 page
* Set height to auto
* Set "Fit to" to 1 page wide by ___ tall

My goal is to delineate the areas of the three pages, and print
each page on one sheet of 11 x 8.5 paper, preferably scaled at
100% on the printed page. Got any specific suggestions?

(BTW, I know Gary suggested that I remove the page breaks,
but that didn't work, so I added the page breaks again.)

"Martin Brown" wrote:

Designing the layout so that it fits the actual paper size?


Our spreadsheet is already pre-designed, so I'm trying to
work with what is provided.

I find it hard to see your problem. You can force scaling at the
expense of legibility to fit A3 sized content onto A4 if you want
or any other scale ratio you like.


Yes, I would like to force scaling at the expense of legibility, I
just
can't seem to find the right combination of settings to accomplish
this.

The best settings that are working for me right now are as follows:

* Set page breaks (to delineate the end of each page)
* Set width to 1 page
* Set height to auto
* Set "Fit to" to 1 page wide by ___ tall

My goal is to delineate the areas of the three pages, and print
each page on one sheet of 11 x 8.5 paper, preferably scaled at
100% on the printed page. Got any specific suggestions?

(BTW, I know Gary suggested that I remove the page breaks,
but that didn't work, so I added the page breaks again.)

Remove the pagebreaks AND set 1 pages wide by 3 pages tall! Adjust page
margins to render maximum scale. Note that any pagebreaks you set
should be ignore when using the pages wide x pages tall option anyway,
but if your predesigned template must print 3 pages max then 1 x 3 will
do that consistently! (Not sure why this wasn't built into the sheet at
design time??)

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

"GS" wrote:

Remove the pagebreaks AND set 1 pages wide by 3 pages tall! Adjust page
margins to render maximum scale. Note that any pagebreaks you set should
be ignore when using the pages wide x pages tall option anyway, but if
your predesigned template must print 3 pages max then 1 x 3 will do that
consistently!

I will give this a try today. But....

If I set it to 3 pages tall, how will Excel know the begining and end of
each of my pages? Our first two pages have 50 rows of data, while
the last page has 30 rows of data.

I probably need to re-design each sheet, right?


(Not sure why this wasn't built into the sheet at design time??)


The sheet was designed by someone else who only had a basic understanding
of Excel. They wanted to get rid of paper forms and go digital. I don't
think they considered that sometimes we do need to print out a paper
inventory form.

"GS" wrote:

Remove the pagebreaks AND set 1 pages wide by 3 pages tall! Adjust
page margins to render maximum scale. Note that any pagebreaks you
set should be ignore when using the pages wide x pages tall option
anyway, but if your predesigned template must print 3 pages max
then 1 x 3 will do that consistently!

I will give this a try today. But....

If I set it to 3 pages tall, how will Excel know the begining and end
of
each of my pages? Our first two pages have 50 rows of data, while
the last page has 30 rows of data.

If your pages are all on 1 sheet then you're s.o.l.! Each sheet will be
1/3 the total print area between top/bottom margins. Perhaps better to
break this into 3 sheets where 1/2 print 1x1 and 3 goes 'as is'!

This is a typical scenario for me when users want to convert a 2-sided
legal size form to letter size. Usually some re-design is involved,
though, since the authors of the original forms I get typically know
nothing about forms design. I've been designing forms for over 35 years
and so it's not hard to submit revisions that most always get approved.

I probably need to re-design each sheet, right?

Please clarify what you mean by "each sheet"!


(Not sure why this wasn't built into the sheet at design time??)


The sheet was designed by someone else who only had a basic
understanding
of Excel. They wanted to get rid of paper forms and go digital. I
don't
think they considered that sometimes we do need to print out a paper
inventory form.

If you upload to a site and post a download link where I can obtain
both (original form and the XLT designed to replace it), I'll have a
look at it and see what I can do with.

I'm 100% in favor of reducing paper, but I understand that
circumstances needing printouts will always happen in my lifetime!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

"GS" wrote:

Please clarify what you mean by "each sheet"!


My mistake. All our data is only on one sheet.
That sheet has 3 areas. These 3 areas have the
following (approx) dimensions:

15 cells wide by 40 cells high
15 cells wide by 40 cells high
15 cells wide by 30 cells high

My goal is to somehow print these three areas
at 100% scale on it's own page.


If you upload to a site and post a download link where I can obtain both
(original form and the XLT designed to replace it), I'll have a look at it
and see what I can do with.


I wont be able to upload the actual sheet from work, but I
will try to create a generic replica soon.

"GS" wrote:

Please clarify what you mean by "each sheet"!


My mistake. All our data is only on one sheet.
That sheet has 3 areas. These 3 areas have the
following (approx) dimensions:

15 cells wide by 40 cells high
15 cells wide by 40 cells high
15 cells wide by 30 cells high

My goal is to somehow print these three areas
at 100% scale on it's own page.

So you mean 1x1 and not 1x3? Then the total height of all 3 areas must
be within the boundaries of your paper size tall.

What was the purpose of the pagebreaks, then? Now I'm confused as to
what you want to accomplish!!


If you upload to a site and post a download link where I can obtain
both (original form and the XLT designed to replace it), I'll have
a look at it and see what I can do with.


I wont be able to upload the actual sheet from work, but I
will try to create a generic replica soon.

Can you print the original form doc to PDF for upload?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

"GS" wrote:

Can you print the original form doc to PDF for upload?


Here is an example in PDF format:
https://drive.google.com/file/d/0B3I...ew?usp=sharing

Here is an example in Excel format:
https://drive.google.com/file/d/0B3I...ew?usp=sharing


You will see three areas one sheet. One pink area, one blue area,
and one green area. I'm trying to print each region on it's own page,
preferably at 100% scale. Hopefully that is clear now. Sorry
about the confusion.

"Robert Crandal" wrote:

Here is an example in PDF format:
https://drive.google.com/file/d/0B3I...ew?usp=sharing

Here is an example in Excel format:
https://drive.google.com/file/d/0B3I...ew?usp=sharing



I forgot to mention, these are not the actual sheets. I tried my best
to create a replica, and it might not be exact.

I just want to print each colored region on it's own page.
I hope it's somewhat more clear now.

"Robert Crandal" wrote:

Here is an example in PDF format:
https://drive.google.com/file/d/0B3I...ew?usp=sharing

Here is an example in Excel format:
https://drive.google.com/file/d/0B3I...ew?usp=sharing



I forgot to mention, these are not the actual sheets. I tried my
best
to create a replica, and it might not be exact.

I just want to print each colored region on it's own page.
I hope it's somewhat more clear now.

A pagebreak at row1 of the 2nd/3rd section should do what you want so
long as the cell heights are as depicted. The pages print at 100%
without messing with anything other than where pagebreak occurs. Note
that orientation is landscape. Pages 1/2 had 40 rows, p3 had 30.
Neither section fills the pages as per your samples.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion