How do you enter the same data for multiple worksheets at the same time in Excel?

Source: Internet
Author: User

Excel everyone used it, his convenience is believed that everyone knows, then I now to share one of my experience: how excel in multiple worksheets in the same data entry. I hope everyone will be pointing fingers, and the bad places to communicate with each other.

1, first, open a new work table, double-click the desktop of the Excel icon, a new blank Excel work table.

2, click the window below to add a worksheet symbol, add a few new worksheets to explain the need.

3, then, hold down the CTRL key, then select just a few new work side, click "Sheet1" "Sheet2" and so on several tables, at the top will show "workgroup" a few words.

4, in the work form input you want to input into the content, any worksheet entered in the data will be in the other worksheets in the same location displayed.

5, after the input is completed, just use the CTRL key to select the right mouse button, select the "Cancel the team list" option. Then you'll see the effect you want.

6, and then click on each worksheet individually, you will find in each selected table, the same position appears in the same data.

Note: If you need to adjust, you need to set each table separately

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: and provide relevant evidence. A staff member will contact you within 5 working days.