Print two different Excel print areas on ONE page 1

[smalty]

I have 2 worksheets and one print area defined on each. I would like to print both print areas ie. the two print areas combined... on one sheet of paper. Is this possible?

 

[SkipVought]

smalty,

Best to check out the FAQ's before posting a question.

Dale Watson has an excellent FAQ on this...

faq68-1161

Skip,

_[red][/red]

 

[combo]

And there is an option that depends on your hardware (printer): multiple pages per sheet.

combo

 

[smalty]

Thanx both for the info.

I will certainly check FAQ's in future.

I hadn't considered hardware printing options and although I can 'make do' with this option this time, the solution provided by the FAQ post will certainly come into use in the future as it appears to have a few more formatting options.

Appreciate the swift replies.

Thanx again SkipVought and combo

 

[thegrover]

The email address for Dale Watson and the sample file is no longer vaild. (FAQ 68-1161) Does someone have the sample file they can share?

Steve

 

[SkipVought]

Did you try going thru the steps he outlined?

Skip,

_[red][/red]

 

[smalty]

Skip,
It does appear relatively complex but I am always interested in 'hidden' parts of applications.......WHY DO THEY DO THAT?...and I will def get round to trying it.
However whilst pondering Dale's solution it occurred to me that I should try defining 'Names' for the areas I wanted to print, and holding the Ctrl then calling the ranges.....ie selecting all the ranges at the same time, this may have the same effect. With a little bit of tweeking the page setup and printer software (thanks to combo), Excel treats the different ranges as separate pages and therefore I was able to print the '2 pages' on one sheet by instructing the printer software to print multiple pages on 1 sheet.
This maybe basic stuff for experienced users of Excel but I am more used to using Access hence my question in the first place.

Will let you know how I get on with Dale's solution.

Thanx again Skip

 

[SkipVought]

It involves manually assembling the pieces, using the Camera feature or Copy Picture/Paste Picture feature.

Skip,

_[red][/red]

 

[Stella740pl]

Skip,

Thanks for getting me familiar with an interesting and useful feature.

I didn't know copying cells as a picture is possible, especially linked (on the other hand, I wasn't actually looking for that info now, I just opened the thread to find an interesting read). Star for you and a vote for the FAQ writer.

But the FAQ, and its claim that the feature is "TRULY HIDDEN" got me looking for answers, and apparently, it is documented. (Not everyone knows that some menu selection change when you hold down Shift, that's true, but it is documented, even if it is hard to find.)

I use Office 2000 (the FAQ was written in 2001), so I searched Help on the words copy picture, and found a bunch of related articles. I've got to admit that Dale Watson’s method with naming ranges first is a bit more flexible, even though also a bit lengthier, but the help has a description of a similar (kind of reversed) procedure.

Create a picture of cells that is linked to the source data

Only the visible information in the cells is included in the picture. If necessary, resize the columns in Microsoft Excel to show all the data you want in the picture. Cell gridlines appear in the picture if they are displayed. To omit gridlines, click Options on the Tools menu, click the View tab, and then clear the Gridlines check box.
1. On the worksheet, select the cells you want to make into a picture.
2. Click Copy .
3. Click the worksheet or other document where you want to paste the picture.
4. To paste the picture to another worksheet, hold down SHIFT and click Paste Picture Link on the Edit menu. The picture is linked by a formula that refers to the copied cells.
To paste the picture to a document created in another Office program, click Paste Special on the Edit menu. In the As box, click Picture, click Paste link, and then click OK.
You can use the Picture toolbar to change the image.

Note The picture is linked to the copied cells by using Dynamic Data Exchange (DDE). For more information about DDE, see the Microsoft Office 2000 Resource Kit. How to obtain the Office Resource Kit.

Note also (just tested], that if you copy the source cells using “Copy Picture” option, that makes “Paste Picture Link” grayed out, but you can use it after regular Ctrl-C, and create the link to the source data automatically. It is kind of weird, since who would know to use “Paste Picture Link” if you just copied a range of cells, or the opposite, who would use “Copy picture”, if you have cells selected, but all together it opens a lot of possibilities.

Thanks.

 

[smalty]

I finally managed to test Dale's solution and found it to be the perfect answer to my original problem. Being able to re-size and position anywhere makes it's flexibility almost limitless and combined with the 'link' option is just great, even more so with the info supplied by Stella.

Great stuff from all..........THANX

Smalty