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

How the election may affect taxation of business income

This report summarizes recent proposals to reform the U.S. business income tax system and considers the path to enactment of any such legislation.

VIDEO

How to Excel pivot a general ledger

The general ledger is a vast historical data archive of your company's financial activities, including revenue, expenses, adjustments, and account balances. J. Carlton Collins, CPA, shows how to prepare data for, and mine data with, PivotTables.

QUIZ

Did you follow 2016’s biggest accounting news?

CPAs will remember 2016 as a year of new standards and new faces. How well did you follow the biggest accounting events? The 7 questions in this quiz will help you find out