View original (French)

Hide cells without changing linked formulas

Solved
Lenaahh Posted messages 4 Status Member -  
Lenaahh Posted messages 4 Status Member -
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! :)

1 answer

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    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
    1
    1. Lenaahh Posted messages 4 Status Member
       
      Super, a big thank you Vaucluse!
      0