Removing A huge number of Page Breaks from Excel

[mattpearcey]

I have been sent a document, that i need to print. It is fairly complex, and thus i dont want to copy it onto another sheet to print. The docuement has been made with over 60 page breaks for each row, at the bottom, and icannot remove them. So, when i go to print, it says its going to print over 100 pages, which i do not want. The page breaks do not seem to want to go. They are dotted lines, as aposed to whole thick page break lines.

Does anyone know how i can remove these - as all the ways in which the help tool states are not working, or cannot be done.

Any ideas?? Thank you for your help already.

Matt Pearcey

 

[MichGovTech1]

Since the help files say to go into the Page Break Preview mode before removing the page break (Click "Insert" to remove... ya' gotta love it!), I'll assume you tried viewing the spreadsheet in "Normal" mode and removing them that way.

Next, I suggest looking at the Protection settings. The cells containing the page break commands may be set to prevent data entry (a.k.a. change).

 

[mattpearcey]

It was the protection settings. I got there in the end. Thanks for the help.
Thank you for your help already.

Matt Pearcey