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:
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:
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.
The following tutorials explain how to perform other common operations in Excel: