Page numbering on Excel 2007, how do I correctly do it?

I am doing an excel assignment on Microsoft Excel 2007. There are 4 worksheets in this workbook and one part of the assignment is numbering the pages on the footer. It should be ';Page 1 of 4'; on the first page, but when I put the code %26amp;[Page] of %26amp;[Pages], all the pages say page 1 of 1. How do I fix that problem to show the correct page number?Page numbering on Excel 2007, how do I correctly do it?
You probably need to define the print area. There are several options on how you may want this done. Here's a good site that explains it well.


http://www.uwec.edu/Help/Excel07/pr-basi鈥?/a>





Page numbering on Excel 2007, how do I correctly do it?
Hello Dear sir


u can go to file mune then page setup after that there is opation call advance u can click on that u can slect the page no even u can select from the headnote and footnote