Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 31
Default "Print Selection" doesn't print beyond automatic page breaks

If I try to highlight a portion of a spreadsheet and print that selection,
only the top portion that is above the "automatic" page break will print.

I know I can select my highlighted portion as the print area, but is their a
way to disable Excel and print any selection I want even if it is beyond a
page break?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 152
Default "Print Selection" doesn't print beyond automatic page breaks

Have you tried €śFile€ť, €śPrint€ť, €śSelection€ť ?
Lou

"Andre" wrote:

If I try to highlight a portion of a spreadsheet and print that selection,
only the top portion that is above the "automatic" page break will print.

I know I can select my highlighted portion as the print area, but is their a
way to disable Excel and print any selection I want even if it is beyond a
page break?

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 31
Default "Print Selection" doesn't print beyond automatic page breaks

I guess I wasn't clear. That is my problem...I selected print selection from
the print window, and only the information above the page break gets printed.
If I have one line of data and thirty lines below the page break (all
highlighted) only the line above the page break will print using "print
selection"

"Rookie 1st class" wrote:

Have you tried €śFile€ť, €śPrint€ť, €śSelection€ť ?
Lou

"Andre" wrote:

If I try to highlight a portion of a spreadsheet and print that selection,
only the top portion that is above the "automatic" page break will print.

I know I can select my highlighted portion as the print area, but is their a
way to disable Excel and print any selection I want even if it is beyond a
page break?

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 182
Default "Print Selection" doesn't print beyond automatic page breaks

Hello, Andre!
You wrote on Mon, 30 Oct 2006 12:21:04 -0800:

A "Rookie 1st class" wrote:

?? Have you tried €śFile€ť, €śPrint€ť, €śSelection€ť ?
?? Lou
??
?? "Andre" wrote:
??
?? If I try to highlight a portion of a spreadsheet and
?? print that selection, only the top portion that is above
?? the "automatic" page break will print.
??
?? I know I can select my highlighted portion as the print
?? area, but is their a way to disable Excel and print any
?? selection I want even if it is beyond a page break?

I just tried Print Selection in Office XP both from Word and
Excel and the selected area does print tho' the page breaks are
active. I guess you must have something else making things
deviate from standard behavior.

James Silverton
Potomac, Maryland

E-mail, with obvious alterations:
not.jim.silverton.at.comcast.not

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
Can I set an automatic page breaks to break every 40 lines? Kennbu Excel Discussion (Misc queries) 1 June 15th 06 05:59 PM
Problem with Page Numbering Aurora Excel Discussion (Misc queries) 0 November 21st 05 02:10 PM
Page Numbers Aurora Excel Discussion (Misc queries) 0 November 17th 05 08:04 PM
How do I print a one page spreadsheet multiple time, each with its own page number? lhsallwasser Excel Discussion (Misc queries) 4 August 17th 05 03:00 PM
Page breaks don't show on screen and don't print separately. It i. Peter Excel Discussion (Misc queries) 1 November 29th 04 04:33 PM


All times are GMT +1. The time now is 07:23 PM.

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"