Click or drag to resize

Selection of columns and/or rows in a worksheet

Previous section: Creating additional data columns or property columns

This topic contains the following sections:

For plotting commands, you need to select the data columns to plot. For copy command, you need to select data columns, data rows and property columns that you want to copy. For paste operations, you need to specify the place where the data should be pasted.

For all this, you should be able to select specific data columns, data rows or property columns.

In Altaxo, it is possible to select data columns, property columns and data rows, concurrently.

To select data columns:

  • Click in the column header of the first data column you want to select, without pressing any key on the keyboard. The background color of the selected column changes to blue.

  • SHIFT-click in the column header of the last data column you want to select. All columns between the first selected column and the column selected now are selected now, indicated by the blue background color. (SHIFT-click means holding the SHIFT key on the keyboard pressed while clicking the left mouse button).

  • Additional columns can be selected by CTRL-click in the column header of data columns that are not already selected yet. CTRL-click in the column header of an already selected column to deselect it. (CTRL-click means holding the CTRL key on the keyboard pressed while clicking the left mouse button).

If you now have only data columns selected, as described above, all data rows and all property column cells are affected by the operation.

To select specific data rows:

  • Click in the data row header of the first data row you want to select. If data columns or property columns are selected already, you should use CTRL-click instead, in order to keep the existing selection(s).

  • SHIFT-click in the row header of the last data row you want to select.

  • Additional data rows can be selected by using CTRL-click in the row header of data rows that are not selected yet. Likewise, CTRL-click in the row header of already selected data rows will unselect them.

To select specific property columns:

  • Click in the property column header of the first property column you want to select, without pressing any key on the keyboard. The background color of the selected column changes to blue. If you already have data columns or data rows selected, you should use CTRL-click instead, in order to keep the existing selection(s).

  • SHIFT-click in the property column header of the last property column you want to select. All property columns between the first selected property column and the property column selected now are selected, indicated by the blue background color.

  • Additional property columns can be selected by CTRL-click in the column header of property columns that are not already selected yet. CTRL-click in the property column header of an already selected property column to deselect it.

Example of a selection

The Figure above shows the result after you:

  • Clicked on the data column header of data column B

  • SHIFT-clicked on the data column header of data column D (to select columns B, C, and D)

  • CTRL-clicked on data column header of column F (to additionally select data column F)

  • CTRL-clicked on the property column header of property column B (to select it)

  • CTRL-clicked on the data row [2] (to first select data row 2)

  • SHIFT-clicked on data row [4] (to selected data rows 2 to 4)

  • CTRL-clicked on the data row [7] (to additionally select data row 7)