How do I delete page breaks from my documents?

G

Guest

I have somehow entered page breaks on my documents and I do not know how I
did it or how to delete them so that my document prints completely.

Also, I have 3 columns that I want printed. What do I do so that only these
three columns print out. Sometimes the doc will be only one page, but as I
add to it, it will be more lines. But I only want the same three columns to
print each time (not D-ZZ too) only A-C.
 
G

Guest

Try this:

To remove multiple page breaks:
**********************
From the Excel main menu:
<view><page break preview>
(The solid blue lines represent page breaks)

Then...to remove a page break...
Right-click on any cell immediately below the solid blue line.
Select Remove Page Break

Then...to create a page break...
Right-click on any cell immediately below where you want the break.
Select Insert Page Break

OR...to remove all page breaks...
Right-click on any cell .
Select Remove All Page Breaks

When done....<view><normal>

Regarding the area printed....
*******************
Select the area you want to print,
then from the Excel main menu:
<file><print area><set print area>

Now Excel will only print that area, instead of the entire used area of the
worksheet.

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
G

Guest

hi Dana,

Select on the A, B and C columns the range that you would like to print,
click on FILE menu, and set as print area, on page setup, chose 1 to 1 page

hth
regards from Brazil
Marcelo


"danajohnson88" escreveu:
 

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