Every cell has a page break?!?!

Someone at my office had a file that when opened. (Excel 2007) would show
every cell with page breaks showing hidden lines around every cell. Couldn't
figure out out to remove the breaks. It wouldn't allow you to remove them. If
you hit print preview it would say something like 1 to 4000 pages. Is there a
simple fix for this?

You should be able to go to view and hit normal right above page break preview.

"Garyntx" wrote:

Someone at my office had a file that when opened. (Excel 2007) would show
every cell with page breaks showing hidden lines around every cell. Couldn't
figure out out to remove the breaks. It wouldn't allow you to remove them. If
you hit print preview it would say something like 1 to 4000 pages. Is there a
simple fix for this?

tried that. the lines go away but it still wants to print each cell
separately and will not let you remove the page breaks.

"Pokey" wrote:

You should be able to go to view and hit normal right above page break preview.

One of my collegues had the same thing happen, although it was on excel
2003. He changed printer and it was fine. It seemed to be a temporary
problem with the connection to one printer.
Barbara

"Garyntx" wrote in message
...
Someone at my office had a file that when opened. (Excel 2007) would show
every cell with page breaks showing hidden lines around every cell.
Couldn't
figure out out to remove the breaks. It wouldn't allow you to remove them.
If
you hit print preview it would say something like 1 to 4000 pages. Is
there a
simple fix for this?

Right-click the sheet tab and select "View Code"

Paste this macro in:
Private Sub fixbreaks()
ActiveSheet.ResetAllPageBreaks
End Sub

Hit the green play button.
Ctrl+A to select the entire macro, then hit the Delete key.
Alt+Q to get out of the macro editing window.

That should take care of it.
--
Please remember to indicate when the post is answered so others can benefit
from it later.


"Garyntx" wrote:

tried that. the lines go away but it still wants to print each cell
separately and will not let you remove the page breaks.

"Pokey" wrote:

You should be able to go to view and hit normal right above page break preview.