| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
print spreadsheet in 5 sections....how to?
I have spreadsheet that I want printed as 5 pages, I normally highlight
print area 5 seperate times and print, to achieve this. I have tried using `page breaks` but either this is wrong or I am doing something wrong. I `click` on the line below where I want the break and then repeat to create the other pages but when i print it still prints as 1 page. help appreciated thanks |
|
#2
|
|||
|
|||
|
print spreadsheet in 5 sections....how to?
You'll need to have your print scaling set on the "Adjust to" setting. It's
on the File\Page Setup\Page tab. That way Excel will set up the scaling based on your manual page breaks. "Scudo" wrote in message ... I have spreadsheet that I want printed as 5 pages, I normally highlight print area 5 seperate times and print, to achieve this. I have tried using `page breaks` but either this is wrong or I am doing something wrong. I `click` on the line below where I want the break and then repeat to create the other pages but when i print it still prints as 1 page. help appreciated thanks |
|
#3
|
|||
|
|||
|
print spreadsheet in 5 sections....how to?
Try using View--Page Break Preview to help you determine page breaks. :)
************ Anne Troy www.OfficeArticles.com "Scudo" wrote in message ... I have spreadsheet that I want printed as 5 pages, I normally highlight print area 5 seperate times and print, to achieve this. I have tried using `page breaks` but either this is wrong or I am doing something wrong. I `click` on the line below where I want the break and then repeat to create the other pages but when i print it still prints as 1 page. help appreciated thanks |
|
#4
|
|||
|
|||
|
print spreadsheet in 5 sections....how to?
Ok sorted
thanks for help. "Anne Troy" wrote in message ... Try using View--Page Break Preview to help you determine page breaks. :) ************ Anne Troy www.OfficeArticles.com "Scudo" wrote in message ... I have spreadsheet that I want printed as 5 pages, I normally highlight print area 5 seperate times and print, to achieve this. I have tried using `page breaks` but either this is wrong or I am doing something wrong. I `click` on the line below where I want the break and then repeat to create the other pages but when i print it still prints as 1 page. help appreciated thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| changing print area in an entire workbook | Excel Worksheet Functions | |||
| My spreadsheet is only visible in print preview. | Excel Discussion (Misc queries) | |||
| How do I get a spreadsheet to print to actaul size of page? | Excel Worksheet Functions | |||
| How do I print labels from an Excel spreadsheet | Excel Discussion (Misc queries) | |||
| How can I print long lists of data from an Excel spreadsheet? | Excel Discussion (Misc queries) | |||
Linear Mode
