Select the sheet you want the Page Numbe in, then from the Main Toolbar,
select:
View-> Header and Footer click on the Custom Footer button, and click on the
section you would like to see the Page Number, then Click on the Second icon
from the left the one that looks like a page with the Pound sign # and that
should do it.