Duplicate Data In Worksheets


 »  Key to Instructions  
To help readers follow the instructions in this article, we used two different typefaces: Boldface type is used to identify the names of icons, agendas and URLs. Sans serif type shows the names of files and the names of commands and instructions that users should type into the computer.


Q. Some of my Excel projects require me to input the same data on several worksheets. As you can imagine, it’s a time-consuming task. Since you’ve suggested so many handy shortcuts for other jobs, I wonder if you have one for this task?

A. You’re in luck. There’s a speedy way to enter data on multiple worksheets simultaneously. The trick is to group the worksheets in which you want the data entered. In fact, by grouping worksheets, you can also simultaneously enter both formatting and formulas—three solutions for the price of one.

To do this, you first have to understand the grouping function. You can group two or more consecutive worksheets (for example, January, February, March) or two or more nonconsecutive worksheets (January, March, 2001).

Let’s do the consecutive sheets first. Click on the tab of the first worksheet, and while holding down the Shift key, click on the tab of the last sheet in the group. That will group all the sheets between the first and last sheet tab.

To group nonconsecutive sheets (such as January, February, April), click on the tab of the first worksheet. This time, hold down the Ctrl button and click on any of the sheets you want included in the group. The worksheets you select will appear in white, as shown below.

Any data, formula or formatting you enter or apply in one worksheet will appear simultaneously in the other grouped worksheets.

To remove the grouping function, click any tab not in the group or right-click on any tab in the group and select Ungroup Sheets from the shortcut menu.


Implementing a global statutory reporting maturity model

Assess your organization's capabilities and progress toward an ideal state of global statutory reporting. Sponsored by Workiva.


Black CPA Centennial, 1921–2021

With 2021 marking the 100th anniversary of the first Black licensed CPA in the United States, a yearlong campaign kicked off to recognize the nation’s Black CPAs and encourage greater progress in diversity, inclusion, and equity in the CPA profession.