Manage columns

1. Select and right-click the column, then select Column > Reorder Columns.
2. In the Available Columns list, select the column to move. Click Tap the up or down arrow on the right until the column is in the correct position. Moving a column up in the list moves it to the left in the report. Moving a column down in the list moves it to the right in the report.
3. Click Tap OK.

1. Select and right-click the column.
2. Select Column > Delete Column.

To remove multiple columns, press Ctrl and select each column.

1. Select and right-click a column.
2. Select Column > Hide Column.

1. Select and right-click a column.
2. Select Column> Show Column. The Show Columns glance lists the hidden columns.
3. In the Pick Hidden Column box, select the column to display.
4. Click Tap OK.

1. Select the column.
2. Place the cursor on the right or left border of the highlighted column.
3. Using the cursor, drag the border inwards or outwards to increase or decrease the width of the selected column.

You can merge the data from two or more columns into one column. When you merge data, the data appears on multiple lines. Merging data also enables you to include more columns in a table without exceeding the width of a page.

To merge data into one column:

1. Press Ctrl and select each column that contains the data to merge.
2. Right-click and select Column > Merge Columns.

When you merge data from multiple columns, the column headers appear on multiple rows. You can improve the format by merging the column headers and editing the remaining column header title. To merge column headers:

1. Select and right-click the column header in the bottom row.
2. Select Cell > Merge Up.
3. Add a new column header row
4. Repeat steps 1 and 2 until only one column header remains.

The actions you can make on a merged column include modifying font, specifying conditional formatting rules, formatting data strings, creating filters, and so on, similar to actions you can make on an unmerged column.

When working with a merged column:

1. Select and right-click the column, then select a modification option.
2. In the Select Data Item dialog box, the drop-down list contains a list of columns in the merged column. Select a column for which you want to perform an action, such as formatting, or filtering.
3. When finished click OK.
4. Repeat the process for every column in the merged column.

If you need to add more text or more space in the header area, you can add multiple column header rows.

When you insert a column header row, to be able to display text that spans multiple columns, you must merge the columns in that row. You also can add a border to the new row.

To add a new column header row

1. Select and right-click a column header then select Row.
2. To add a row above the selected column header, select Insert Row Above. To add a row below the selected column header, select Insert Row Below.

A new row appears in the position you specified. The row has the same number of columns and the same column widths as the row that follows.

To merge column headers to type text that spans multiple columns:

1. Select and right-click the column header, then select Cell > Merge Right. The first cell merges with the second cell to become a single, wider cell.
2. Repeat step 1 to merge all cells in the column
3. To type text in this cell, select and right-click the cell, select Edit Text, type the text, and then press Enter.
4. To add borders:
   1. Select and right-click the cell. Select Format> Border.
   2. In the Border dialog box, specify the type of border or borders to add. You can set the border style, color, and width.
5. Click OK.