A Better Idea

BY STANLEY ZAROWIN

In the March column a reader asked for an easy way to custom-format 24 worksheets. I suggested two ways: Use the Group command on all the worksheets, so any format action done to one will automatically affect the others, too, or create a template.

Marsha Troy, a CPA from Shawnee, Kan., suggests a third way—with Format Painter ( ). Here are the steps: Highlight the entire worksheet whose formatting you want to copy by clicking on the white cell to the left of column A and above row 1 (see screenshot) and then on the Format Painter .

Open a new worksheet and click on the cell to the left of A and above 1, and all the formatting will be duplicated.

SPONSORED REPORT

Building client loyalty with payroll services

In this report, CPA experts detail their tactics for performing successful payroll services, how to mitigate risk in the process, and the impact payroll can have as a value-added service.

PODCAST

Using drones to enhance audits

Hermann Sidhu, CPA, global assurance digital leader at EY, walks us through EY’s exciting new project to use drones to help audit large warehouses and outdoor inventories.