Hide cells without changing linked formulas
Solved
Lenaahh
Posted messages
4
Status
Membre
-
Lenaahh Posted messages 4 Status Membre -
Lenaahh Posted messages 4 Status Membre -
Hello everyone,
I would like to delete cells without losing the formulas associated with them. I can't just hide my columns because what I need to remove isn't aligned in a single column. Therefore, I would like my cells to keep their resulting numbers from the formula and no longer be "linked" to the cells containing the data.
Thank you very much in advance! :)
I would like to delete cells without losing the formulas associated with them. I can't just hide my columns because what I need to remove isn't aligned in a single column. Therefore, I would like my cells to keep their resulting numbers from the formula and no longer be "linked" to the cells containing the data.
Thank you very much in advance! :)
1 réponse
Hello
to keep the value of a cell without it being modified by the formula, you need to copy / right-click / paste special / Values
which will remove the formula while keeping the displayed value
then, you can delete whatever you want
best regards
--
To err is human, to persist is diabolical
to keep the value of a cell without it being modified by the formula, you need to copy / right-click / paste special / Values
which will remove the formula while keeping the displayed value
then, you can delete whatever you want
best regards
--
To err is human, to persist is diabolical
Lenaahh
Posted messages
4
Status
Membre
Super, a big thank you Vaucluse!