Every cell has a page break?!?!


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?
 
Ad

Advertisements

G

Garyntx

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

Barbara Wiseman

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
 
K

KC hotmail com>

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.
 
M

Marilyn Sliwa

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.
 
Ad

Advertisements

G

Gord Dibben

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
 
A

atkins.lushengzhong

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?

just meet the same problem, and change for another printer works for my case
 
Ad

Advertisements

A

ajaichohan

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?

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top