The easiest way to mirror a table on another sheet in Excel is by typing the following formula into the cell where you want the existing table to be mirrored:

=Table1[#All]

This particular formula will mirror the table named **Table1**, including the headers of the table.

**Note:** The syntax **[#All]** tells Excel to include the headers as well.

The following example shows how to use this formula in practice.

**Example: How to Mirror Table on Another Sheet in Excel**

Suppose we have the following table named **Table1** on **Sheet1** that contains information about various basketball players:

Now suppose that we would like to mirror this table on **Sheet2**.

To do so, we can type the following formula into cell **A1** of **Sheet2**:

=Table1[#All]

This will cause the table from **Sheet1** to be exactly mirrored onto **Sheet2**:

If we change any of the values in the original table, these changes will be reflected in the mirrored table.

For example, suppose we change the last value in the **Points** column of **Table1** to **50**:

This change will automatically be reflected in the mirrored table on **Sheet2**:

Any other changes that you make to the original table will automatically be reflected in the mirrored table.

**Additional Resources**

The following tutorials explain how to perform other common operations in Excel:

How to List All Table Names in Excel

How to Lock a Table Reference in Excel

How to Create a Table of Contents in Excel Sheet