Copy Formatting From One Excel Worksheet to Another

Have you ever taken the trouble to format a worksheet - adding bold to your titles, centering column headings, changing the number format to currency in some rows and comma format in others, changing the width of columns - and then wished you could just snap your fingers and take all that formatting over to another worksheet?

The process is actually performed almost as quickly as snapping your fingers. Here's how to copy all of your formatting (not the actual content of the cells, just how they look) from one sheet to another:

 

  1. Click on the Select All button in the upper left corner of the worksheet that contains the desired formatting. [The Select All button is the little gray square above row number 1 and to the left of column A.]

     

  2. Click on the Format Painter button on the Standard toolbar. [The Format Painter button is the one with the paintbrush.]

     

  3. Click on the sheet tab at the bottom of the screen for the sheet that is to receive the formatting, or open another Excel file that you want to format.

     

  4. Click on the Select All button in the new sheet. Presto! All of your formatting has transferred!

View more helpful tips!

You may like these other stories...

By Jason Bramwell When CPA Barry MacQuarrie started the SocialCPAs Social Media Survey in 2010, he said social networking was still relatively new to the accounting profession. The self-proclaimed "social media...
By Jason Bramwell In an effort to address the increased demand for comprehensive and intensive training on eXtensible Business Reporting Language (XBRL), the American Institute of CPAs (AICPA) and XBRL US Inc., the not-...
By Lauren Prosser, Director of ProfitCents Professional Services, Sageworks Staffing is among the top management issues facing CPA firms, according to a recent survey by Sageworks, a financial information company. That...

Already a member? log in here.

Upcoming CPE Webinars

Aug 26
This webcast will include discussions of recently issued, commonly-applicable Accounting Standards Updates for non-public, non-governmental entities.
Aug 28
Excel spreadsheets are often akin to the American Wild West, where users can input anything they want into any worksheet cell. Excel's Data Validation feature allows you to restrict user inputs to selected choices, but there are many nuances to the feature that often trip users up.
Sep 9
In this session we'll discuss the types of technologies and their uses in a small accounting firm office.
Sep 11
This webcast will include discussions of commonly-applicable Clarified Auditing Standards for audits of non-public, non-governmental entities.