Do you use the format painter? I do! I use this feature all the time in Excel and I find it saves so much time.
The format painter is on the home tab and it looks like a little paintbrush. The purpose of the format painter is to copy the exact formatting of one field, column, row, or sheet to another field, column, row, or sheet.
For example, let’s say you have a column in your spreadsheet and you have borders, fonts, font sizes, and column sizing formatted exactly the way you want it. Now you have another column of data that you want to look identical. Simply select the first column, click the format painter icon, and then select the second column. This will copy formatting, but not values.
This is especially helpful when you are trying to keep your branding across reports.
If you are an Advocate Capital customer and need help preparing or manipulating data in the Excel application, feel free to contact me at [email protected].
Here at Advocate Capital, Inc., we are constantly looking for ways to improve. We love feedback from our customers and implement suggestions often. If you have a question or idea for an Excel tip that you would like to see, please let us know!
Photo Credit:Cathy Yeulet