View original (French)

Excel number of pages on a sheet

Edgard MATONDO -  
eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   -
Hello,
I would like to know how many pages an Excel sheet has

Configuration: Windows XP / Firefox 9.0.1

2 answers

  1.
    gbinforme Posted messages 14930 Registration date   Status Contributor Last intervention   4 744
     
    Hello,

    An Excel sheet does not have pages; it is made up of rows and columns in a variable number depending on the version: to see.

    If you edit your sheet, depending on the layout you adopt, you will have more or fewer printed pages.
    --

    Always zen
    0
  2. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
     
    Hello everyone,

    note that there is an excel4 function that allows this.

    To use an excel4 function, it is necessary to define it in a name.
    On excel2003:
    - menu 'insert / name / define...'
    - name in the workbook: nb_pages
    - Refers to: =READ.DOCUMENT(50)
    - validate

    Then in a cell enter:
    =nb_pages

    eric
    0