Excel 2016 Tips and Tricks

Excel 2016

Lesson – Working with Tables

Steps

Practice Data

6. To select the entire column, click the mouse button a second time. The entire column is selected. 7. Select any cell to deselect the column. The cell is selected. 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. The mouse pointer changes to an arrow pointing down and to the right.

Click the left mouse button

Click any cell

Point to the top-left corner of cell B3 until appears

9. Click to select the table data. The table data is selected.

Click the left mouse button Click the left mouse button

10. To select the entire table, click the mouse button a second time. The entire table is selected. 11. Select any cell to deselect the table. The cell is selected.

Click any cell

M OVING A T ABLE  D ISCUSSION

You can select and move a table within a worksheet in one easy step by dragging it. All table formatting moves with the table and formulas outside the table that reference data within the table will adjust their references accordingly.

OFFICEPRO, Inc.

Page 41