View original (French)

Freeze table column headers on a second page

Solved
Abla -  
Raymond PENTIER Posted messages 58211 Registration date   Status Contributor Last intervention   -
Hello,
I wanted to know, for a long table that spans a second page, how to keep the column headers on the second page in Word and Excel? Thank you

Configuration: Windows / Firefox 52.0

3 answers

  1.
    Raymond PENTIER Posted messages 58211 Registration date   Status Contributor Last intervention   17 480
     
    Hello.

    WORD =
    Select the first row (which contains the titles) and go to
    TABLE TOOLS/Layout/Data/Repeat Header Rows
    WARNING: The table must have no wrapping (Properties / Table / Text wrapping)
    --
    Retirement is great! Especially in the Caribbean... :-)
    Raymond (INSA, AFPA, CF/R)
    2
    1. Abla
       
      Thank you very much! I am delighted with the response.
      0
  2. Raymond PENTIER Posted messages 58211 Registration date   Status Contributor Last intervention   17 480
     
    EXCEL =
    For screen display, go to VIEW/Window/Freeze Panes/Freeze Top Row.
    For paper printing, go to PAGE LAYOUT/Page Setup/Print Titles/Rows to repeat at top

    --
    Retirement is great! Especially in the West Indies... :-)
    Raymond (INSA, AFPA, CF/R)
    0
  3. Raymond PENTIER Posted messages 58211 Registration date   Status Contributor Last intervention   17 480
     
    You also have the answer for Excel ...

    --
    Retirement is great! Especially in the Caribbean... :-)
    Raymond (INSA, AFPA, CF/R)
    0
    1. Abla
       
      Thank you for the response. But when we have merged cells in the row to repeat, how do we proceed?
      0
      1. Raymond PENTIER Posted messages 58211 Registration date   Status Contributor Last intervention   17 480 > Abla
         
        Word or Excel?
        Merged on the same row or the same column?
        Send an example file: 
         1) Go to https://www.cjoint.com/ 
         2) Click on [Browse] to select your file (max 15 MB)
         3) Scroll down to click the blue button [Create Cjoint link] 
         4) After a few seconds, the second page will display, with the link in bold; right-click on it and choose "Copy link"
         5) Return to your discussion on CCM, and in your message, click "Paste".
        =>See the guide https://www.commentcamarche.net/faq/29493-utiliser-cjoint-pour-heberger-des-fichiers
        0