Level one Level two.

  • Thread starter Thread starter PaulW
  • Start date Start date
P

PaulW

Hello Gurus and newsgroup users.

Your kind assistance please.

I have a Worksheet that is only 15 rows deep and but 42
columns long.

Instead of printing the worksheet over two pages, I would
like to print on a single page.
I know there is the option to print on one page but this
reduces the print out to unreadable size.

I was hoping there would be an option to have the first
part of the worksheet sat on top of the second part but
all on the same page.

I suspect there is not an option for this.

Regards
Paul W
 
PaulW said:
Hello Gurus and newsgroup users.

Your kind assistance please.

I have a Worksheet that is only 15 rows deep and but 42
columns long.

Instead of printing the worksheet over two pages, I would
like to print on a single page.
I know there is the option to print on one page but this
reduces the print out to unreadable size.

I was hoping there would be an option to have the first
part of the worksheet sat on top of the second part but
all on the same page.

I suspect there is not an option for this.

Regards
Paul W
Click to expand...

As far as I know there is no 'built-in' way to do this.
However, it would not be difficult to set up a separate worksheet (Sheet2)
with simple formulas referencing the cells in your existing worksheet, but
laid out as you want it printed.
So, the formula in Sheet2!A1 would be =Sheet1!A1. You would then copy this
across, say, 21 columns and down 15 rows.
Then, perhaps leaving row 16 blank, in Sheet2!A17 the formula would be
=Sheet1!V1. Copy this across 21 columns and down 15 rows.
Using this simple method, you could choose to set the layout as you want
it - maybe in 3 or more sections rather than just 2.
 
There is an old work-around that sometimes works, depending on your original
sheet set-up and your cell sizes and configuration.
You can play around with it and see if it can help you.

First, select the cells that you would like to comprise the "lower half" of
your print page.
Now, <Shift> + <Edit> displays a drop down menu with picture options.
Click on <CopyPicture>,
Now, navigate to the cell where you would like to start this "lower "
section (perhaps A16),
And <Shift + <Edit> again and click <PastePicture>.

Now, set-up and play around with your print area and print options to
include your new configuration and see if you can get what you want.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



Hello Gurus and newsgroup users.

Your kind assistance please.

I have a Worksheet that is only 15 rows deep and but 42
columns long.

Instead of printing the worksheet over two pages, I would
like to print on a single page.
I know there is the option to print on one page but this
reduces the print out to unreadable size.

I was hoping there would be an option to have the first
part of the worksheet sat on top of the second part but
all on the same page.

I suspect there is not an option for this.

Regards
Paul W
 
Back
Top