Excel 2016 Tips and Tricks

Lesson – Working with Tables

Excel 2016

NOTE Dragging the table is a useful method if you only need to move it a few rows or columns. If you need to move the table to another area of the worksheet entirely, it is easier to use the Cut and Paste feature. If you drag a table over existing data in the worksheet, Excel displays the following message: Do you want to replace the contents of the destination cells? Click OK to overwrite the existing data or click Cancel to cancel the table move. If you drag a table to the left or right, you will probably need to adjust column widths to display the data correctly.



P ROCEDURES

1. Select any cell in the table. 2. Hover the mouse pointer over the top, bottom, left, or right edge of the table

until appears. 3. Hold down the mouse button and drag to the desired destination. 4. Release the mouse button.



S TEP - BY -S TEP

Move a table by dragging.

Steps

Practice Data

1. Select any cell in the table. The cell is selected.

Click cell C6

2. Hover the mouse pointer over the top, bottom, left, or right edge of the table. The mouse pointer changes to a white arrow with a four-headed black arrow at its tip. 3. Hold down the mouse button and drag to the desired destination. The table is selected as you hold down the mouse button and a shaded outline and a ScreenTip show the new position of the table as you drag.

Point to the top edge of

cell B3 until

appears

Drag the table 4 rows downwards to B7:J30

Page 42

OFFICEPRO, Inc.