Figer cellules / frozen cells

[louis645195]

Bonjour,
je travaille sur Excel 2016 et je suis bloqué pour faire une manipulation.
Est-il possible de figer/bloquer les cellules ou lignes en rouge (5, 18, 20 & 28) sans figer/bloquer les autres lignes en dessus ou dessous ?
Merci d'avance pour vos réponses.

.................................................................................................................................................................................................................

Hello,
I'm working on Excel 2016 and I'm stuck to do something.
Is it possible to freeze / block the cells or lines in red (5, 18, 20 & 28) without freezing / blocking the other lines above or below ?
Tahk your for your answer

[#2]

@louis645195 

Step 1: unlock all cells except rows 5, 18, 20 and 28.

• Select the entire sheet.
• Hold down the Ctrl key and click on the row numbers of rows 5, 18, 20 and 28 to deselect them.
• Press Ctrl+1 to activate the Format Cells dialog.
• Activate the Protection tab.
• Clear the Locked check box.
• Click OK

Step 2: protect the sheet.

• Activate the Review tab of the ribbon.
• Click 'Protect Sheet'.
• Tick the check boxes for actions that you want to allow.
• If you want to protect the sheet with a password, enter it in the box. Don't forget it - you will need it if you want to unprotect the sheet later on.
• Click OK. If you entered a password, you will have to enter it again as confirmation.