When you have a cell, range of cells, column, or row with great formatting you can easily replicate that style with the paint format function. For instance, if you have changed the font, font size, font color, alignment, of a column to Times, size 14, blue, and centered but don't want to manually recreate that formatting over and over for multiple cells. Click on the icon in the toolbar to easily copy and paste styles.
How to Copy and Painting a Format
You can copy and paste the style of a cell or range of cells using the paint format function. The paint format function can be found in the toolbar, represented by a paintbrush icon .
To copy-paste a style:
- Select the cell or range of cells whose style you want to copy.
- Click on the paint format icon on the toolbar.
- Click on the cell or range of cells where you want to paste the style.
The following elements of style can be copied and pasted using the paint format function:
- Cell styles: background color and border
- Text styles: font, font size, font color, bold, italic, underline, strikethrough, vertical and horizontal alignment, text wrapping, etc.
Note: Paste style does not paste comments, merge cells, or data types from the selected cells.
In the animation below, we apply font formatting to text and copy and paint the format to different cells.
Copying and Painting the Formats of Rows and Columns
Similarly, you can copy and paste the format of an entire column or row. To copy the format of an entire column, first, select the column header whose column style you want to copy. Second, click on the paint format icon and then, third, click the column header of the target column.
The process to copy and paste a row's style is very similar. First, select the row header of the row whose formatting you want to copy. Second, click on the paint format icon. Third, click the row header of the target row.
If you want to copy the data in a column, not just the column's style, check out our article on copying columns. Or for more ways to use and edit columns, start with our introductions to columns article.