Every cell has a page break?!?!

Garyntx

unread,

Dec 30, 2009, 4:14:01 PM12/30/09

to

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?

Pokey

unread,

Dec 30, 2009, 4:19:01 PM12/30/09

to

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

Garyntx

unread,

Dec 30, 2009, 4:37:01 PM12/30/09

to

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

Barbara Wiseman

unread,

Dec 30, 2009, 4:38:35 PM12/30/09

to

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" <Gar...@discussions.microsoft.com> wrote in message
news:1EA36669-4AB0-4422...@microsoft.com...

KC hotmail com >

unread,

Dec 30, 2009, 5:22:01 PM12/30/09

to

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.

Marilyn Sliwa

unread,

Mar 16, 2011, 10:11:48 PM3/16/11

to

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.

> On Wednesday, December 30, 2009 4:14 PM 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 would not 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?

>> On Wednesday, December 30, 2009 4:19 PM Pokey wrote:

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

>> "Garyntx" wrote:

>>> On Wednesday, December 30, 2009 4:37 PM 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:

>>>> On Wednesday, December 30, 2009 4:38 PM Barbara Wiseman wrote:

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

>>>>> On Wednesday, December 30, 2009 5:22 PM KChotmail com> wrote:

>>>>> 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:

>>>>> Submitted via EggHeadCafe
>>>>> Profiling and Optimizing VBA
>>>>> http://www.eggheadcafe.com/tutorials/aspnet/12dfc2ae-d796-40e8-9762-572bdaa7b637/profiling-and-optimizing-vba.aspx

Gord Dibben

unread,

Mar 16, 2011, 10:29:09 PM3/16/11

to

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

Tina MC

unread,

Jul 13, 2011, 4:00:49 PM7/13/11

to

No no! It's much simpler than anything I've read here... Save and close down Excel completely. When you reopen it, it will be back to normal. :)

> On Wednesday, December 30, 2009 4:14 PM 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 would not 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?

>> On Wednesday, December 30, 2009 4:19 PM Pokey wrote:

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

>> "Garyntx" wrote:

>>> On Wednesday, December 30, 2009 4:37 PM 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:

>>>> On Wednesday, December 30, 2009 4:38 PM Barbara Wiseman wrote:

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

>>>>> On Wednesday, December 30, 2009 5:22 PM KChotmail com> wrote:

>>>>> 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:

>>>>>> On Wednesday, March 16, 2011 10:11 PM Marilyn Sliwa wrote:

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

Luc .

unread,

Jul 25, 2011, 7:21:21 AM7/25/11

to

Try this:
hit the start button, click run and type there %temp%. Delete all the (temp)files in this directory, skip those that can't be deleted. Problem should be solved now.

> On Wednesday, December 30, 2009 4:14 PM 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 would not 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?

atkins.lu...@gmail.com

unread,

Feb 11, 2014, 5:05:17 AM2/11/14

to

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

ajaic...@gmail.com

unread,

May 20, 2014, 7:00:05 AM5/20/14

to

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

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

benf...@gmail.com

unread,

Nov 11, 2016, 5:52:48 AM11/11/16

to

Thank you

bde...@oertelarchitects.com

unread,

Feb 27, 2017, 10:08:50 AM2/27/17

to

Simply closing and reopening has always worked for me. I would love to know why it is happening though.

regis.t...@googlemail.com

unread,

May 24, 2017, 3:31:12 AM5/24/17

to

I think this is printer related, I have the same experience whereby every cell becomes a page. This only happens when I try to print to a particular printer while on a different printer I can print just fine.

carolyn...@gmail.com

unread,

Oct 26, 2018, 5:23:15 PM10/26/18

to

I selected another printer and hit back, and it worked! Thank you! I was using a label printer earlier, so it was reading every cell as a page so it could fit on the label!

eli.c...@gmail.com

unread,

May 10, 2019, 8:02:47 PM5/10/19

to

Thank you. This was it!

sankara subramaniam

unread,

Apr 13, 2021, 1:41:17 PM4/13/21

to

Excellent. It worked by simply closing the .exe and reopening the file.

Emmanuel Soto

unread,

Jun 5, 2021, 12:49:19 PM6/5/21

to

You are a saint!!!! Thank you. I was losing my mind!!!

Ahmad Imaduddin Zul Azman

unread,

Aug 4, 2022, 10:02:16 PM8/4/22

to

Happens to me just now. Reopening the file does not work.
What work for me was -> press print and change to another printer (the page break should revert to normal now). You can change back to previous printer if you want print it from there, or you can press esc / back to continue editing your excel.