If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
Every cell has a page break?!?!
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? |
#3
|
|||
|
|||
Every cell has a page break?!?!
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. |
#4
|
|||
|
|||
Every cell has a page break?!?!
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? |
#5
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|