How to Mirror Cells in Excel (With Example)

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


This particular formula will mirror the value in cell A1 of the sheet named Sheet1.

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

Example: How to Mirror Cells in Excel

Suppose we have the following dataset on Sheet1 that contains information about various basketball players:

Now suppose that we would like to mirror each of these cell values in Sheet2.

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


We can then click and drag this formula down to cell A11 and across to cell B11:

Excel mirror cell in another sheet

Now each of the cells from Sheet1 have been mirrored in Sheet2.

If we change any of the values in Sheet1, these changes will be reflected in the mirrored cells in Sheet2.

For example, suppose we change the last value in the Points column of Sheet1 to 10:

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

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

Additional Resources

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

Excel: How to Mirror Table on Another Sheet
Excel: How to Create a Floating Table
Excel: How to Lock a Table Reference

Featured Posts

Leave a Reply

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