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.

Sort in MS Excel format: Leave the cell or cell box space (not a simple type)

     Today I presented in MS Excel Tip sequence which forms the desired cell or cell box space (not a simple type)

Steps are as follows
1. Insert cells to 2 cells, using formulas in MS Excel cells in the first sequence. And set the default to make the cell sorting patterns, an example is Cell A and B, respectively.

2. Cell type formula in the desired order by model example is the Cell B7:
=IF(MOD(A5,2)=1,A5+1,"")

3. Copy the formula as needed.

4. Select the first cell and set the hide.

5. You can format as needed

Try applied job.

Thank you,
Worawut  Bunwang