| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| 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) | |||
| page breaks | Excel Discussion (Misc queries) | |||
| Page breaks | Setting up and Configuration of Excel | |||
| How do I keep page breaks for each page in a sheet without the co. | Excel Discussion (Misc queries) | |||
| Page breaks | Excel Discussion (Misc queries) | |||
![Cosmo[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
