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

Revenue recognition: A complex effort

Implementing the new standard requires careful judgment. Learn how to make significant accounting judgments and document them and collaborate with peers for consistent application.

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

News quiz: Taking an economic snapshot and looking to the future

Recent news included IRS actions that affect individuals and partnerships and a possibly influential move by a Big Four accounting firm.Take this short quiz to see how much you know about the news.