Page Numbering in the footer

%3CLINGO-SUB%20id%3D%22lingo-sub-1773296%22%20slang%3D%22en-US%22%3EPage%20Numbering%20in%20the%20footer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1773296%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20number%20of%20pages%20within%20a%20number%20of%20worksheets%20and%20I'm%20trying%20to%20number%20all%20the%20pages.%20Currently%20I%20have%2019%20pages%20to%20be%20numbered%26nbsp%3B%20over%2010%20worksheets%2C%20some%20worksheets%20have%201%20page%20others%20have%202%2C3%20or%204%20pages%20and%20those%20worksheets%20that%20have%20more%20than%20one%20page%20to%20them%20keep%20getting%20the%20same%20number%20to%20every%20page%20regardless%20of%20what%20I%20do%20to%20try%20and%20change%20it%20for%20every%20page.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1773296%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1774084%22%20slang%3D%22en-US%22%3ERe%3A%20Page%20Numbering%20in%20the%20footer%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1774084%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F829795%22%20target%3D%22_blank%22%3E%40IanShaw1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EIf%20you%20are%20working%20with%20older%20versions%20then%20do%20the%20following%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3E%3CSPAN%3EOn%20the%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22ocpUI%22%3EInsert%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3Btab%2C%20in%20the%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22ocpUI%22%3EText%3C%2FSPAN%3E%3CSPAN%3E%26nbsp%3Bgroup%2C%20click%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22ocpUI%22%3EHeader%20%26amp%3B%20Footer%3C%2FSPAN%3E%3CSPAN%3E.%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%3EClick%20to%20add%20Footer%2FHeader.%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3EHeader%20%26amp%3B%20Footer%20has%20sections%26nbsp%3B%26nbsp%3B%3CSPAN%20class%3D%22ocpUI%22%3ELeft%2C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22ocpUI%22%3ECenter%20and%26nbsp%3B%3C%2FSPAN%3E%26nbsp%3B%3CSPAN%20class%3D%22ocpUI%22%3ERight%20section.%26nbsp%3B%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3EHit%20the%20section%20you%20want%20to%20enter%20the%20Page%20number.%3C%2FLI%3E%3CLI%3Efrom%20the%26nbsp%3B%3CSPAN%20class%3D%22ocpUI%22%3EDesign%3C%2FSPAN%3E%26nbsp%3Btab%2C%20in%20the%26nbsp%3B%3CSPAN%20class%3D%22ocpUI%22%3EHeader%2FFooter%3C%2FSPAN%3E%2C%20click%26nbsp%3B%3CSPAN%20class%3D%22ocpUI%22%3EPage%20Number%3C%2FSPAN%3E.%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%3CSTRONG%3EIf%20you%20are%20working%20with%20new%20versions%20then%20do%20the%20following%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3EHit%20the%20View%20TAB%2C%20and%20select%20Page%20Layout%20View.%3C%2FLI%3E%3CLI%3EYou%20find%20that%20the%20look%20of%20the%20sheet%20has%20changed.%3C%2FLI%3E%3CLI%3EScroll%20the%20screen%20down%2C%20you%20find%20FOOTER.%3C%2FLI%3E%3CLI%3EClick%20it%2C%20you%20get%20it's%20section%26nbsp%3B%3CSPAN%20class%3D%22ocpUI%22%3ELeft%2C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%20class%3D%22ocpUI%22%3ECenter%20and%26nbsp%3B%3C%2FSPAN%3E%26nbsp%3B%3CSPAN%20class%3D%22ocpUI%22%3ERight.%3C%2FSPAN%3E%3C%2FLI%3E%3CLI%3E%3CSPAN%20class%3D%22ocpUI%22%3EChoose%20the%20section%20you%20want%20Page%20Number%20%26amp%3B%20from%20the%20Design%20TAB%20insert%20the%20Page%20Number%20field.%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I have a number of pages within a number of worksheets and I'm trying to number all the pages. Currently I have 19 pages to be numbered  over 10 worksheets, some worksheets have 1 page others have 2,3 or 4 pages and those worksheets that have more than one page to them keep getting the same number to every page regardless of what I do to try and change it for every page.

1 Reply
Highlighted

@IanShaw1 

 

If you are working with older versions then do the following:

 

  1. On the Insert tab, in the Text group, click Header & Footer.
  2. Click to add Footer/Header.
  3. Header & Footer has sections  Left, Center and  Right section. 
  4. Hit the section you want to enter the Page number.
  5. from the Design tab, in the Header/Footer, click Page Number.

If you are working with new versions then do the following:

 

  1. Hit the View TAB, and select Page Layout View.
  2. You find that the look of the sheet has changed.
  3. Scroll the screen down, you find FOOTER.
  4. Click it, you get it's section Left, Center and  Right.
  5. Choose the section you want Page Number & from the Design TAB insert the Page Number field.