The formatting that has been copied will include number formatting, alignment, font, border, and patterns. When you let go of the left mouse button, you will see that the formatting from cell A3 has been copied to the selected range (D3:D5). This is done by selecting cell D3 with the left mouse button and then dragging down (while holding the left mouse button) until the full range has been selected. In this example, we have selected cells D3 to D5. Now, select the cells that you wish to apply the copied format to. Then select the Home tab in the toolbar at the top of the screen and click on the Format Painter button in the Clipboard group.Ĭell A3 should become highlighted with a green dashed border around it and you will see the following message appear in the status bar at the bottom of the Excel window: "Use the mouse to apply the copied format to another object". In this example, we have selected cell A3. Let's look at an example of how to use the Format Painter in Excel 2016.įirst, select the cell that has the formatting that you wish to copy. It is a quick and easy way to apply your existing formatting without having to manually set up the the number formatting, alignment, font, border, and patterns for the cells. The Format Painter allows you to copy formatting from a cell (or group of cells) to another section of the Excel spreadsheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |