Lights, camera, format!

BY J. CARLTON COLLINS, CPA

Q: I know it is possible to paste-link Excel data into Microsoft Word so that any formatting changes I make to the original data are automatically reflected in the pasted data in Word, but is there also a way to paste-link Excel data into another Excel worksheet so that formatting changes made to the original data are automatically reflected in the paste-linked data on the second worksheet? So far I am unable to find a solution.

A: You are correct in that paste-linking Excel data into the same Excel workbook or another Excel workbook results in a data link to the original data, but not a formatting link to the original data. To achieve the effect you want, use Excel’s Camera tool as follows. Highlight the data to be copied, click the Camera tool (pictured below), then click the workbook area where you want the resulting image pasted.

 

Thereafter, the resulting Camera-pasted image will update automatically to reflect any data changes or formatting changes you make to the original data, as shown below.

 

Note: In Excel 2013, 2010, and 2007, the Camera tool is hidden. To access this tool, you must first add it to your Quick Access Toolbar (or Ribbon in Excel 2013 or 2010) by customizing your menus as explained in the January 2011 JofA Technology Q&A item “I Command You” (page 63).

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.