Excel 2016 Tips and Tricks

Lesson 2 – Working with Tables

Excel 2016

P ROCEDURES

1. To select a table row, hover the mouse pointer just inside the left edge of the leftmost column in the row until appears. 2. Click to select the table row. 3. Select any cell to deselect the row. 4. To select the data in a table column, hover the mouse pointer just inside the top edge of the topmost row in the column until appears. 5. Click to select the column data. 6. To select the entire column, click the mouse button a second time. 7. Select any cell to deselect the column. 8. To select all the data in a table, hover the mouse pointer just inside the top- left corner of the top-left cell in the table until appears. 9. Click to select the table data. 10. To select the entire table, click the mouse button a second time. 11. Select any cell to deselect the table.

S TEP - BY -S TEP

Select parts of a table.

Steps

Practice Data

1. To select a table row, hover the mouse pointer just inside the left edge of the leftmost column in the row. The mouse pointer changes to a right-pointing arrow. 2. Click to select the table row. The table row is selected. 3. Select any cell to deselect the row. The cell is selected. column, hover the mouse pointer just inside the top edge of the topmost row in the column. The mouse pointer changes to a down-pointing arrow. 5. Click to select the column data. The column data is selected. 4. To select the data in a table

Point to the left edge of cell B8 until appears

Click the left mouse button

Click any cell

Point to the top edge of cell G3 until appears

Click the left mouse button

Page 40

OFFICEPRO, Inc.

Made with FlippingBook flipbook maker