How to Copy Cell Formatting in Microsoft Excel
Formatting your Excel worksheet is an important step in making your work presentable. Microsoft Excel offers you several ways to copy a cell’s format. For example, Format Painter is a direct way of copying the formatting of one cell and applying it to another. But there are other ways of copying formatting and this article will help you find the one that works for you and the type of your work. 1. Copy Formatting in Excel with Paste Special When you want to copy cells in Microsoft Excel, you notice there are several paste options at your disposal. Paste Formatting allows you to copy only the formatting of the cell, but not its content. Let’s see how it works in an example. You want to copy the formatting of cell A2 which has a red background and white font color, to cell B2 which has a different value in it without any formatting: Select and right-click the single cell from which you want to copy the formatting. In our example that’s cell A2. Select Copy from the menu, o