| 1. |
How Do I Copy A Whole Row Or Multiple Rows Of Data? |
|
Answer» To copy one row of data, PUT your cursor in a cell in the grid and press Ctrl+Insert. This will copy the row and its column HEADERS to the clipboard. To copy multiple rows of data, right-click in the grid and choose "Allow multiselect". Use Shift-Click to select multiple ADJACENT rows, or use Ctrl+Click to select individual, non-adjacent rows. Press Ctrl+C. This will copy all of the rows and their column headers to the clipboard. To copy a single cell's data, turn off "Allow multiselect". Click on the cell you want to copy and press Ctrl+C. The FOLLOWING table gives details of what happens with the various copy KEYS and multi-select options. Multi-Select OFF Multi-Select ON EDIT COPY CTRL+C CTRL+INS EDIT COPY CTRL+C CTRL+INS One Cell Highlighted Cell only Cell only Row plus headings Cell only Cell Only Row plus headings Many Cells(rows) highlighted N/A N/A N/A All highlighted rows plus headings All highlighted rows plus headings All highlighted rows plus headings To copy one row of data, put your cursor in a cell in the grid and press Ctrl+Insert. This will copy the row and its column headers to the clipboard. To copy multiple rows of data, right-click in the grid and choose "Allow multiselect". Use Shift-Click to select multiple adjacent rows, or use Ctrl+Click to select individual, non-adjacent rows. Press Ctrl+C. This will copy all of the rows and their column headers to the clipboard. To copy a single cell's data, turn off "Allow multiselect". Click on the cell you want to copy and press Ctrl+C. The following table gives details of what happens with the various copy keys and multi-select options. Multi-Select OFF Multi-Select ON EDIT COPY CTRL+C CTRL+INS EDIT COPY CTRL+C CTRL+INS One Cell Highlighted Cell only Cell only Row plus headings Cell only Cell Only Row plus headings Many Cells(rows) highlighted N/A N/A N/A All highlighted rows plus headings All highlighted rows plus headings All highlighted rows plus headings |
|