Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default How do I delete page breaks from my documents?

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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,118
Default How do I delete page breaks from my documents?

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


"danajohnson88" wrote:

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.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,047
Default How do I delete page breaks from my documents?

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:

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Page Breaks change with different computer Mariano Excel Discussion (Misc queries) 1 January 5th 06 05:18 PM
How can I do one-time printing without set page breaks? kewlblondboy Excel Discussion (Misc queries) 2 August 24th 05 02:53 PM
can't drag page breaks S. H. Drew Excel Discussion (Misc queries) 3 May 2nd 05 07:38 PM
MS Office Excel97: Removing Page Breaks W. Watson Excel Discussion (Misc queries) 2 April 15th 05 11:38 PM
move page breaks Laura Excel Worksheet Functions 1 March 31st 05 02:16 AM


All times are GMT +1. The time now is 08:17 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"