Go to Home tab in the ribbon and click Format Painter icon. Select the cell that you want to copy formatting from.
#How do i merge and center in excel 2010 how to#
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)
