How Do You Use The Format Painter In Excel?
The Format Painter button is one of the most useful buttons in Excel. By using the Format Painter button, a person can easily transfer over the formatting properties from one cell to another. This feature can save a lot of time in formatting cells in Excel. Here is how to use the Format Painter in Excel. Open an Excel spreadsheet. You can either open an existing Excel spreadsheet or create a new one. Change the formatting in one of the cells. Select a cell with text (or type in text) and then make several changes to the formatting. For example, make the text bold, centered and purple. Type text in another cell. Do not make any formatting changes to this text. Click on the cell with the formatting you want to copy. In the above example, you would click on the cell with the text that is now bold, centered and purple. The cell has a darker border around it to show that it is selected. Locate the Format Painter button. The Format Painter button looks like a paintbrush and is located on the
