If you’re like most people, you probably use Microsoft Excel to manage your data. And if you’re like most people, you probably don’t have a lot of time to spend formatting your data. That’s where Format Painter comes in. Format Painter is a free tool that lets you quickly and easily format your data in Excel. You can use it to change the font, color, size, and alignment of your data cells. You can also add borders and other effects to your cells. Format Painter is easy to use and it doesn’t require any special skills or knowledge. All you need is a copy of Excel and Format Painter installed on your computer. ..
On any Excel worksheet, click on the cell with the formatting you’d like to copy. You will see dashed lines around the selected cell. Then select the Home tab and click on the Format Painter.
You’ll see your cursor now includes a paintbrush graphic. Move to the cell where you’d like to apply the formatting and click on it.
Your target cell will now have the new formatting.
If you double-clicking on Format Painter you can then click on multiple individual files to which to apply the format. Or, you can click and drag across a group of cells. When you are finished applying formats, click on Format Painter again, or on the Esc key, to turn it off.
The Format Painter is a very simple, but extremely useful and time saving tool when creating complex worksheets.
