Edit automated worksheet: Unterschied zwischen den Versionen

Aus firesys Hilfe
Zur Navigation springen Zur Suche springen
Keine Bearbeitungszusammenfassung
Keine Bearbeitungszusammenfassung
 
(15 dazwischenliegende Versionen von 2 Benutzern werden nicht angezeigt)
Zeile 1: Zeile 1:
Text folgt.  
Processes the automated worksheet. Text, number columns and other master value columns can be added. The definition of the columns on the worksheet can also be adjusted.




<imagemap>Datei:EN_Excel Menüband Inhalt Zentralwerte Bearbeiten.jpg|center|1200px
[[Datei:EN_Menüband_Excel_Inhalt_Zentralwerte_Bearbeiten.jpg|center|1200px]]


desc none
</imagemap>


[[Datei:EN_Excel_Inhalt_Automatisiertes_Arbeitsblatt_bearbeiten.jpg|upright=2.0]]<br/>
 
 
== Definition ==
To edit an automated worksheet later on, click on the “*Contents” menu on the “Edit” button in the “Master values” group. The following task pane opens:
[[Datei:EN_Excel_Inhalt_Automatisiertes_Arbeitsblatt_bearbeiten.jpg||mini|upright=2.0|300px|The task pane of editing automated worksheets.]]
 
=== [[File:Firesys Icons BubbleTransparent 1 white background.png|link=|24px]] Ribbon ===
 
====[[Datei:Image.Cell.SaveAndClose.32.png|16px]] Save and close ====
 
Saves the changes, updates the worksheet and closes the task pane.
 
====[[Datei:RxbtnCellCreateUpdateCompare_32.png|16px]] Update task pane ====
 
Updates the contents of the task pane if changes have been made to the worksheet subsequently.
 
=== [[File:Firesys Icons BubbleTransparent 2 white background.png|link=|24px]] Worksheet name ===
Displays the name of the automated worksheet.
 
=== [[File:Firesys Icons BubbleTransparent 3 white background.png|link=|24px]] Account group ===
Displays the selected account group from which key date data is inserted in the number columns.
The account group can be subsequently changed for the automated worksheet.
 
=== [[File:Firesys Icons BubbleTransparent 4 white background.png|link=|24px]] Text column ===
==== [[Datei:Image-Common-Plus.48.png|16px]] Add text column ====
Add the column selected in the worksheet as a text column.
A set of two pieces of information is created, which can be defined subsequently.
 
====[[Datei:Image-Common-Remove-X.png|16px]] Remove text column ====
Removes the selected text column from the definition.
 
==== List area ====
Displays the defined text columns. Two parameters belong to each text column.
* <b>text column</b> - column in which the texts are displayed on the worksheet.
* <b> master value column</b> - master value column from which the numbers are to be provided.
By clicking on the button the selection can be taken over on the worksheet as text or master value column.
 
=== [[File:Firesys Icons BubbleTransparent 5 white background.png|link=|24px]] Columns ===
==== [[Datei:Image-Common-Plus.48.png|16px]]Add column of numbers ====
Add the column selected in the worksheet as a column of numbers.
A set of three pieces of information is created, which can be defined subsequently.
 
====[[Datei:Image-Common-Remove-X.png|16px]] Remove column of numbers ====
Removes the selected text column from the definition.
 
==== List area ====
Displays the defined number columns. There are three parameters for each number column:
* <b>number column</b> - column in which the numbers are displayed on the worksheet.
* <b> master value column</b> - master value column from which the numbers are to be provided.
* <b> key date</b> - Shows the key date from which the values are to be provided in the number columns.
By clicking on the button, the selection can be taken over on the worksheet as numbers or master value column; in addition, the key date can be adjusted per number column.
 
 
== Video: Edit automated worksheet==
{{Vorlage:Video-Automatisiertes Arbeitsblatt bearbeiten-English}}
 


== See also  ==
== See also  ==


