Excel Hack

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 a cell

Select the cells of the format to be copied.

Copy the formatting

Copy the formatting

Press Alt + H + F + P to copy the cell formatting.

The format has been copied

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 a cell

Select the cells of the format to be copied.

Press Alt + H + F + P

Press Alt + H + F + P to copy the cell formatting.

The format has been copied

Click on the cell to which you want to apply the formatting. You can now copy the formatting.

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments