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.

TECHNOLOGY Q&A

How to create maps in Excel 2016

Microsoft Excel 2016 has two new mapping capabilities. J. Carlton Collins, CPA, demonstrates how to make masterful 2D and 3D maps in Excel 2016.

QUIZ

News quiz: IRS enforcement, a hot job, and audit value

The IRS’s 2016 Data Book, a “hot job” of particular interest at this time of year, and insight into how executive and audit committees view the insights from financial statement audits received attention recently. See how much you know with this short quiz.