[[Datei:Navigation_hoch.svg|link=]]  [[Automated_worksheet|Automated worksheet]] <br>
[[Datei:Navigation_hoch.svg|link=]]  [[Automated_worksheet|Automated worksheet]] <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Insert_automated_worksheet|Insert automated worksheet]] <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Automate_worksheet|Automate worksheet]] <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Automate_worksheet|Automate worksheet]] <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Detach_automated_worksheet|Detach automated worksheet]] <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Detach_automated_worksheet|Detach automated worksheet]] <br>
[[Datei:Navigation_rechts.svg|link=]]  [[Insert_autotable|Insert autotable]] <br>
 


{{MoreContent}}
{{MoreContent}}
[[Kategorie:English-Excel Automate-worksheet]]
[[Kategorie:English-Excel Automate-worksheet]]

Aktuelle Version vom 19. November 2021, 13:29 Uhr

Processes the automated worksheet. Text, number columns and other master value columns can be added. The definition of the columns on the worksheet can also be adjusted.


EN Menüband Excel Inhalt Zentralwerte Bearbeiten.jpg



Definition

To edit an automated worksheet later on, click on the “*Contents” menu on the “Edit” button in the “Master values” group. The following task pane opens:

The task pane of editing automated worksheets.

Firesys Icons BubbleTransparent 1 white background.png Ribbon

Image.Cell.SaveAndClose.32.png Save and close

Saves the changes, updates the worksheet and closes the task pane.

RxbtnCellCreateUpdateCompare 32.png Update task pane

Updates the contents of the task pane if changes have been made to the worksheet subsequently.

Firesys Icons BubbleTransparent 2 white background.png Worksheet name

Displays the name of the automated worksheet.

Firesys Icons BubbleTransparent 3 white background.png Account group

Displays the selected account group from which key date data is inserted in the number columns. The account group can be subsequently changed for the automated worksheet.

Firesys Icons BubbleTransparent 4 white background.png Text column

Image-Common-Plus.48.png Add text column

Add the column selected in the worksheet as a text column. A set of two pieces of information is created, which can be defined subsequently.

Image-Common-Remove-X.png Remove text column

Removes the selected text column from the definition.

List area

Displays the defined text columns. Two parameters belong to each text column.

  • text column - column in which the texts are displayed on the worksheet.
  • master value column - master value column from which the numbers are to be provided.

By clicking on the button the selection can be taken over on the worksheet as text or master value column.

Firesys Icons BubbleTransparent 5 white background.png Columns

Image-Common-Plus.48.pngAdd column of numbers

Add the column selected in the worksheet as a column of numbers. A set of three pieces of information is created, which can be defined subsequently.

Image-Common-Remove-X.png Remove column of numbers

Removes the selected text column from the definition.

List area

Displays the defined number columns. There are three parameters for each number column:

  • number column - column in which the numbers are displayed on the worksheet.
  • master value column - master value column from which the numbers are to be provided.
  • key date - Shows the key date from which the values are to be provided in the number columns.

By clicking on the button, the selection can be taken over on the worksheet as numbers or master value column; in addition, the key date can be adjusted per number column.


Video: Edit automated worksheet


A detailed explanation of the individual steps

How to assign a new master value column to a value column:

  1. Open the automated worksheet in which a value column is to be assigned to a new master value column.

  2. Click on the "Edit" button in the "Master values" group in the "*Contents" ribbon.
    → The "Definition" task pane opens on the right.

  3. Click on any cell in the column that is to become the new master value column.

  4. In the task pane, select the column that is to be modified and click the button in the "Master value column" row.
    → The name of the new master value column is now displayed in the row.

  5. Save the changes by clicking on the "Disk" in the upper left corner of the task pane.
    → The newly assigned master value column is grayed out and can now be filled.


See also

Navigation hoch.svg Automated worksheet
Navigation rechts.svg Insert automated worksheet
Navigation rechts.svg Automate worksheet
Navigation rechts.svg Detach automated worksheet


Further contents

firesys website
Customer area
YouTube