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



Discussion

No Comment Found