View original (French)

Freeze table column headers on a second page

Solved
Abla -  
Raymond PENTIER Posted messages 58548 Registration date   Status Contributeur 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 réponses

Réponse 1 / 3
Raymond PENTIER Posted messages 58548 Registration date   Status Contributeur Last intervention   17 474
 
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
Abla
 
Thank you very much! I am delighted with the response.
0
Réponse 2 / 3
Raymond PENTIER Posted messages 58548 Registration date   Status Contributeur Last intervention   17 474
 
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
Réponse 3 / 3
Raymond PENTIER Posted messages 58548 Registration date   Status Contributeur Last intervention   17 474
 
You also have the answer for Excel ...

--
Retirement is great! Especially in the Caribbean... :-)
Raymond (INSA, AFPA, CF/R)
0
Abla
 
Thank you for the response. But when we have merged cells in the row to repeat, how do we proceed?
0
Raymond PENTIER Posted messages 58548 Registration date   Status Contributeur Last intervention   17 474 > 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