Working with Tables

Tables present lists of data. There are two types of tables, main page tables and tables on pages. Tables provide many useful functions. For example, you can resize and rearrange their columns, sort their rows and copy the content of the cells to paste it elsewhere.

Main Page Tables

The following picture illustrates a main page table:

You can modify main page tables as follows:

  • Sorting Rows

    You can sort the rows in a table by the values in any column. When the table is sorted, you see a small arrow in the sort column header, pointing up for an ascending and down for descending sort.

    1. Click the column header.
    2. The entries are sorted in ascending order. This is indicated by an upwards arrow.
    3. Click the header again to sort the entries in descending order. This is indicated by a downwards arrow.

  • Changing the Column Order

    Select the column header to drag and drop the column to its end position. An indicator shows where the column will be dropped.

  • Changing the Column Width

    1. Move the cursor over the column header until the column separator icon appears over the right border of the column.
    2. Drag the icon until the column has the width you want and release the mouse.

  • Showing and Hiding Columns

    Many tables display only some of the available columns. Click the arrow icon on the upper right corner of the table header to open the list of all available columns.

    The columns that are currently included in the table are checked. The names of mandatory columns are dimmed and checked. You cannot hide mandatory columns.

    • Select a checked column to hide it.
    • Select an unchecked column to show it.

  • Copying and Pasting Cell Contents

    1. Select the content of the cell you want to copy and press Ctrl+C (copy) on your keyboard.
    2. Put the cursor in the field in which you want to paste the content.
    3. Press Ctrl+V (paste) on your keyboard.

Tables on Pages

Tables on pages contain a toolbar that lets you add, remove and arrange items. This picture illustrates one of these tables:

The following table functions are available

  • Adding rows

    Click the Add Row button

  • Enabling a row for editing

    Activate the checkbox on the first column of the row

  • Enabling all rows for editing

    Activate the checkbox on the header

  • Editing cells

    First enable the row for editing and then edit the contents of the cell

  • Removing rows

    Activate the row checkbox to make it editable and click the Remove button

  • Cutting/copying/pasting rows

    1. Activate one or more rows.
    2. Click Cut/Copy. This removes/copies the rows and copies them to the Clipboard.

    3. Click Paste. The rows are inserted at the bottom of the table.

  • Copying/pasting the content of cells

    1. Select the content of the cell and press Ctrl+C (copy)
    2. Put the cursor in the field in which you want to paste the content
    3. Press Ctrl+V (paste)

  • Moving rows up/down

    Activate one or more rows and click the button on the toolbar