Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Printing using only one page 2

Status
Not open for further replies.

michel392

Programmer
Dec 17, 2001
54
BR
I have a single Lotus worksheet with the following content:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15
(each number in a cell: number 1 in the A column, number 2 in the B column, etc)
But when I go to print it uses 2 pages: one line in page 1 (for columns A to J, which prints numbers 1 to 10) and one line in page 2 (for columns K to O, which prints numbers 11 to 15).

I would like to print all in only one page. How to do that ?
I tried for hours but did not get the solution !
Thanks.
Michel
 
When you go into print preview, there is a margins,orientation, and placement tab. (a page with a ruler across it.)
You could try changing the "orientation" to landscape, or going to "page fit" and choosing fit all to page or fit columns to page as appropriate.
 
drdebit:
I had already changed the printer orientation to landscape, but I do not want to choose "page fit" because the characters will be so small to read.
The problem is that it prints just one line in each of the two pages. I would like it to be printed in just one page, one line after the other, like that in the page:

TO BE PRINTED:
---------------------------------
1 2 3 4 5 6 7 8 9 10

11 12 13 14 15


---------------------------------


IN LOTUS WHORKSHEET:
(each number in one column)
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15


Thanks,
Michel
 
In the range to print box, select or enter the two ranges separated by commas or semi-colons:

A1..J1;A2..J2

Then your ranges should print under one another on the same page.
 
Michel
This is something I didn't know could be done. In experimenting, I found one other step is needed too.
I highlighted 1-10, pressed cntrl key, highlighted 11-15.
At this point, I had two ranges separated by a colon like crazybird wanted. But then I also had to go into
File - Print - the print box at the bottom - and deselect print on separate pages. (It is still necessary to deal with page fits, margins, etc for the top row.) After doing that, everything was ok. (Also for preview, there is a print on separate screens box there that will have to be deselected to make preview match print.)

Crazybird
A star for a new horizon! thanks.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top