Selecting Data in Tables and Pivots
You can select different pieces of data in table and pivot visualizations depending on the level of granularity you need.
- To select an individual cell, click the cell itself.
- To select a block of cells, click a cell and drag your cursor to the adjacent cells.
- To select multiple cells, use Ctrl+ click as many cells as needed.
- To select a column, click the column header.
- To select a row in a table, use Shift+ click each cell in the row.
- To select a row in a pivot, click the first cell in the row.
When you select one or more cells in a table or pivot, you can right-click to access the full menu of options available for your selection.
For tables and pivots, you can use the Copy Data option to copy and paste only the data selected. If you don't select a row, column, or cell, then it functions the same as for other visualization types. See Copy and Paste a Visualization's Data.