Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Print different areas on one page
I have several areas on one spreadsheet. Because the columns had to be
different widths, I couldn't put everything in a format to print out easily. What is the best way to print out different areas so that they all fit a certain way and on one page. I know this is kind of like a report in Access. Is there some way to do this, lay it out the way one wants? If so, what is this called and how do you do it? Thanks so much for any help. Bryan Bloom |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Print different areas on one page
Bryan,
You will have to copy the various areas on to a new sheet in the order that you want and print from there. - or - The free Excel add-in 'Print Selections Only' may do what you want. Download from ... http://www.realezsites.com/bus/primitivesoftware No registration required. -- Jim Cone San Francisco, USA "Bryan Bloom" wrote in message I have several areas on one spreadsheet. Because the columns had to be different widths, I couldn't put everything in a format to print out easily. What is the best way to print out different areas so that they all fit a certain way and on one page. I know this is kind of like a report in Access. Is there some way to do this, lay it out the way one wants? If so, what is this called and how do you do it? Thanks so much for any help. Bryan Bloom |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Print different areas on one page
Thanks Jim, I will give this a try. But is there a way to take your data in
a spreadsheet and make a "report" that prints out, much like how Access works? Perhaps that is what the program you suggest does... My real problem is in my spreadsheet I cant put a certain group of cells below another one because the column widths need to be different so I am putting that group on a different part of the spreadsheet. But if I simply print it out it won't look how I want as I want the part with the wider cells printed below the first group. Hope that makes sense. Bryan "Jim Cone" wrote: Bryan, You will have to copy the various areas on to a new sheet in the order that you want and print from there. - or - The free Excel add-in 'Print Selections Only' may do what you want. Download from ... http://www.realezsites.com/bus/primitivesoftware No registration required. -- Jim Cone San Francisco, USA "Bryan Bloom" wrote in message I have several areas on one spreadsheet. Because the columns had to be different widths, I couldn't put everything in a format to print out easily. What is the best way to print out different areas so that they all fit a certain way and on one page. I know this is kind of like a report in Access. Is there some way to do this, lay it out the way one wants? If so, what is this called and how do you do it? Thanks so much for any help. Bryan Bloom |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Print different areas on one page
Bryan,
I am unfamiliar with how Access handles printing. You might want to review the Excel help files dealing with Views. It allows you to retain custom worksheet arrangements and print them. Also, one can copy a picture of a selection by using a semi-hidden feature of Excel. Hold down the Shift key and click the Edit menu. The displays a "copy picture" menu option. You could experiment with copying pictures of your various selections and placing them on a new sheet. That works best when gridlines are not shown. or printed. The Print Selections Only program of mine, stacks pictures of each selection one above the other, on as many pages as needed and prints them. Sounds like what you want. -- Jim Cone San Francisco, USA http://www.officeletter.com/blink/specialsort.html "Bryan Bloom" wrote in message Thanks Jim, I will give this a try. But is there a way to take your data in a spreadsheet and make a "report" that prints out, much like how Access works? Perhaps that is what the program you suggest does... My real problem is in my spreadsheet I cant put a certain group of cells below another one because the column widths need to be different so I am putting that group on a different part of the spreadsheet. But if I simply print it out it won't look how I want as I want the part with the wider cells printed below the first group. Hope that makes sense. Bryan "Jim Cone" wrote: Bryan, You will have to copy the various areas on to a new sheet in the order that you want and print from there. - or - The free Excel add-in 'Print Selections Only' may do what you want. Download from ... http://www.realezsites.com/bus/primitivesoftware No registration required. -- Jim Cone San Francisco, USA "Bryan Bloom" wrote in message I have several areas on one spreadsheet. Because the columns had to be different widths, I couldn't put everything in a format to print out easily. What is the best way to print out different areas so that they all fit a certain way and on one page. I know this is kind of like a report in Access. Is there some way to do this, lay it out the way one wants? If so, what is this called and how do you do it? Thanks so much for any help. Bryan Bloom |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Print different areas on one page
Hi Bryan,
I'm a real newbie, but it sounds like you could copy the selected areas to Word and print the report from there. If you set up the Word file as a Word template, you could use it whenever you want, deleting and pasting new selections. -- Cheryl "Bryan Bloom" wrote: I have several areas on one spreadsheet. Because the columns had to be different widths, I couldn't put everything in a format to print out easily. What is the best way to print out different areas so that they all fit a certain way and on one page. I know this is kind of like a report in Access. Is there some way to do this, lay it out the way one wants? If so, what is this called and how do you do it? Thanks so much for any help. Bryan Bloom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Double sided print (same page on reverse) | Excel Discussion (Misc queries) | |||
Format to print in columns on 1 page | Excel Discussion (Misc queries) | |||
Different print page setups on one worksheet? | Excel Worksheet Functions | |||
How do I print a single column of data in two columns on one page | Excel Discussion (Misc queries) | |||
Multiple Print areas in same sheet? | Excel Discussion (Misc queries) |