Friday, July 15, 2011

Set the continuous page numbers (from sheet to sheet) in MS Excel

[Thai]
Set the continuous page numbers (from sheet to sheet) in MS Excel.


1. Select a Sheet for set  continuous page numbers (example : General sheet).


2. Set "Page Setup" -> Header/Footer ->Custom Header or Custom Footer
3. Set  format and formulas.
    Example: 
        Page &[Page]+3 from 7 Pages     =>   Page 4 from 7 Pages
       &[Page] : Page Number
       3 : The total number of pages per sheet to be counted(example : Manerger sheet)



3. Result.


No comments:

Post a Comment