How To Mirror A Cell In Excel

How to mirror/link cells across worksheets in Excel?

Usually we can apply the formula =Sheet1!A1 to mirror the cell content in Cell A1 of Sheet1 to another worksheets. But this commodity provides much easier and more user-friendly ways to batch mirror or link cells/ranges across worksheets in Excel.

Mirror/link cells across worksheets with From Microsoft Query feature
Mirror same cell beyond multiple worksheets with Kutools for Excel
Mirror multiple ranges across multiple worksheets with Kutools for Excel

Mirror/link cells across worksheets with From Microsoft Query feature

This method will walk you through mirroring table of another workbook with the From Microsoft Query feature in Excel.

1. Click Data > From Other Sources > From Microsoft Query. Run across screenshot:
doc mirror cells across sheets 1

2. In the Choose Data Source dialog box, select the Excel Files* in the left box, and click the OK push button.
doc mirror cells across sheets 2

3. In the Select Workbook dialog box, please:
(1) Select the drive which contains the workbook you will mirror information from in the Drives drop down list;
(2) Double click to open the folder which contains the workbook y'all will mirror from in the Directories box;
(3) Click to highlight the workbook in the Database Proper name box.
(4) Click the OK button.
doc mirror cells across sheets 3

4. A alert dialog box volition comes out as below screenshot shown. Click the OK button to go alee.

v. Now Query Wizard opens. Click the Options push button to open up the Tabular array Options button, and then bank check the System Tables pick, and click the OK push. See screenshot:
doc mirror cells across sheets 5

6. Now yous return to the Query Wizard and worksheets are listing in the left box. Please expand the worksheet you will mirror information from in the left box, next click the column yous will mirror, and then click the doc mirror cells across sheets 8 button to add it to the right Columns in your query box. See screenshot:

Notation: you tin can mirror/add multiple columns from a specified worksheet to the Columns in your query box, and continue the following steps.

7. Click the Adjacent buttons repeatedly until the Import Data dialog box comes out. In the Import Data dialog box, please check the Tabular array option, adjacent specify the destination range yous will place the mirror data at, and click the OK button. See screenshot:

And now the specified columns from the specified workbook are mirrored and linked into current workbook.

Note: When you lot modify cell values, add together/delete rows in original workbook, the mirrored data in the destination range will change automatically later on clicking Data > Refresh All.

Mirror same cell across multiple worksheets with Kutools for Excel

This method will introduce Kutools for Excel's Dynamically Refer to Worksheets utility to batch mirror the same cell across multiple worksheets into a new worksheet in Excel.

Kutools for Excel - Includes more than 300 handy tools for Excel. Full feature complimentary trial xxx-day, no credit card required! Become It Now

one. Create a new worksheet with clicking the New button or in the Sheet Tab bar.

2. Select the jail cell in the new worksheet whose jail cell content you will copy from other worksheet, and click Kutools > More (in the Formula group) > Dynamically Refer to Worksheet. See screenshot:
doc dynamically refer to sheets 1

3. In the opening Make full Workbooks References dialog box, delight:
(1) Select the Fill Vertically cell afterward cell from the Fill guild drop downward list;
(2) In the Worksheet list section, check the worksheet where yous will mirror cell content from;
(iii) Click the Fill Range button and Close button successively.
doc mirror cells across sheets 12

And then y'all will run into the same cells from all specified worksheets are mirrored into the new worksheet. See in a higher place screenshot:

Kutools for Excel - Includes more than than 300 handy tools for Excel. Full characteristic free trial xxx-solar day, no credit menu required! Get It Now

Mirror multiple ranges across multiple worksheets with Kutools for Excel

This method will introduce Kutools for Excel'southward Impress Multiple Selections Magician utility to mirror multiple ranges from many worksheets as picture in a new worksheet.

Kutools for Excel - Includes more 300 handy tools for Excel. Full feature free trial 30-day, no credit card required! Get It Now

ane. Click Enterprise > Press > Impress Multiple Selections Wizard. Run into screenshot:
doc mirror cells across sheets 13

2. In the opening Print Multiple Selections Magician, click the Add button to add together ranges repeatedly, and so click the Stop button. See screenshot:
doc mirror cells across sheets 15

And and then you lot will run into all specified ranges from multiple worksheets are mirrored as pictures in a new worksheet.

Kutools for Excel - Includes more than 300 handy tools for Excel. Full feature free trial 30-day, no credit carte required! Get It Now

doc mirror cells across sheets 16

Demo: mirror/link cells or ranges across worksheets in Excel

Kutools for Excel includes more than 300 handy tools for Excel, free to try without limitation in 30 days. Download and Free Trial Now!

Related manufactures:

The Best Part Productivity Tools

Kutools for Excel Solves About of Your Problems, and Increases Your Productivity past eighty%

Reuse: Quickly insert circuitous formulas, charts and anything that yous have used earlier; Encrypt Cells with password; Create Mailing List and send emails...
Super Formula Bar (hands edit multiple lines of text and formula); Reading Layout (easily read and edit big numbers of cells); Paste to Filtered Range...
Merge Cells/Rows/Columns without losing Information; Split Cells Content; Combine Indistinguishable Rows/Columns... Foreclose Duplicate Cells; Compare Ranges...
Select Duplicate or Unique Rows; Select Blank Rows (all cells are empty); Super Find and Fuzzy Find in Many Workbooks; Random Select...
Exact Copy Multiple Cells without changing formula reference; Auto Create References to Multiple Sheets; Insert Bullets, Check Boxes and more...
Extract Text, Add together Text, Remove by Position, Remove Space; Create and Print Paging Subtotals; Convert Between Cells Content and Comments...
Super Filter (salvage and utilise filter schemes to other sheets); Advanced Sort past month/week/day, frequency and more; Special Filter past bold, italic...
Combine Workbooks and WorkSheets; Merge Tables based on key columns; Split up Information into Multiple Sheets; Batch Convert xls, xlsx and PDF...
More than 300 powerful features. Supports Function/Excel 2007-2019 and 365. Supports all languages. Easy deploying in your enterprise or organization. Full features 30-day free trial. lx-day coin back guarantee.

kte tab 201905

Part Tab Brings Tabbed interface to Office, and Make Your Work Much Easier

Enable tabbed editing and reading in Word, Excel, PowerPoint , Publisher, Admission, Visio and Project.
Open and create multiple documents in new tabs of the same window, rather than in new windows.
Increases your productivity by 50%, and reduces hundreds of mouse clicks for you every day!

officetab bottom