no of pages in excel worksheet (not workbook)

[S N]

i want to know how many pages will print when i give print command on a particular worksheet
(and not how many worksheets are there in a particular workbook)

actually i want to display the following text on a particular column cell

page x of y (where x is the particular page on which the cell lies and y is the total number of pages that would print)

i dont want to use header and footer which give this detail because header and footer would give this detail in the header /footer area only, whereas i need to show this data in the cells in the page

please help

 

[Mike Rogers]

S N

To find the number of pages in a particular worksheet goto View>Page break
preview. From there you can move around and find the last page that is
within your print area set up. When you have that figured out go back to
View and select "Normal". Another way would be to select "Print Preview" and
flip through (using the "Next" button) the pages counting as you go.
If you are trying to figure out maximum number of pages a worksheet can
have, I think that is subject to the available memory.

Mike Rogers

 

[S N]

you have not understood the problem correctly.
Actually i want to fill a cell in my worksheet which dynamically shows the
number of pages that would be printed when i print the worksheet on a
printer. this would be the same number as would be shown in print preview.
however i dont just want to see in print preview, but also want to fill up
a cell with this data.
the other data i want is the current page number filled up in a cell.
meaning "page x of y" where x is the current page number and y is the total
number of pages that would be printed in the worksheet.
please help

 

[Bill Sharpe]

you have not understood the problem correctly.
Actually i want to fill a cell in my worksheet which dynamically shows the
number of pages that would be printed when i print the worksheet on a
printer. this would be the same number as would be shown in print preview.
however i dont just want to see in print preview, but also want to fill up
a cell with this data.
the other data i want is the current page number filled up in a cell.
meaning "page x of y" where x is the current page number and y is the total
number of pages that would be printed in the worksheet.
please help

I understand what you want but I don't understand why you "need" to show
this information in a cell. Doesn't a header or footer give you the
information you need? A quick print preview will display the result.

Alternatively, Page Break preview view will show you the pages.
Control-End will take you to the last page.

Bill

 

[S N]

My excel worksheet runs into several pages. The first few show some
information, and the next few pages are annexures to the initial pages.
I dont want to show page numbers in the first few pages, whereas i want to
show "Page x of y of annexure A" on the next few pages.
Further this pagination should be dynamic and i dont want to key in the page
numbers.
In this situation, i cant use page break preview as it would make page
number entry manual. Also i dont want header and footer as it would apply to
all the pages which i dont want.

HEnce please tell me how to show "PAge x of y" in one of the cells on the
worksheet. x should show the current page number and y should denote the
total pages in the worksheet.

Please help.

 

[Bill Sharpe]

My excel worksheet runs into several pages. The first few show some
information, and the next few pages are annexures to the initial pages.
I dont want to show page numbers in the first few pages, whereas i want to
show "Page x of y of annexure A" on the next few pages.
Further this pagination should be dynamic and i dont want to key in the page
numbers.
In this situation, i cant use page break preview as it would make page
number entry manual. Also i dont want header and footer as it would apply to
all the pages which i dont want.

HEnce please tell me how to show "PAge x of y" in one of the cells on the
worksheet. x should show the current page number and y should denote the
total pages in the worksheet.

Please help.

Why don't you put your annexure "pages" in a separate worksheet of the
same workbook? That way you can easily display the information you want
for the annexure pages in a header or footer. Excel can handle what you
want to do, but you just have to be somewhat accommodating to the
program's limitations/capabilities. Your further explanation complicates
the problem. You really don't want the total pages in your worksheet;
you want the total pages of the annex only. And you aren't willing to
enter the information manually.

I'm not aware of any automated method of doing exactly what you want to
do and judging from the lack of other replies apparently no one else is,
either.

Bill

 

[Regina Hott]

Has anyone found an answer to this yet? It would be really great to automate this part of my worksheet. Headers and footers are not so helpful on certain sheets.

 

[Don Guillett]

Apparently this pertains to a post somewhere?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
in message news:[email protected]...

 

[John C]

Question?

 

[Cerberus]

It is very simple, take the division 64/16. Now, canceling a 6 on top and a
six on the bottom, we get that 64/16 = 4/1 = 4.