Figer cellules / frozen cells

%3CLINGO-SUB%20id%3D%22lingo-sub-1917781%22%20slang%3D%22fr-FR%22%3EFiger%20cells%20%2F%20frozen%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1917781%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%2C%20%3CBR%20%2F%3E%20I'm%20working%20on%20Excel%202016%20and%20I'm%20stuck%20to%20do%20a%20manipulation.%3CBR%20%2F%3EIs%20it%20possible%20to%20freeze%2Fblock%20cells%20or%20lines%20in%20red%20(5%2C%2018%2C%2020%20-%2028)%20without%20freezing%2Fblocking%20the%20other%20lines%20above%20or%20below%3F%3CBR%20%2F%3EThank%20you%20in%20advance%20for%20your%20answers.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E.................................................................................................................................................................................................................%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EHello%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EI'm%20working%20on%20Excel%202016%20and%20I'm%20stuck%20to%20do%20something.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EIs%20it%20possible%20to%20freeze%20%2F%20block%20the%20cells%20or%20lines%20in%20red%20(5%2C%2018%2C%2020%20-28)%20without%20freezing%20%2F%20blocking%20the%20other%20lines%20above%20or%20below%3F%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3ETahk%20your%20for%20your%20answer%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1917781%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1917836%22%20slang%3D%22en-US%22%3ERe%3A%20Figer%20cellules%20%2F%20frozen%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1917836%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F876139%22%20target%3D%22_blank%22%3E%40louis645195%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EStep%201%3A%20unlock%20all%20cells%20except%20rows%205%2C%2018%2C%2020%20and%2028.%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3ESelect%20the%20entire%20sheet.%3C%2FLI%3E%0A%3CLI%3EHold%20down%20the%20Ctrl%20key%20and%20click%20on%20the%20row%20numbers%20of%20rows%205%2C%2018%2C%2020%20and%2028%20to%20deselect%20them.%3C%2FLI%3E%0A%3CLI%3EPress%20Ctrl%2B1%20to%20activate%20the%20Format%20Cells%20dialog.%3C%2FLI%3E%0A%3CLI%3EActivate%20the%20Protection%20tab.%3C%2FLI%3E%0A%3CLI%3EClear%20the%20Locked%20check%20box.%3C%2FLI%3E%0A%3CLI%3EClick%20OK%3C%2FLI%3E%0A%3C%2FUL%3E%0A%3CP%3EStep%202%3A%20protect%20the%20sheet.%3C%2FP%3E%0A%3CUL%3E%0A%3CLI%3EActivate%20the%20Review%20tab%20of%20the%20ribbon.%3C%2FLI%3E%0A%3CLI%3EClick%20'Protect%20Sheet'.%3C%2FLI%3E%0A%3CLI%3ETick%20the%20check%20boxes%20for%20actions%20that%20you%20want%20to%20allow.%3C%2FLI%3E%0A%3CLI%3EIf%20you%20want%20to%20protect%20the%20sheet%20with%20a%20password%2C%20enter%20it%20in%20the%20box.%20Don't%20forget%20it%20-%20you%20will%20need%20it%20if%20you%20want%20to%20unprotect%20the%20sheet%20later%20on.%3C%2FLI%3E%0A%3CLI%3EClick%20OK.%20If%20you%20entered%20a%20password%2C%20you%20will%20have%20to%20enter%20it%20again%20as%20confirmation.%3C%2FLI%3E%0A%3C%2FUL%3E%3C%2FLINGO-BODY%3E
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.