View original (French)

Excel - Page numbering multiple sheets

Solved
thdelesalle -  
roubiane Posted messages 1 Status Member -
Hello,

I would like to print an Excel file containing about 15 sheets.
I would like to number the pages.

So I inserted "Page &[Page]" on each sheet in the page layout.

However, on each new sheet, the numbering starts again at "Page 1".
Now, I would like the first page of the second sheet to be a continuation of the last page of the first sheet (complicated! lol)

Is it possible to have continuous page numbering across the sheets?

Thank you for your help.
Configuration: Windows XP Firefox 2.0.0.11

6 answers

  1. thdelesalle
     
    Otherwise, I found something pretty good (shows that searching pays off)

    You select all your sheets, go to page layout, type Page &[Page], and you print... it works...

    That's the only method I've found.

    See you later!
    12
    1. Lissothus Posted messages 16 Registration date   Status Member Last intervention   6
       
      Here too. Thank you, there's no doubt that this will be useful to me as well.

      I think you can indicate that the message has found its answer.
      0
    2. CH-AB
       
      I didn't succeed with this method; it messes up my layout (1 table on 1 sheet is coming out on 2 sheets and cutting my table off as a result).
      0
      1. Raymond PENTIER Posted messages 58213 Registration date   Status Contributor Last intervention   17 482 > CH-AB
         
        That's really curious! And even unique...
        0