Every cell has a page break?!?!

  • Thread starter Thread starter Garyntx
  • Start date Start date
G

Garyntx

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.
 
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
 
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.
 
THIS WORKED, BUT WHEN I CLICKED ON 'VIEW CODE' & PUT BOX ON "WORKSHEET" INSTEAD OF "GENERAL", I GOT THE FOLLOWING:

"Private Sub Worksheet_SelectionChange(ByVal Target As Range)

End Sub"

I HAD TO DELETE THE ABOVE "" SO THE ONLY THING ON PAGE WAS THE MACRO ITSELF.

WOULD NOT WORK OTHERWISE.
did this:

1. PRESS "VIEW CODE"
2. PUT WORD IN BOX TO "WORKSHEET"
3. DELETE "PRIVATE SUB WORKSHEET_ ETC. (ABOVE "")
4. COPY MACRO & PASTE IT, SO THAT MACRO IS THE ONLY THING ON THE PAGE.
then continue as indicated:
5. 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.
 
Suggestion............do not place macros in the sheet module.

Place instead in a General or Standard module.

Leave the sheet modules for event code like

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
your event code here
End Sub


Gord Dibben MS Excel MVP
 
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?
Click to expand...

just meet the same problem, and change for another printer works for my case
 
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?
Click to expand...

Macro's worked once, but the problem came back again.

I just printed the excel document as an PDF and printed it that way.
 
Back
Top