Selecting a large data table by highlighting and dragging the mouse can sometimes be difficult in Microsoft Excel, especially with a large amount of data. Excel 2010 makes it easy to select an entire data table using one keystroke.
To select a data table:
- Select any cell within your table of data.
- Press Ctrl + A
Note: the entire data set (all rows and columns) will be highlighted
For more excel techniques see our Excel Training Class.