Vorlage:Video-Daten im Text direkt aus markierter Zelle einfügen-English: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
(3 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt)
Zeile 3: Zeile 3:




<center><div class="toccolours mw-collapsible mw-collapsed" style="width:800px; overflow:auto>
<center>
<div style="font-weight:bolder;line-height:1.8;">Insert data directly from the selected Excel cell</div>
<div class="toccolours mw-collapsible mw-collapsed" style="width:800px; overflow:auto>
<div class="mw-collapsible-content">
<div style="font-weight:bolder;line-height:1.8;">Insert data directly from the selected Excel cell</div>
<p align="left">This is how you insert data in text objects directly from a selected cell in Excel into Word with firesys: <br><br>
<div class="mw-collapsible-content">
</p><p align="left">
</p><ol>
  <li> <p align="left">In Excel, highlight the cell that you want to add to Word as a linked data object in body text.</p></li>  


  <li> <p align="left">Give the selected cell a name as otherwise it cannot be imported.</p></li>
<p align="left">This is how you insert data in text objects directly from a selected cell in Excel into Word with firesys: <br><br>
<ol>
<li> <p align="left">In Excel, highlight the cell that you want to add to Word as a linked data object in body text.</p></li>  


  <li> <p align="left">Save the Excel file.</p></li>
<li> <p align="left">Give the selected cell a name as otherwise it cannot be imported.</p></li>


  <li> <p align="left">Switch to the Word file and position the cursor where you want to insert the data from the selected cell.</p></li>  
<li> <p align="left">Save the Excel file.</p></li>


  <li> <p align="left">Click on the &ldquo;*Content&rdquo; tab in the &ldquo;Excel data&rdquo; group on the &ldquo;Insert&rdquo; menu, and select &ldquo;Directly from selected Excel cells&rdquo; or &ldquo;Directly from selected Excel cells as an absolute value&rdquo; under the section &ldquo;Data in text&rdquo.
<li> <p align="left">Switch to the Word file and position the cursor where you want to insert the data from the selected cell.</p></li>
  <br> &rarr;  The linktext assistant inserts the data from the highlighted Excel cell into your body text.</p></li>  
 
'''Reference:''' If several names have been given to the selected Excel range, the dialog will ask you to select the desired range.</li>  
<li> <p align="left">Click on the &ldquo;*Content&rdquo; tab in the &ldquo;Excel data&rdquo; group on the &ldquo;Insert&rdquo; menu, and select &ldquo;Directly from selected Excel cells&rdquo; or &ldquo;Directly from selected Excel cells as an absolute value&rdquo; under the section &ldquo;Data in text&rdquo.
  </p>
<br> &rarr;  The linktext assistant inserts the data from the highlighted Excel cell into your body text.</p></li>  
<br>
  '''Reference:''' If several names have been given to the selected Excel range, the dialog will ask you to select the desired range.</li>  
</ol>
</ol>
</center>  
</center>  
 
</div>
</div></div>
</div>

Aktuelle Version vom 8. August 2023, 10:20 Uhr


Insert data directly from the selected Excel cell

This is how you insert data in text objects directly from a selected cell in Excel into Word with firesys:

  1. In Excel, highlight the cell that you want to add to Word as a linked data object in body text.

  2. Give the selected cell a name as otherwise it cannot be imported.

  3. Save the Excel file.

  4. Switch to the Word file and position the cursor where you want to insert the data from the selected cell.

  5. Click on the “*Content” tab in the “Excel data” group on the “Insert” menu, and select “Directly from selected Excel cells” or “Directly from selected Excel cells as an absolute value” under the section “Data in text&rdquo.
    → The linktext assistant inserts the data from the highlighted Excel cell into your body text.


  6. Reference: If several names have been given to the selected Excel range, the dialog will ask you to select the desired range.