Persistent anchoring

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

  • Votes
  • Date
  • Descending date
  1. Hello,

    Could you explain what is understood by: ancrage


    Best regards.
    Le Pingou

    1. 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 …
    2. @katzann75

      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

  2. 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


    1. Contributor

      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)