Auto Insert Page numbers without Footer
 

Using Excel 2000, 1 sheet

Is there a way to print page numbers in a certain cell.. I use page setup to repeat 10 rows at the top of each page. then I manually inserted page breaks. I need the page number to be in one of the repeated rows.


Example
1 Date____________ Name ____________
2 Company Name
3 Address
4 City, State, Zip Master Order Page _(NEED AUTO PAGE NUMBER HERE)______
5 Misc Data
6 etc
7 etc
8 etc

12-? Data
--PAGE BREAK --

Thanks in Advance for any help,
Keith

Auto Insert Page numbers without Footer
 

based on 10 rows per page, the following should get you started if
copied into the cells of the first unused COLUMN:

=IF(MOD(ROW(),10)=0,INT(ROW()/10),"")


--
protonLeah
------------------------------------------------------------------------
protonLeah's Profile: http://www.excelforum.com/member.php...o&userid=32097
View this thread: http://www.excelforum.com/showthread...hreadid=537312

Auto Insert Page numbers without Footer
 

You may use a trick, if you have a column where there is something that
appears once per page (for example, the string "Name" in column E) you can
fake the page number using:
="Master Order Page _ " & COUNTIF($E$1:$E100,"Name")
If you are putting the formula in row 100, for example.

"Keith" wrote:

Using Excel 2000, 1 sheet

Is there a way to print page numbers in a certain cell.. I use page setup to repeat 10 rows at the top of each page. then I manually inserted page breaks. I need the page number to be in one of the repeated rows.


Example
1 Date____________ Name ____________
2 Company Name
3 Address
4 City, State, Zip Master Order Page _(NEED AUTO PAGE NUMBER HERE)______
5 Misc Data
6 etc
7 etc
8 etc

12-? Data
--PAGE BREAK --

Thanks in Advance for any help,
Keith