| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
set print area
Hi working with excel 2000 i have set my print area of the data that i want
to print but it is printing onto 2 - 3 different pages how can i get it to print it all onto one page. i have tried scaling it to fit one page but that doesn't work -- Thank you for reading my post. Hopefully you can answer my querie |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
set print area
Switch Your Print-Preview to Page Break Preview and try moving the BLUE lines
to suit; then try again. "Shazza" wrote: Hi working with excel 2000 i have set my print area of the data that i want to print but it is printing onto 2 - 3 different pages how can i get it to print it all onto one page. i have tried scaling it to fit one page but that doesn't work -- Thank you for reading my post. Hopefully you can answer my querie |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
set print area
File | page setup | check fit to 1 page wide 1 page tall
hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Shazza" escreveu: Hi working with excel 2000 i have set my print area of the data that i want to print but it is printing onto 2 - 3 different pages how can i get it to print it all onto one page. i have tried scaling it to fit one page but that doesn't work -- Thank you for reading my post. Hopefully you can answer my querie |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
set print area
My print area is 3 different collums and they are not all together i used
page set up to set the print area and i have ticked on fit to 1 page wide and 1 page tall but it still keeps putting each of the different collums onto a new page i want all of the collums onto 1 page. -- Thank you for reading my post. Hopefully you can answer my querie "Marcelo" wrote: File | page setup | check fit to 1 page wide 1 page tall hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Shazza" escreveu: Hi working with excel 2000 i have set my print area of the data that i want to print but it is printing onto 2 - 3 different pages how can i get it to print it all onto one page. i have tried scaling it to fit one page but that doesn't work -- Thank you for reading my post. Hopefully you can answer my querie |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
set print area
Hide the columns that are between the areas you want to print.
If your printrange consists of multiple discontiguous areas, you'll get multiple sheets of paper. Alternatively, you could copy each discontiguous range to another sheet (as pictures???) and print from there. Shazza wrote: My print area is 3 different collums and they are not all together i used page set up to set the print area and i have ticked on fit to 1 page wide and 1 page tall but it still keeps putting each of the different collums onto a new page i want all of the collums onto 1 page. -- Thank you for reading my post. Hopefully you can answer my querie "Marcelo" wrote: File | page setup | check fit to 1 page wide 1 page tall hth -- regards from Brazil Thanks in advance for your feedback. Marcelo "Shazza" escreveu: Hi working with excel 2000 i have set my print area of the data that i want to print but it is printing onto 2 - 3 different pages how can i get it to print it all onto one page. i have tried scaling it to fit one page but that doesn't work -- Thank you for reading my post. Hopefully you can answer my querie -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| set area in excel not giving me option to set print area? | Excel Discussion (Misc queries) | |||
| File, print area, clear area, is not working | New Users to Excel | |||
| print area across the freeze panes area | Excel Worksheet Functions | |||
| Pivot Table macro to set print area and print details of drill down data | Excel Discussion (Misc queries) | |||
| How do you turn off a print area for a page? (no print area) | Excel Discussion (Misc queries) | |||
Linear Mode
