|
Page Breaks
Is there anyway to set the number of lines in a page break? I have some very
large price sheets with pictures in them and when I set sizing it cuts pictures where the page breaks end up |
Page Breaks
Go to the View menu and select "Page Break Preview". Click and drag the page break lines to where you want them. Exit by selecting "Normal" on the View menu. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Cosmo" wrote in message Is there anyway to set the number of lines in a page break? I have some very large price sheets with pictures in them and when I set sizing it cuts pictures where the page breaks end up |
Page Breaks
I have 50+ pages, is there a way to set a pre detrmined number of cells per
page so I dont have to drag the line on each page? "Jim Cone" wrote: Go to the View menu and select "Page Break Preview". Click and drag the page break lines to where you want them. Exit by selecting "Normal" on the View menu. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Cosmo" wrote in message Is there anyway to set the number of lines in a page break? I have some very large price sheets with pictures in them and when I set sizing it cuts pictures where the page breaks end up |
Page Breaks
You only have to adjust the page breaks for the sections you are concerned about. The other pages automatically adjust. As for setting a fixed amount of rows to print on every page, there is no way that I know of without using VBA. With that one could set a manual page break every N rows. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Cosmo" wrote in message I have 50+ pages, is there a way to set a pre detrmined number of cells per page so I dont have to drag the line on each page? "Jim Cone" wrote: Go to the View menu and select "Page Break Preview". Click and drag the page break lines to where you want them. Exit by selecting "Normal" on the View menu. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Cosmo" wrote in message Is there anyway to set the number of lines in a page break? I have some very large price sheets with pictures in them and when I set sizing it cuts pictures where the page breaks end up |
Page Breaks
What is VBA?
"Jim Cone" wrote: You only have to adjust the page breaks for the sections you are concerned about. The other pages automatically adjust. As for setting a fixed amount of rows to print on every page, there is no way that I know of without using VBA. With that one could set a manual page break every N rows. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Cosmo" wrote in message I have 50+ pages, is there a way to set a pre detrmined number of cells per page so I dont have to drag the line on each page? "Jim Cone" wrote: Go to the View menu and select "Page Break Preview". Click and drag the page break lines to where you want them. Exit by selecting "Normal" on the View menu. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Cosmo" wrote in message Is there anyway to set the number of lines in a page break? I have some very large price sheets with pictures in them and when I set sizing it cuts pictures where the page breaks end up |
Page Breaks
VBA: Visual Basic for Applications. It is the programming language used to automate tasks in MS Office programs. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware (Excel add-ins... sort colors, compare, arrange columns, thesaurus) "Cosmo" wrote in message What is VBA? "Jim Cone" wrote: You only have to adjust the page breaks for the sections you are concerned about. The other pages automatically adjust. As for setting a fixed amount of rows to print on every page, there is no way that I know of without using VBA. With that one could set a manual page break every N rows. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Cosmo" wrote in message I have 50+ pages, is there a way to set a pre detrmined number of cells per page so I dont have to drag the line on each page? "Jim Cone" wrote: Go to the View menu and select "Page Break Preview". Click and drag the page break lines to where you want them. Exit by selecting "Normal" on the View menu. -- Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Cosmo" wrote in message Is there anyway to set the number of lines in a page break? I have some very large price sheets with pictures in them and when I set sizing it cuts pictures where the page breaks end up |
| All times are GMT +1. The time now is 04:07 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com