ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Page Break Preview (https://www.excelbanter.com/excel-discussion-misc-queries/197977-page-break-preview.html)

kaveh

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?

Bob I

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?



kaveh

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?




Bob I

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?





kaveh

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?





Gord Dibben

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?



kaveh

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?




Gord Dibben

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?






All times are GMT +1. The time now is 01:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com