Working with Excel Table offers several benefits that enhance data management, analysis, and visualization.

What do people know about Tables?

When we talk about working with Tables (ListObjects), many people think of the following points.

1. Automatic Formatting: Tables come with default formatting that makes data more readable
2. Structured References: Tables use structured references in formulas, making it easier to refer to data columns by their names (e.g., TableName[ColumnName]) rather than cell references. Also, each ListObject has a specific name in a workbook.
3. Total Row: Tables feature a total row that allows you to quickly add totals or perform calculations for each column

But there are other tricks to help you in your daily job when you manipulate Data.

Hidden Tips and Tricks with Excel Table

Select column, row or Table in one click

The steps to select a whole column is very simple

1. Move your mouse to the header of the column you want to select
2. When the cursor becomes a black arrow, click on it.
3. If you want to select the column + the header, click a second time

The process for the row is the same as the column (except the second clic).

Move column easily

1. Select column + header
2. Put your cursor on the edge of the selection
3. Drag & Drop

Columns A, B, C are replaced by the Table header 😮

1. The Active cell is inside the Table
2. When the header of the Table is NOT visible in the worksheet, automatically, the Columns header of Excel are the columns of the Table

Dynamic Reference when adding new data

1. Write any Excel function
2. Use the Table Reference as an argument
3. Add a new row to your Table
4. The formula is automatically updated

This is also with this technique that we can update chart series automatically.

Automatically copy your formula.

When you create a formula in the first row of your Table, Excel automatically copies it for the other rows

Related Articles

• Navigate Excel Columns Easily with this Free Add-In