View original (French)

Persistent anchoring

katzann75 Posted messages 26 Registration date   Status Member Last intervention   -  
Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   -

Hello!

In an Excel table that I need to reuse by changing a few data points, I occasionally anchored something and I can't remove it.

How could I delete it? I tried several times... to no avail!

Thanks in advance for your responses.

Best regards

3 answers

  1.
    Le Pingou Posted messages 12275 Registration date   Status Contributor Last intervention   1 477
     

    Hello,

    Could you explain what is understood by: ancrage

    Best regards.
    Le Pingou

    1
    1. katzann75 Posted messages 26 Registration date   Status Member Last intervention  
       
      The insertion of a smiley I had placed in a cell has become an embedded image that I can no longer remove: at best, I managed to shrink it to a simple line by trimming it as much as possible (even a small green square), and next to it the anchor symbol appears. It remains in the cell (I’m on LibreOffice) I can add columns or rows, but the drawing stays embedded …
      0
      1. Nain_Porte_Quoi Posted messages 164 Registration date   Status Member Last intervention   32 > katzann75 Posted messages 26 Registration date   Status Member Last intervention  
         

        Hello,

        the forum here is named Excel...

        For Calc, go to View > Navigator, double-click on the image, choose the image, press the Delete key

        1
  2. danielc0 Posted messages 2192 Registration date   Status Member Last intervention   287
     

    Hello,

    A bit randomly, in the formula:

     =A1+B1

    Click on A1 and press the F4 function key.

    You get

     $A$1+B1

    Each time you press F4, the formula becomes:

     =A$1+B1 =$A1+B1 =A1+B1

    etc.

    Daniel

    0
  3. Raymond PENTIER Posted messages 58216 Registration date   Status Contributor Last intervention   17 482
     

    Bonjour katzann75

    Efforce-toi d'être précis et rigoureux quand tu demandes de l'aide dans ce forum :

    • Dans ton post initial tu parles d'un tableau Excel, qui est un logiciel de Microsoft Office ; mais au post #3 il s'agit de Libre Office, donc de Calc.
    • Tu as procédé à un "ancrage", mais sans expliquer comment tu as fait : L'insertion d'un smiley dans une cellule ne nous indique pas la manière dont tu as procédé ...
    • Et pour faciliter notre compréhension du problème et aider à la rédaction d'une solution, il aurait été très utile de joindre ton fichier.

    C'est bien, la retraite ! Surtout aux Antilles ...
    Raymond (INSA, AFPA)

    0