Excel page breaks

B

Bill

I have an Excel worksheet that is supposed to print on
one sheet using the "Fit to" option in page set up. On
one PC however, it is now printing on 346 pages because
Excel has inserted page breaks every few cells or so.
This happened after someone installed some Franklin Covey
software on the PC. The software has been removed, but
the page breaks still appear. It prints fine from other
PC's. Is there an option that needs to be checked or
unchecked to fix this problem or is there some other fix?
Thanks for your help!
 
R

Ron de Bruin

Hi Bill

Reset your usedrange, look aon Debra's site
http://www.contextures.com/xlfaqApp.html#Unused


From the Excel Help
****************

Add, delete, or move page breaks
On the View menu, click Page Break Preview.

Do one of the following:

View page breaks : Manually inserted page breaks appear as solid lines. Dashed lines indicate where Microsoft Excel will break
pages automatically.

Move a page break : Drag the page break to a new location. Moving an automatic page break changes it to a manual page break.

Insert vertical or horizontal page breaks : Select a row or column below or to the right of where you want to insert a horizontal
or vertical page break, right-click, and then click Insert Page Break.

Remove page breaks" Drag the page break outside of the print area. To remove all manual page breaks, right-click any cell on the
worksheet, and then click Reset All Page Breaks.
 
G

Guest

Tried that; they're still there. This spreadsheet is on a
server and appears ok on every other PC but the one that
had the new software installed. I'm thinking it has to be
a setting on that PC.
 

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