Editing Result Sets
Go Up to Using the Results Editor
The Results Editor 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
Contents
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:
- 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.
- On the Edit menu, select Cut.
Copying Cell Contents
To copy cell contents, do the following:
- 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.
- On the Edit menu, select Copy.
Pasting Cell Contents
To paste cell contents, do the following:
- In the Results window, double click or tab to the target cell. A double line bounds the selected cell.
- 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:
- In the Results window, click the numbered row heading on the left side of the row.
- On the Edit menu, select Cut.
Copying Rows
To copy rows, do the following:
- 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.
- On the Edit menu, select Copy.
Pasting Rows
To paste rows, do the following:
- In the Results window, double click or tab to the target row. A double line bounds the selected row.
- 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:
- In the Results window, click the column heading above the first row.
- On the Edit menu, select Cut.
Copying Columns
To copy columns, do the following:
- In the Results window, click the column heading.
- On the Edit menu, select Copy.
Pasting Columns
To paste columns, do the following:
- In the Results window, click the column heading above the first row to select the target column.
- 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:
- To add a row as the last row of the result set, position the pointer inside the result set.
- On the Edit menu, select Add Row.
- To add a row inside the result set, click the numbered row heading where you want to add a row.
- On the Edit menu, select Add Row.
Inserting a Row
To insert a row, do the following:
- To insert a row as the last row of the result set, position the pointer inside the result set.
- On the Edit menu, select Insert Row.
- To insert a row inside the result set, click the numbered row heading where you want to insert a row.
- 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:
- Position the pointer inside the result set.
- 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:
- Select the column where you want to insert a column.
- 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:
- Select the target row of data to delete.
- On the Edit menu, select Delete Row.
Deleting a Column
To delete a column, do the following:
- Select the target column of data to delete.
- 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:
- Select one or more rows by clicking on the numbered row headings to the left of the rows.
- 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:
- Select one or more rows by clicking the numbered row headings to the left of the rows.
- 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.
- 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:
- Select one or more columns by clicking the column headings.
- 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:
- Select one or more columns by clicking the column headings.
- 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.
- 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:
- 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.