PDA

View Full Version : Can I use vba to set page breaks and fit the sheet’s data to 3 pages?



frank_m
04-02-2011, 09:41 PM
Please see the attached workbook. --100 rows (Columns A thru O)--

Currently the print area's data will require about (3 1/2) pages and will print a few of the columns on separate pages.

Is there some sort of a fit to page command that I can use and set the page breaks at the intervals of my choosing, so that everything will fit onto three pages?

macropod
04-03-2011, 12:08 AM
Hi frank,

You can get Excel to zoom the printout to fit a specified number of pages, via File|Page Setup|Page > Fit to (Excel 2003 & earlier) or Page Layout|Page Setup|Page > Fit to (Excel 2007 & later).

You can then insert manual page breaks wherever you want them via Insert|Page Break (Excel 2003 & earlier) or Page Layout|Breaks (Excel 2007 & later).