Page Breaks in Landscape

[nikwak1]

I have a problem that has only raised its ugly head today. I have lots of spreadsheets and they are printed out Landscape. When I compiled the spreadsheets I always put the page breaks in so that the pages will print properly and not cut anything off. Today I opened a spreadsheet up and it has added almost 400 page breaks - one on each line of the spreadsheet after line 77 to line 481. I have tried to reset page breaks, remove page breaks but all these breaks are automatic breaks and therefore no removable! If I change to Portrait, the page breaks all disappear and I have a usual amount of breaks automatically inserted. I have tried changing the page layout (which is set on all spreadsheets as 1 page wide and automatic height) but that does nothing. When I change back to Landscape - all the 400 odd page breaks re-appear. This wasn't there yesterday so I have no idea what I have done. Any thoughts would be gratefully received

 

[Saba Sabaratnam]

Probably, you already tried this option?

Or you could try to page and width to given number of pages.

Kind regards

Saba

 

[nikwak1]

Saba

Thanks - yes have tried both those. The 'remove' 'reset' doesn't work as these are automatic breaks that have been put in by Excel, not manual ones. The page width and height doesn't work either. I have played about with that but can't get a satisfactory outcome. It is strange because all other spreadsheets work fine and are on Width: 1 Height: Automatic. But they haven't developed all these extraneous page breaks

 

[Saba Sabaratnam]

I find this suggestion in the internet and you may want to give a try

You may want to check the yellow highlighted check box.

Kind regards

Saba

 

[nikwak1]

Saba - thanks. The problem is not the showing of the page breaks but the spreadsheet, which is 5 pages, prints out as 395 pages!! So not worried about seeing them, just want to get rid of them

 

[Trixterz]

You need to reset all your page break or check your macro scripts as there might be a script that is causing the page break issue. If you don't know anything about macros, then to easily get rid of them, just click "Save As" and save your document under "Save as type" as "Excel Workbook".

 

[nikwak1]

Trixterz - thanks - that works until I put the Width in as 1 and the Height as Automatic and then they all re-appear! Doing my head in!