Figer cellules / frozen cells

Occasional Visitor

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

 

 

 

1 Reply

@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.