#342 Ten Reasons to Use Excel Tables

Converting your Excel data into a table gives you some very useful ways to work more efficiently and effectively. Here are ten reasons you should consider using a table instead of an ordinary data range in Excel.

To create a table, click anywhere inside the data range and click Table in the Tables group on the Insert tab.

1: Easy sorting and filtering

Excel automatically adds filter controls to the header row when you convert a range into a table.

2: Quick formatting

Excel automatically applies a banded row format to new tables.

3: Effortless data entry

You can easily extend a table, making data entry much easier.

4: Automatic nomenclature

When entering formulas, you use cell references and range names. When working with a table, Excel works all that out for you.

5: Quick totals

Want a quick order count? With a table simply click a check-box to add a Totals row.

6: Always visible headers

In a data range, header cells disappear as you scroll, but table headers are always visible — with absolutely no work on your part

7: Formula autofill

When you extend a table to include a new row, it doesn’t just extend the formatting (#3). The table will also copy any formulas.

8: No copy necessary

You can further automate #7 by allowing the table to copy the formula when you enter it.

9: Dynamic charts

If you base a chart on a table, Excel will update the chart automatically as you change and enter new data into the table.

10: One-click select

You select an entire table with a single click.

For details on these visit this excellent Tech Republic article

Advertisements

3 thoughts on “#342 Ten Reasons to Use Excel Tables

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s