ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   page numbering (https://www.excelbanter.com/excel-worksheet-functions/134308-re-page-numbering.html)

Anne-France Goldwater

page numbering
 
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


Gary''s Student

page numbering
 
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



MANOJ

page numbering
 
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

JE McGimpsey

page numbering
 
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?



All times are GMT +1. The time now is 08:50 PM.

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