Excel Table Secrets to increase your Data Manipulation

Last Updated on 20/02/2024
Reading time: 2 minutes

Working with Excel Table (also known as ListObjects) offers several benefits that enhance data management, analysis, and visualization.

What do people know about Tables?

Menu Insert Table

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
Basic knowledge of the benefits of working with a Table

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 exactly the same as the column (except the second clic)
  • To select the whole table, you must go to the very first cell of your Table. Wait until you see a diagonal black arrow.
Tips and Tricks to select column row and Table

Move column easily

  1. Select column + header
  2. Put your cursor on the edge of the selection
  3. Drag & Drop
Move Row or Column in a Table

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
New header with a 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
Automatically update formula because of the Table Reference

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

Automatic Copy formula

Leave a Reply

Your email address will not be published. Required fields are marked *

Excel Table Secrets to increase your Data Manipulation

Reading time: 2 minutes
Last Updated on 20/02/2024

Working with Excel Table (also known as ListObjects) offers several benefits that enhance data management, analysis, and visualization.

What do people know about Tables?

Menu Insert Table

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
Basic knowledge of the benefits of working with a Table

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 exactly the same as the column (except the second clic)
  • To select the whole table, you must go to the very first cell of your Table. Wait until you see a diagonal black arrow.
Tips and Tricks to select column row and Table

Move column easily

  1. Select column + header
  2. Put your cursor on the edge of the selection
  3. Drag & Drop
Move Row or Column in a Table

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
New header with a 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
Automatically update formula because of the Table Reference

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

Automatic Copy formula

Leave a Reply

Your email address will not be published. Required fields are marked *