Printing ranges from multiple work sheets

wwheaton · Apr 23rd, 2002, 01:34 PM

Excel 97, am trying to print a range from two different sheets in the same workbook on the same page. Range is aprox 9 columns by 20 rows in both sheets. Trying to print both ranges on one page. Any suggestions?

Thanks

Brian from Maui · Apr 23rd, 2002, 02:10 PM

You might try highlighting the first selection of cells in the worksheet, press Shift + F8 and highlight the second selection of cells, then Print/Selection

Never tried it though

wwheaton · Apr 23rd, 2002, 02:15 PM

Thanks for the reply - works within one sheet but even then it prints the two ranges on two pages not one. Does not work across multiple sheets.

Thanks again for the reply

Campsalot · Apr 23rd, 2002, 03:27 PM

You could just copy the areas that you want to print to a third sheet. If these ranges are printed over and over again . . . you could make a macro that creates a new worksheet, selects the ranges you want, pastes them to the new worksheet, prints out the report, then deletes the worksheet you created.
I hope I gave you some ideas.

Chris Davison · Apr 24th, 2002, 12:46 PM

view
toolbars
customise
commands
tools.......... scrolldown the options

click the camera icon and drag it to your toolbar, you should now have a camera sitting on your toolbar

now highlight your first set of cells in question and click the camera, this will take a snapshot of those cells

now go to where you want to show them as an image, click and drag to max size

repeat for the second set of cells, overlapping if necessary... then print that single page

if you don't like the format (opaque-ness, lines etc etc) right-click the images and play around with the formats

NB - may be a disadvantage, may be a bonus : these images are realtime : if your scource cells change, the images will also change, similar to a linked cell

Brian from Maui · Apr 24th, 2002, 12:54 PM

Chris,

Nice feature.

Mahalo!

Brian

Chris Davison · Apr 24th, 2002, 04:23 PM

Aloha Brian,

yeah, I love it.... I use it mainly for presentation of summaries...

you can basically paste lots of different pictures alongside each other and underneath each other and not worry about column widths or anything....

handy for "memo" style summaries with text inbetween pictures of tables etc etc

*and* they update automatically....

weird how the damn thing is buried away in the customised toolbar settings though !

Chris

Brian from Maui · Apr 24th, 2002, 04:36 PM

Chris,

Just tried using the "camera" to snap a photo and transfer to PowerPoint and that works too. COOL!

Brian

Brian from Maui · May 6th, 2002, 02:21 AM

Found this for Excel 2000 users

http://office.microsoft.com/Assistan...rintAreas.aspx

wwheaton · May 8th, 2002, 01:39 PM

A bit belated but thanks for the tip. Works great.Almost gave up on a solution but thought i would check a last time to see what was there. Glad i did

W

Apr 24th, 2002, 12:46 PM	#5
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	view toolbars customise commands tools.......... scrolldown the options click the camera icon and drag it to your toolbar, you should now have a camera sitting on your toolbar now highlight your first set of cells in question and click the camera, this will take a snapshot of those cells now go to where you want to show them as an image, click and drag to max size repeat for the second set of cells, overlapping if necessary... then print that single page if you don't like the format (opaque-ness, lines etc etc) right-click the images and play around with the formats NB - may be a disadvantage, may be a bonus : these images are realtime : if your scource cells change, the images will also change, similar to a linked cell __________________ :: Pharma Z - Family drugstore ::

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 23rd, 2002, 01:34 PM	#1
wwheaton New Member Join Date: Apr 2002 Location: Winnipeg, Canada Posts: 12	Excel 97, am trying to print a range from two different sheets in the same workbook on the same page. Range is aprox 9 columns by 20 rows in both sheets. Trying to print both ranges on one page. Any suggestions? Thanks

Apr 23rd, 2002, 02:10 PM	#2
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	You might try highlighting the first selection of cells in the worksheet, press Shift + F8 and highlight the second selection of cells, then Print/Selection Never tried it though

Apr 23rd, 2002, 02:15 PM	#3
wwheaton New Member Join Date: Apr 2002 Location: Winnipeg, Canada Posts: 12	Thanks for the reply - works within one sheet but even then it prints the two ranges on two pages not one. Does not work across multiple sheets. Thanks again for the reply

Apr 23rd, 2002, 03:27 PM	#4
Campsalot New Member Join Date: Apr 2002 Location: A cold state with warm people Posts: 3	You could just copy the areas that you want to print to a third sheet. If these ranges are printed over and over again . . . you could make a macro that creates a new worksheet, selects the ranges you want, pastes them to the new worksheet, prints out the report, then deletes the worksheet you created. I hope I gave you some ideas.

Apr 24th, 2002, 12:54 PM	#6
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Chris, Nice feature. Mahalo! Brian

Apr 24th, 2002, 04:23 PM	#7
Chris Davison MrExcel MVP Join Date: Feb 2002 Location: Millbank, London, UK Posts: 1,790	Aloha Brian, yeah, I love it.... I use it mainly for presentation of summaries... you can basically paste lots of different pictures alongside each other and underneath each other and not worry about column widths or anything.... handy for "memo" style summaries with text inbetween pictures of tables etc etc and they update automatically.... weird how the damn thing is buried away in the customised toolbar settings though ! Chris

Apr 24th, 2002, 04:36 PM	#8
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Chris, Just tried using the "camera" to snap a photo and transfer to PowerPoint and that works too. COOL! Brian

May 6th, 2002, 02:21 AM	#9
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	Found this for Excel 2000 users http://office.microsoft.com/Assistan...rintAreas.aspx

May 8th, 2002, 01:39 PM	#10
wwheaton New Member Join Date: Apr 2002 Location: Winnipeg, Canada Posts: 12	A bit belated but thanks for the tip. Works great.Almost gave up on a solution but thought i would check a last time to see what was there. Glad i did W