Duplicate Data In Worksheets

BY STANLEY ZAROWIN

 »  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.

SPONSORED REPORT

Keeping client information safe in an age of scams and security threats

A look at the Dirty Dozen tax scams and ways to protect taxpayer information.

TAX PRACTICE CORNER

More R&D tax help

"Can I use the R&D credit?" PATH Act enhancements make the credit more attractive to a wider range of taxpayers.

QUIZ

Learn to choose between ‘who’ and ‘whom’

Writers can stumble over who and whom (or whoever and whomever). If you write for business, this quiz can help make your copy above reproach.