#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22
Default Page Break Preview

how can i extend the printable area up to the very last row (i can't go
beyond 265 pages) in Page Break Preview?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default Page Break Preview

Make two print jobs would be one way.


kaveh wrote:

how can i extend the printable area up to the very last row (i can't go
beyond 265 pages) in Page Break Preview?


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22
Default how can I extend the printable area up to the very last row?

Thanks Bob
Is there any other way to do one printing job?

"Bob I" wrote:

Make two print jobs would be one way.


kaveh wrote:

how can i extend the printable area up to the very last row (i can't go
beyond 265 pages) in Page Break Preview?



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default how can I extend the printable area up to the very last row?

I have Excel 2007 and no issues with setting 500+ pages. Perhaps you
need to Clear and Reset the Print Area.

kaveh wrote:

Thanks Bob
Is there any other way to do one printing job?

"Bob I" wrote:


Make two print jobs would be one way.


kaveh wrote:


how can i extend the printable area up to the very last row (i can't go
beyond 265 pages) in Page Break Preview?




  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22
Default how can I extend the printable area up to the very last row?

HI BOB
I GOT 2003 VERSION, AND ALREADY RESET THE PAGE BREAK PREVIEW BUT DOESN'T
WORK FOR ME.
THANKS

"Bob I" wrote:

I have Excel 2007 and no issues with setting 500+ pages. Perhaps you
need to Clear and Reset the Print Area.

kaveh wrote:

Thanks Bob
Is there any other way to do one printing job?

"Bob I" wrote:


Make two print jobs would be one way.


kaveh wrote:


how can i extend the printable area up to the very last row (i can't go
beyond 265 pages) in Page Break Preview?






  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default Page Break Preview

Using Excel 2003 I entered data from A1:F50000

PageBreak Preview shows 1250 pages

What is your printrange set to?


Gord Dibben MS Excel MVP

On Thu, 7 Aug 2008 09:58:05 -0700, kaveh wrote:

how can i extend the printable area up to the very last row (i can't go
beyond 265 pages) in Page Break Preview?


  #7   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22
Default GOT IT FIXED THANKS

HI GORD
YEAH GOT IT SOLVED, PAGE SETUP/SHEET/PRINTAREA
THANKS AGAIN

"Gord Dibben" wrote:

Using Excel 2003 I entered data from A1:F50000

PageBreak Preview shows 1250 pages

What is your printrange set to?


Gord Dibben MS Excel MVP

On Thu, 7 Aug 2008 09:58:05 -0700, kaveh wrote:

how can i extend the printable area up to the very last row (i can't go
beyond 265 pages) in Page Break Preview?



  #8   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default GOT IT FIXED THANKS

Good to hear.

Gord

On Thu, 7 Aug 2008 12:07:01 -0700, kaveh wrote:

HI GORD
YEAH GOT IT SOLVED, PAGE SETUP/SHEET/PRINTAREA
THANKS AGAIN

"Gord Dibben" wrote:

Using Excel 2003 I entered data from A1:F50000

PageBreak Preview shows 1250 pages

What is your printrange set to?


Gord Dibben MS Excel MVP

On Thu, 7 Aug 2008 09:58:05 -0700, kaveh wrote:

how can i extend the printable area up to the very last row (i can't go
beyond 265 pages) in Page Break Preview?




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
How do I do page breaks when view menu doesnt page break preview HeatherF55 Excel Discussion (Misc queries) 0 September 21st 07 04:24 AM
Remove big gray page number on Page Break Preview??? annafred Excel Discussion (Misc queries) 1 January 9th 07 02:28 AM
change page number watermark in page break preview juga Excel Discussion (Misc queries) 2 December 25th 06 10:16 AM
change and/or remove page number watermark in page break preview juga Excel Discussion (Misc queries) 2 December 25th 06 10:15 AM
print preview v page break preview SamB Excel Discussion (Misc queries) 0 November 16th 06 05:09 PM


All times are GMT +1. The time now is 12:35 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"