Forum Discussion

Jovelin's avatar
Jovelin
Copper Contributor
Feb 10, 2022

Rendre invisible une cellule.

Bonjour
j'utilise Excel 2013 et 2016 . Mais lorsque je rends une cellule invisible, en réalité je ne dois pas voir le contenu de cette dernière après collage de valeur (123) .
Est-ce que il y a un moyen de masque définitivement une cellule , et que ça reste invisible peu importe l'option de collage ?

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor

    Jovelin 

    There are several ways to make a cell or its content invisible.

    I can't tell from the written text what exactly you accomplish.

    But you can, for example, use conditional formatting to format the value in a cell with the background color and the value is there, but you can't see it.

     

    Here is an example in the attached file.

    In the colored cell you can put any number you want and it will not be visible.

     

    If this is not what you have in mind, then I recommend including a file (without sensitive data) explaining step by step exactly what you want.

    Otherwise the helper has to spend too much time guessing and then giving imprecise solutions, as I just thought. There won't be many to help :).

     

    Hope I was able to help you with this info.

     

    NikolinoDE

    I know I don't know anything (Socrates)

    Was the answer useful? Mark them as helpful!

    This will help all forum participants.

Resources