If you got on one sheet more than 1 page to print don't leave it to excel to choose the printarea. As you've seen now, maybe excel won't get it right. What I did, I set up printarea with vba. Open the file and press Alt + F11 in Modul1 is this code:
Code:
Sub PagesToPrint()
ActiveSheet.PageSetup.PrintArea = "$B$1:$G$50,$B$53:$G$93,$B$96:$G$138,$B$141:$G$179,$B$182:$G$218"
End Sub
But there is also a way to do it manually without vba:
- Select on the sheet the cells for the first page
- Keep pressing <CTRL> while selecting further areas for page 2, 3, ...
- Maybe a empty row/column has to separate the different areas, please check on this
- Once all areas are selected (they will all be shown marked) you click on the menue File ---> Printarea ---> Define
If you have then a look at preview it will show the defined pages. In case you have selected the areas too big in size that they won't fit on one page excel will devide the printout of these areas on more than one page.
Still you have more options by clicking "Layout": There you can for example adjust the margins and try to get the areas fit on one page. Be aware that some printers require a minimum margin on top and bottom.Therefore I was setting the margin for the bottom to 0.5. If you want include the grey row in the area, you will have to set that margin to 0 and look what your printer makes of it.
I just discovered that there is at least one more option in "Layout": Obviously the size of the areas to print can be modified by percentage. I haven't tried, but seen the helpmenue provides some explanation on this.
Closing the file you will have to agree to save. This way the established printarea and everything related will be saved as well for the next time.
I left out any explanation on vba, it might be quite difficult that way if you never worked with. Just that much: In case you pressed Alt + F11 and wonder how to close the window: Click on the window's menue File ---> Close and Return to excel
