Copy format Excel shortcut
In Excel, when you want to apply the font, size, color, fill color, and other formatting of text entered in a cell to other cells, the data values will also be copied in the normal copy. By using the shortcut keys described below, you can copy only the formatting of a cell and apply it to other cells. This method is very useful when you want to align the formatting of a cell.
Shortcut to copy a format
Windows
Access Key: Alt + H + F + P
Mac
None
Copy the cell formatting
Learn how to copy the formatting of a cell using the shortcut keys.
Total Time: 1 minute
Select a cell
Select the cells of the format to be copied.
Copy the formatting
Press Alt + H + F + P to copy the cell formatting.
The format has been copied
Press → (Right Arrow key). The copied format will be applied to the adjacent cells.
Apply the copied formatting to distant cells
Select the cells of the format to be copied.
Press Alt + H + F + P to copy the cell formatting.
Click on the cell to which you want to apply the formatting. You can now copy the formatting.