Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel 2003 Page Breaks
I e-mailed a workbook to a collegue that contained 28 worksheets.
On my PC, all the vertical page breaks were set so printing was done on one page for each sheet. On his machine the page break shifted to the left such that some columns were on a second page for each sheet. What can be done to preserve the verticle page break setting. This file will be sent daily and we would like to not need to adjust the page breaks. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel 2003 Page Breaks
He probably has a different printer and a different printer driver. Not much
you can do about that, except work in very safe distance from the margins. Maybe doing the final adjustments on his system may be an idea. HTH. Best wishes Harald "Carl" wrote in message ... I e-mailed a workbook to a collegue that contained 28 worksheets. On my PC, all the vertical page breaks were set so printing was done on one page for each sheet. On his machine the page break shifted to the left such that some columns were on a second page for each sheet. What can be done to preserve the verticle page break setting. This file will be sent daily and we would like to not need to adjust the page breaks. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel 2003 Page Breaks
Try using the File -- Page Setup and on the Page tab, in the "Scaling"
section choose "Fit to" and enter 1 for page(s) wide by and delete any entry in the "tall" portion. Don't put any number in the "tall" section - it should remain empty. "Carl" wrote: I e-mailed a workbook to a collegue that contained 28 worksheets. On my PC, all the vertical page breaks were set so printing was done on one page for each sheet. On his machine the page break shifted to the left such that some columns were on a second page for each sheet. What can be done to preserve the verticle page break setting. This file will be sent daily and we would like to not need to adjust the page breaks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 adding page breaks | Excel Discussion (Misc queries) | |||
Excel 2003 Page Breaks | Excel Discussion (Misc queries) | |||
How to show page breaks by default in Excel 2003 | Setting up and Configuration of Excel | |||
excel page breaks gone | Excel Discussion (Misc queries) | |||
Automatic page breaks in Excell 2003 | Excel Discussion (Misc queries) |