Editing Result Sets

Go Up to Using the Results Tab

The Results tab provides many ways to edit and customize your result windows. The Data Grid offers a host of features for manipulating, sorting and formatting data.

Topics

• Cutting, Copying, and Pasting Cell Contents
• Cutting, Copying, and Pasting Rows
• Cutting, Copying, and Pasting Columns
• Adding and Inserting Rows
• Adding and inserting columns
• Deleting Rows and Columns
• Resizing Rows and Columns
• Sorting Data

Cutting, Copying, and Pasting Cell Contents

The Result window supports standard cut, copy and paste functionality.

Cutting Cell Contents

To cut cell contents, do the following:

1. In the Results window, double click or tab to the target cell. A double line bounds the selected cell. You can also select text using standard text selection techniques.
2. On the Edit menu, select Cut.

Copying Cell Contents

To copy cell contents, do the following:

1. In the Results window, double click or tab to the target cell. A double line bounds the selected cell. You can also select text using standard text selection techniques.
2. On the Edit menu, select Copy.

Pasting Cell Contents

To paste cell contents, do the following:

1. In the Results window, double click or tab to the target cell. A double line bounds the selected cell.
2. On the Edit menu, select Paste.

Cutting, Copying, and Pasting Rows

You can perform standard cut, copy, and paste functions on rows, just as you can on individual cells.

Cutting Rows

To cut a row, do the following:

1. In the Results window, click the numbered row heading on the left side of the row.
2. On the Edit menu, select Cut.

Copying Rows

To copy rows, do the following:

1. In the Results window, double click or tab to the target row. A double line bounds the selected row. You can also select text using standard text selection techniques.
2. On the Edit menu, select Copy.

Pasting Rows

To paste rows, do the following:

1. In the Results window, double click or tab to the target row. A double line bounds the selected row.
2. On the Edit menu, select Paste.

Cutting, Copying, and Pasting Columns

You can perform standard cut, copy, and paste functions on columns, just as you can on rows.

Cutting Columns

To cut columns, do the following:

1. In the Results window, click the column heading above the first row.
2. On the Edit menu, select Cut.

Copying Columns

To copy columns, do the following:

1. In the Results window, click the column heading.
2. On the Edit menu, select Copy.

Pasting Columns

To paste columns, do the following:

1. In the Results window, click the column heading above the first row to select the target column.
2. On the Edit menu, select Paste.

Adding and Inserting Rows

You can add or insert rows to expand or rearrange your result sets.

Adding a Row

To add a row, do the following:

1. To add a row as the last row of the result set, position the pointer inside the result set.
2. On the Edit menu, select Add Row.
3. To add a row inside the result set, click the numbered row heading where you want to add a row.
4. On the Edit menu, select Add Row.

Inserting a Row

To insert a row, do the following:

1. To insert a row as the last row of the result set, position the pointer inside the result set.
2. On the Edit menu, select Insert Row.
3. To insert a row inside the result set, click the numbered row heading where you want to insert a row.
4. On the Edit menu, select Insert Row.

Adding and inserting columns

You can add or insert columns to expand or rearrange your result sets.

Adding a Column

To add a column, do the following:

1. Position the pointer inside the result set.
2. Select Edit, Add Column from the main menu. The new column is added as the last column of the result set.

Inserting a Column

To insert a column, do the following:

1. Select the column where you want to insert a column.
2. Select Edit, Insert Column from the main menu. The new column is inserted to the left of the column that you selected.

Deleting Rows and Columns

You can delete entire rows and columns to edit your result sets.

Deleting a Row

To delete a row, do the following:

1. Select the target row of data to delete.
2. On the Edit menu, select Delete Row.

Deleting a Column

To delete a column, do the following:

1. Select the target column of data to delete.
2. On the Edit menu, select Delete Column.

Resizing Rows and Columns

Resizing rows and columns can aid readability of the spreadsheet contents or condense space for editing and formatting purposes.

Resizing Rows to Their Default Height

To resize rows to their default height, do the following:

1. Select one or more rows by clicking on the numbered row headings to the left of the rows.
2. Right-click the selected rows, and then click Resize Rows.

Resizing Rows to a New Height

To resize rows to a new height, do the following:

1. Select one or more rows by clicking the numbered row headings to the left of the rows.
2. Change the pointer to a solid horizontal bar with arrows on top and bottom by moving it to one of the upper or lower borders of the row heading.
3. Click and grab the row border and drag the pointer to enlarge or shrink the height of the row.

Resizing Columns to Their Default Widths

To resize columns to their default widths, do the following:

1. Select one or more columns by clicking the column headings.
2. Right-click the selected columns, and then click Resize Columns.

Resizing Columns to a New Width

To resize columns to a new width, do the following:

1. Select one or more columns by clicking the column headings.
2. Change the pointer to a solid horizontal bar with arrows on top and bottom by moving it to one of the upper or lower borders of the column heading.
3. Click and grab the column border and drag the pointer to enlarge or shrink the height of the column.

Sorting Data

To order and organize data in a coherent manner, you can sort columns alphanumerically in single result sets.

Sorting Data

To sort data, do the following:

1. Double click the column header to sort the data in the column in ascending, alphanumeric order. To sort the column in descending order, double click the column header again.

Note: This option is not valid for multiple result sets.