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