View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
KC hotmail com> KC hotmail com> is offline
external usenet poster
 
Posts: 57
Default Every cell has a page break?!?!

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.