Excel 2016 Tips and Tricks

Excel 2016

Lesson 2 – Working with Tables

Although Tables automatically resize when you add data in adjacent rows and columns, you may prefer to manually resize a Table before entering new data. You can resize a Table by dragging the sizing handle in the lower right corner of the Table or by selecting the Resize Table button in the Properties group on the Design tab and entering the new Table range. When the total row is displayed, the sizing handle is not available but you can use the Resize Table button.

Adding table rows and columns

NOTE You can also add new rows of data by selecting the bottom, right-hand data cell and pressing [Tab] . A new, blank row is added to the table and the first cell in the new row is selected ready for you to type new data. You can use this method even with the totals row displayed; Excel adds the new row between the existing data and the totals row. You can also use the [Tab] key to move from cell to cell in the row as you enter the new data. When you reach the end of the row, pressing [Tab] once more adds another new row. When you use the [Tab] method to add new data rows, if you have data stored in cells below the table, Excel automatically shifts any data below the table down, when it reaches the first row containing such data.

OFFICEPRO, Inc.

Page 33