Forum Discussion
Figer cellules / frozen cells
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
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.
