I have written a time billing app, with a large header (implemented by using
the "repeat rows at top of page" command. I want the page number to appear
in row 2, where I can place it appropriately to fit into the "look" of the
header (the actual header command only lets you place a page number at the
left, middle, or far right, of the absolute top of the page,and NOT within
the spreadsheet text/values).

So, how do I access the page number outside the header command?

Put another way: How do you place the page number IN your spreadsheet?

Thanks for any help you can offer!

Anne-France

See:

http://groups.google.com/group/micro...3252502ce2ac30


--
Gary''s Student
gsnu200709


"Anne-France Goldwater" wrote:

I have written a time billing app, with a large header (implemented by using
the "repeat rows at top of page" command. I want the page number to appear
in row 2, where I can place it appropriately to fit into the "look" of the
header (the actual header command only lets you place a page number at the
left, middle, or far right, of the absolute top of the page,and NOT within
the spreadsheet text/values).

So, how do I access the page number outside the header command?

Put another way: How do you place the page number IN your spreadsheet?

Thanks for any help you can offer!

Anne-France

dear sir/madam,

i want to give page numbers in excel sheet, but in the first page i want to give 1 and in 2 page i want to give 1a and from 3 page onwards continues page numbers, is it is possible?

Kinldy let me know.

Regards
Manoj


EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com

One way:

You could adapt the routine he

http://www.mcgimpsey.com/excel/subs/firstfooter.html



In article , MANOJ wrote:

i want to give page numbers in excel sheet, but in the first page i want to
give 1 and in 2 page i want to give 1a and from 3 page onwards continues page
numbers, is it is possible?