Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Page breaks shift after preview/setting print pref
I have a small database (16 pages; 659 rows/13 columns) where the page break
consistantly shifts from its forced position (i.e. I have manually placed the breaks where needed). It is saved with new position intact, etc., but still shifts when either reopened or after previewing and/or setting printing preferences. Others opening the workbook from other PC have different page break settings than mine... What is the user interface error here? :-) Thanks for any feedback, no matter how embarressing... -- Always hoping to learn, Lara :-) |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Page breaks shift after preview/setting print pref
If you have the bag filled to the brim, then just moving it can make it overflow.<g Each printer sees and set things up a little differently. Even using the same printer, older vs. newer printer drivers can cause page breaks to shift. Different screen resolutions can also scramble things up. You might be better off telling Excel, in page setup, to fit to 1 page wide and to "empty" pages tall. Then just let it print. -or- Allow generous room around your data on each page and you probably won't have any problems. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Lara H." wrote in message I have a small database (16 pages; 659 rows/13 columns) where the page break consistantly shifts from its forced position (i.e. I have manually placed the breaks where needed). It is saved with new position intact, etc., but still shifts when either reopened or after previewing and/or setting printing preferences. Others opening the workbook from other PC have different page break settings than mine... What is the user interface error here? :-) Thanks for any feedback, no matter how embarressing... -- Always hoping to learn, Lara :-) |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Page breaks shift after preview/setting print pref
I'm guessing that it's a difference in printers (or printer drivers).
You may want to set those manual page breaks as conservatively as possible. Find the "worst" printer and make your pagebreak decision based on that printer. On the nice printers, you may find that you have larger margins, but so what <vbg. Lara H. wrote: I have a small database (16 pages; 659 rows/13 columns) where the page break consistantly shifts from its forced position (i.e. I have manually placed the breaks where needed). It is saved with new position intact, etc., but still shifts when either reopened or after previewing and/or setting printing preferences. Others opening the workbook from other PC have different page break settings than mine... What is the user interface error here? :-) Thanks for any feedback, no matter how embarressing... -- Always hoping to learn, Lara :-) -- Dave Peterson |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Page breaks shift after preview/setting print pref
Thanks for the response, Jim!
I understand the full bag metaphor! And I hadn't considered the printer aspect of this, since it is happening before printing. Duh! Unfortunately, I can't reduce down to one page or the data will be smaller than humanly readable! ;-) I had told Excel to have page set up at 17 pages wide by 17 tall, then tweaked it, etc. That is the only way to make it print out in the way "Boss" wants it. Thanks for the prompt response and generosity of info! -- Always learning, "Jim Cone" wrote: If you have the bag filled to the brim, then just moving it can make it overflow.<g Each printer sees and set things up a little differently. Even using the same printer, older vs. newer printer drivers can cause page breaks to shift. Different screen resolutions can also scramble things up. You might be better off telling Excel, in page setup, to fit to 1 page wide and to "empty" pages tall. Then just let it print. -or- Allow generous room around your data on each page and you probably won't have any problems. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel Add-ins / Excel Programming) "Lara H." wrote in message I have a small database (16 pages; 659 rows/13 columns) where the page break consistantly shifts from its forced position (i.e. I have manually placed the breaks where needed). It is saved with new position intact, etc., but still shifts when either reopened or after previewing and/or setting printing preferences. Others opening the workbook from other PC have different page break settings than mine... What is the user interface error here? :-) Thanks for any feedback, no matter how embarressing... -- Always hoping to learn, Lara :-) |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Page breaks shift after preview/setting print pref
Thanks for the response, Dave!
I deffinately hadn't considered the printer aspect of this (so focused on MAKING Excel obey me! LOL) We have everything from an OSe to HP Laserjet 3700dn here - a true plethra of choices! ::sigh:: ah well... Thanks for the prompt response and generosity of info! Will keep coming back and seeing whatever gems of wisdom I can glean. I have a very bad feeling this database is going to have to move to ACCESS anyway... -- Always learning, "Dave Peterson" wrote: I'm guessing that it's a difference in printers (or printer drivers). You may want to set those manual page breaks as conservatively as possible. Find the "worst" printer and make your pagebreak decision based on that printer. On the nice printers, you may find that you have larger margins, but so what <vbg. Lara H. wrote: I have a small database (16 pages; 659 rows/13 columns) where the page break consistantly shifts from its forced position (i.e. I have manually placed the breaks where needed). It is saved with new position intact, etc., but still shifts when either reopened or after previewing and/or setting printing preferences. Others opening the workbook from other PC have different page break settings than mine... What is the user interface error here? :-) Thanks for any feedback, no matter how embarressing... -- Always hoping to learn, Lara :-) -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I can't move my page breaks in Page Break Preview | Excel Discussion (Misc queries) | |||
How do I do page breaks when view menu doesnt page break preview | Excel Discussion (Misc queries) | |||
Setting the print area in page set up to print 1 page wide by 2 pages tall | Excel Discussion (Misc queries) | |||
setting page breaks for whole spreadsheet to be consistent? | Setting up and Configuration of Excel | |||
Are conditional formats available for setting page breaks? | Excel Discussion (Misc queries) |