Tips.Net > ExcelTips Home > Formatting > Copying Formatting
Copying Formatting
Summary: Use Format Painter to copy formatting in your spreadsheet. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)
Often it is beneficial to copy formatting from one place in your spreadsheet to another. Excel provides a shortcut for doing this:
- Select the cell that contains the formatting you want to copy.
- Click once on the Format Painter tool on the toolbar. (This tool has a small paintbrush on it.)
- Select the cell or range of cells that you want to have the same formatting as the cell you selected in step 1.
If you want to copy formatting to more than one location, then you can double-click on the Format Painter tool in step 2. When you are done copying, simply press Esc to indicate you are done.
Tip #1928 applies to Microsoft Excel versions: 97 2000 2002 2003
More Power! For some people, the prospect of creating macros can be scary. Those who conquer their fears, however, find they become much more confident and productive once they learn how to make Excel do exactly what they want. ExcelTips: The Macros is an invaluable source for learning Excel macros. You are introduced to the topic in bite-sized chunks, pulled from past issues of ExcelTips. Learn at your own pace, exactly the way you want.
Check out ExcelTips: The Macros today!
Perplexed by Pivots?
PivotTables don't need to be scary or mysterious. Use this powerful tool to analyze your data in ways you didn't know were possible. (more information...)
Helpful Links
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Bugs and Pests Tips
ExcelTips
Family Tips
Health Tips
Home Tips
Organizing Tips
WordTips
Advertise on the
ExcelTips Site