A data table consists of several main elements, each of them has its own settings. If a table element is selected, the settings determined on the side panel and on the Format ribbon tab will be applied to the selected element. When a single cell selected, the settings will be applied to the entire table.
NOTE. When a table element is selected, the group of tabs on the Table side panel is renamed according to the selected element:
• Header. When sidehead or heading is selected.
• Corner. When corner is selected.
• Table. When data cell or entire table is selected.
• Data. When all data cells are selected.
• Format. When a whole column or row is selected.
• Level. When dimension level element names are selected.
• Dimension. When dimension element names are selected.
• Totals. When totals cells, columns or rows are selected.
In the Time Series Analysis tool, use the Format group of tabs to work with a table and all its elements. This group does not change its name if any table element is selected.
Dimensions and levels are selected in the same way.
To select the entire table, execute one of the operations:
Select a data table cell, click the button and select the Entire Table item.
Select the Entire Table item in the drop-down list on the Format ribbon tab in the Current Section group.
Select a cell and press CTRL+A.
After executing the operations, the entire data table will be selected:
To select data, execute one of the operations:
Select a data cell, click the button and select the Data item.
Select the Data item in the drop-down list on the Format ribbon tab in the Current Section group.
After executing the operation, table data will be selected:
To select heading, execute one of the operations:
Select a data table cell, click the button and select the Heading item.
Select the Heading item in the drop-down list on the Format ribbon tab in the Current Section group.
After executing the operation, the table heading will be selected:
Another clicking the button selects a dimension arranged by columns.
To select sidehead, execute one of the operations:
Select any data table cell, click the button and select the Sidehead item.
Select the Sidehead item in the drop-down list on the Format ribbon tab in the Current Section group.
After executing the operation, the table sidehead will be selected:
Another clicking the button selects a dimension arranged by rows.
To select corner, execute one of the operations:
Click the table corner.
Select the Corner item in the drop-down list on the Format ribbon tab in the Current Section group.
After executing the operations, the table corner will be selected:
To select a single table element, select it by clicking the element header in the heading or sidehead:
See also:
Working with Data Table | Formatting Table and Its Elements | Table Elements Layout