Tip: Other languages are Google-Translated. You can visit the English version of this link.
Log in


How to synchronously input or select cells across multiple sheets?

In Excel, to select or input a value into one cell is very simple, but how about synchronously selecting or inputting value to same cells across sheets in a workbook? Here I introduce the quick tricks on solving this problem.

Synchronize input cells across sheets

Synchronize select same cells across sheets good idea3

goodSynchronize Worksheets

With Kutools for Excel's Synchronize Worksheets, you can select the same cell or same range across multiple sheets in a workbook. See screenshot:
doc synchronize sheets

arrow blue right bubble Synchronize input cells across sheets

In Excel, to synchronously input cells across multiple sheets, do as below:

1. Enable the workbook you need, and then hold Ctrl key to select the sheet tabs that you want to synchronously input values, see screenshot:
doc sychronize cell 1

2. Then select a cell in active sheet, and input the value you want. See screenshot:
doc sychronize cell 2

Then you can see every cell B10 in the selected sheets has been input same value. See screenshot:
doc sychronize cell 3

Tip: If you want to automatically update the cells, you can do as below:

1. Select a sheet, Sheet 1 for example, and select one cell, for instance, B10, and then enter the value you want, see screenshot:
doc sychronize cell 4

2. Hold Ctrl key to select all sheet tabs you will synchronize cells excluding the Sheet1, go to one selected sheet, and enter this formula =Sheet1!B10 into the cell B10, see screenshot:
doc sychronize cell 5

3. Press Enter key, now all B10 in selected sheets will be changed as B10 in Sheet1 changes.

arrow blue right bubble Synchronize select same cells across sheets

If you want to synchronously select same cells across sheets in the workbook, you can apply Kutools for Excel’s Synchronize Worksheets utility.

Kutools for Excel, with more than 120 handy Excel functions, enhance your working efficiency and save your working time.

After free installing Kutools for Excel, please do as below:

Select the cell you want to synchronously select across sheets in the active sheet, F1 for instance, and click Enterprise > Worksheet > Synchronize Worksheets. See screenshot:
doc sychronize cell 6

Now, every F1 in each sheet has been selected.
doc synchronize cells 7

doc download 1

Recommended Productivity Tools for Excel

Kutools for Excel Helps You Always Finish Work Ahead of Time, and Stand Out From Crowd

  • More than 300 powerful advanced features, designed for 1500 work scenarios, increasing productivity by 70%, give you more time to take care of family and enjoy life.
  • No longer need memorizing formulas and VBA codes, give your brain a rest from now on.
  • Become an Excel expert in 3 minutes, Complicated and repeated operations can be done in seconds, 
  • Reduce thousands of keyboard & mouse operations every day, say goodbye to occupational diseases now.
  • 110,000 highly effective people and 300+ world-renowned companies' choice.
  • 60-day full features free trial. 60-day money back guarantees. 2 years of free upgrade and support.

Brings Tabbed Browsing and Editing to Microsoft Office, Far More Powerful Than The Browser's Tabs

  • Office Tab is designed for Word, Excel, PowerPoint and Other Office Applications: Publisher, Access, 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!
Say something here...
symbols left.
You are guest ( Sign Up? )
or post as a guest, but your post won't be published automatically.
Loading comment... The comment will be refreshed after 00:00.

Be the first to comment.