Page breaks
 

My document has a page break after every row, don't know how they got there
or why? This document should fit on 1 page if I go to setup and tell excel
(2000) to fit to 1 page wide by 1 page tall it changes the Adjust to size to
10% and then tells me margins will not it on page. How can I make this one
page document stop printing on 237 pages (1 for each row and 6 columns)??

heart1, if you want to remove the page breaks, Ctrl+a to select all the
sheet then insert, reset all page breaks

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"heart1" wrote in message
...
My document has a page break after every row, don't know how they got
there
or why? This document should fit on 1 page if I go to setup and tell excel
(2000) to fit to 1 page wide by 1 page tall it changes the Adjust to size
to
10% and then tells me margins will not it on page. How can I make this
one
page document stop printing on 237 pages (1 for each row and 6 columns)??

heart1 Wrote:
My document has a page break after every row, don't know how they got
there
or why? This document should fit on 1 page if I go to setup and tell
excel
(2000) to fit to 1 page wide by 1 page tall it changes the Adjust to
size to
10% and then tells me margins will not it on page. How can I make this
one
page document stop printing on 237 pages (1 for each row and 6
columns)??


Hi heart1

Try selecting all cells on the worksheet, then Insert Reset All Page
Breaks, this should remove them all


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=401316

I have already tried that and it will not remove/reset the page breaks. This
document is stored on a inhouse server drive, some people at work can open it
and it works normally, others open it and instead of 1 page, they get however
many rows are in the document, and these people can not change their page
setup to print to 1 page wide by 1 page tall and their size cannot be changed
from 10%.

"Paul B" wrote:

heart1, if you want to remove the page breaks, Ctrl+a to select all the
sheet then insert, reset all page breaks

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"heart1" wrote in message
...
My document has a page break after every row, don't know how they got
there
or why? This document should fit on 1 page if I go to setup and tell excel
(2000) to fit to 1 page wide by 1 page tall it changes the Adjust to size
to
10% and then tells me margins will not it on page. How can I make this
one
page document stop printing on 237 pages (1 for each row and 6 columns)??

Page breaks
 

You may have already solved this by now, but for future reference...this
happened to me as well, just as being described here - page break after every
row, couldn't remove them. My culprit turned out to be the printer I had
selected to print the file. Other printer from my list of printers in XP
worked fine. So I deleted the offending printer from the list, then
reinstalled it using the CD with drivers that came with the printer. And
everything worked fine after that.

Not sure if that is your problem, but you might check.

Good luck.

"Paul Sheppard" wrote:


heart1 Wrote:
My document has a page break after every row, don't know how they got
there
or why? This document should fit on 1 page if I go to setup and tell
excel
(2000) to fit to 1 page wide by 1 page tall it changes the Adjust to
size to
10% and then tells me margins will not it on page. How can I make this
one
page document stop printing on 237 pages (1 for each row and 6
columns)??


Hi heart1

Try selecting all cells on the worksheet, then Insert Reset All Page
Breaks, this should remove them all


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=401316