heet look good for your customers, you decide to format the In erderte make your cells with a certain fill color, font size and color, or number formatting. In most cases, you may want to use the same formatting among many cells in Excel. You could write down all the formatting you use in one cell and then format each other cell individually. This could take you a long time plus you might miss some formatting. Using the Format Painter in Excel is an efficient tool to use when you want to copy formatting from one item to another. 4 Use the Format Painter to copy the formatting from the range A3:C3 to the ranges A9:C9, E3:F3, E9:F9, A14:C14