Moving a Page Break

[Frillth]

I am working on an excel workbook for a program at our school. I need to set page breaks between different sets of data in my workbook. I manually set all my horizontal page breaks fine, but my vertical page breaks are giving me trouble. The program imposed a vertical page break on my workbook that cuts off 2 columns and puts them on a separate page, but there is plenty of room on the page I want them to be on (at least 1/2 of the page is blank). I have tried to move and delete this page break, but neither works. Any suggestions?

[Bryan Hessey]

I am working on an excel workbook for a program at our school. I need to set page breaks between different sets of data in my workbook. I manually set all my horizontal page breaks fine, but my vertical page breaks are giving me trouble. The program imposed a vertical page break on my workbook that cuts off 2 columns and puts them on a separate page, but there is plenty of room on the page I want them to be on (at least 1/2 of the page is blank). I have tried to move and delete this page break, but neither works. Any suggestions?

Check the paper size, the Right margin, and whether you have 'fit to page' vertically.

Any clues?

---

[Frillth]

My paper is set to 8 1/2 x 11, my margins are all set to .5", and my scaling is set to "Adjust to: 100% normal size" so I don't think those 3 are messing me up.

[Bryan Hessey]

My paper is set to 8 1/2 x 11, my margins are all set to .5", and my scaling is set to "Adjust to: 100% normal size" so I don't think those 3 are messing me up.

Can you copy the sheet, remove all of your data, and post the test sheet (if still a problem) here for ttesting.

Thanks
---