When you press these keys one by one, you can see different letter combinations beside different tabs in the ribbon. Press Alt, H, F, P keys on the keyboards successively rather than simultaneously. Select the range or cell with the formatting you want to copy. You can use shortcut for format painter in Excel 2010 instead of clicking the Format Painter button on the ribbon. Section 4: Use Shortcut for Format Painter in Excel 2010 In this case, Row 5 becomes bold, red and left aligned in the manner of Row 3. Click the row heading, go to Format Painter, and then click the heading of the target row. Similarly, you can copy the formatting of the entire row column-by-column to another row. In this case, the target Column D becomes bold, red and centrally aligned as Column B.
Thus, the formatting of the original column is applied to the target column. Go to click the heading of the target column. Click the heading of the column whose formatting you want to copy, and go to Format Painter. How do you use the Format Painter in Excel 2010 to quickly copy the formatting of the entire column to another column? You can do it according the following guidance. Section 3: Paint the Formatting from an Entire Column or Row to Another In this case, the target cells become bold, left aligned and get a green background color. Thus, the target cells will have the same formatting with the selected cell. Press ESC or click on the Format Painter button to disable the Format Painter mode. Choose the cells to paste the formatting to. Tip: This will allow you copy from a range of cells and paste that formatting for multiple times. Double click on the Format Painter icon after you have selected the cells that you want to copy the formatting from.
#Excel 2013 remove paintbrush icon how to
How to use the Format Painter in Excel 2010 twice or even more times? If you click on the Format Painter icon in the Home tab according to the steps that we mentioned above, it allows you to copy and paste the formatting only once. Sometimes you need copy the formatting from one cell or even a range of cells and paste it to a non-adjacent range of cells. Section 2: Use the Format Painter on Non-adjacent Cells In this case, the target cells become bold, centrally aligned and get a green background color as cell C7. Tip: Format Painter only copies the formatting not the value in the cell.Īfter you complete these three steps, you can find that these cells have been formatted to the cell that you selected in Step 1. Or you can click and drag over a range of cells to paste the formatting to multiple cells. Select a different cell to paste the formatting. Tip: After you click the Format Painter icon in the Clipboard ribbon, you can see that the pointer changes to a paintbrush icon and the selected cell highlighted with a moving border, which indicates that the Format Painter is active and effective. Go to Home tab in the ribbon and click Format Painter icon. Select the cell that you want to copy formatting from. How to use Format Painter in Excel for multiple cells? The formatting can be copied from one cell to another cell or multiple cells with just three simple steps. Section 1: Copy the Formatting from a Cell to Multiple Cells Now we will talk about how to use Format Painter in excel 2010. Using Format Painter in Excel will save you a lot of time in helping you apply the same formatting, such as cell background color, font style and size, font characteristics (bold, italic, and underline), cell borders and many other formatting not mentioned here to multiple cells in worksheet. Section 4: Use Shortcut for Format Painter in Excel 2010.Section 3: Paint the Formatting from an Entire Column or Row to Another.Section 2: Use the Format Painter on Non-adjacent Cells.Section 1: Copy the Formatting from a Cell to Multiple Cells.How to use Format Painter in Excel for multiple cells? This tutorial will guide you How to Use Format Painter to Copy Formatting in Excel 2010. Excel Format Painter is a very convenient and useful tool to copy formatting from a range of cells and paste it somewhere else in the worksheet or other worksheets, whose function can never be overlooked or underestimated. In some cases, you want to copy formatting from one cell or a range to another to make your worksheet awesome. How to Use Format Painter to Copy Formatting in Excel 2010
0 kommentar(er)
