marcusblackcat
New Member
- Joined
- Mar 11, 2015
- Messages
- 18
We have a spreadsheet in my workplace which is set up to print one page wide by one page high.
When I make changes to this sheet on my PC, the system automkatically inserts a new page break on every row. If I use the page break preview and change the scale to 40% the page breaks get less and less - then if I try to drag them to make the worksheet one page wide by 1 page high, it again puts a page break at every row of the sheet.
I have also used the Option Fit to 1 wide and 1 high and this also puts a break at every row of the sheet. There are no macro's set up on the sheet and I am at a loss to explain this. It seems that every time I try to change the page breaks it reverts to single line page breaks.
If you change them to make the worksheet 4 pages (using the scale option), as soon as you select the "print" option, it again inserts the page breaks.
Any help would be greatly appreciated
When I make changes to this sheet on my PC, the system automkatically inserts a new page break on every row. If I use the page break preview and change the scale to 40% the page breaks get less and less - then if I try to drag them to make the worksheet one page wide by 1 page high, it again puts a page break at every row of the sheet.
I have also used the Option Fit to 1 wide and 1 high and this also puts a break at every row of the sheet. There are no macro's set up on the sheet and I am at a loss to explain this. It seems that every time I try to change the page breaks it reverts to single line page breaks.
If you change them to make the worksheet 4 pages (using the scale option), as soon as you select the "print" option, it again inserts the page breaks.
Any help would be greatly appreciated
