Text Formatting For Printout and Proper Case

[OldGuy]

Excel 2003 (no I do not want to use any other version, that is what I
have and I am used to it, sort of)

Two Questions

1) page print formatting
I have a list with three columns.
Approx 50 rows.

I increase the font size to make the text print bigger.

I want a single page only.

I want the columns to flow portrait mode from top to bottom for approx
25 rows then print another set of three columns and continue printing
on the same page for the rest. This results in six columns.

How do I set this up?

2) Proper Case.
how do I reformat text to proper case?

TIA



--- news://freenews.netfront.net/ - complaints: (e-mail address removed) ---

 

[OldGuy]

sorry for the double post. my newsgroup hung and had to use a friends
PC to send, then the first broke loose from freenews.netfront.net.
Been having too many problems with that. any newsgroups suggestions?



--- news://freenews.netfront.net/ - complaints: (e-mail address removed) ---

 

[joeu2004]

sorry for the double post. my newsgroup hung
and had to use a friends PC to send, then the
first broke loose from freenews.netfront.net.
Been having too many problems with that.
any newsgroups suggestions?

I use news.eternal-september.org. The only problem: occassionally it
refuses the connection with an error something to the effect of "connected
too many times", which is obviously not the case. But I rarely have a
problem after establishing a connection.

However, your problem might have less to do with the news server and more to
do with your local network or ISP. So it might not help to change newsgroup
provider.

 

[joeu2004]

1) page print formatting
I have a list with three columns.
Approx 50 rows.
I increase the font size to make the text print bigger.
I want a single page only.
I want the columns to flow portrait mode from top to bottom for approx
25 rows then print another set of three columns and continue printing
on the same page for the rest. This results in six columns.
How do I set this up?

Have you tried simply selecting Fit To: 1 page wide by 1 page tall?

Click on File, Page Setup, Page, and select the Fit To option under Scaling.

 

[Claus Busch]

Hi Joe,

Have you tried simply selecting Fit To: 1 page wide by 1 page tall?

with that option you can make a bigger print area smaller but not a
small print area bigger.
And "Adjust to" will not work because 50 rows in 3 columns are 1 page
high or 25 rows in 6 columns are 1 page wide.


Regards
Claus B.

 

[joeu2004]

Hi Joe,

with that option you can make a bigger print area smaller
but not a small print area bigger.
And "Adjust to" will not work because 50 rows in 3 columns
are 1 page high or 25 rows in 6 columns are 1 page wide.

My bad! Good catch!

I remembered that I had used Page Setup for similar purposes. I guess it
was Adjust To percentage, not Fit To.

As for the limitation of printing 50 rows....

Generally, you are correct.

But by setting margins and footer spaces to 0, I can increase the normal
default Arial 10-point font by 20%.

(That is, I set Adjust To 20%. I usually do not trust Microsoft products to
do exactly what we specify.)

Alternatively, select a cell font size that is too large for the page, and
use Adjust To 1 wide and 1 tall, as I suggested before.

Nevertheless, arguably, that is not sufficient for the OP's purposes. It
was good to point out that 50 rows is close to the limit of a normal
8.5-by-11 page. I had overlooked that detail.