Skip to content

How to Copy Formatting in Google Sheets

In this article, I will show you three different ways to copy formatting and apply that formatting to another cell or range of cells.

Method 1 – Paint Format

Let’s say you have the following cells formatted to look like this.

Now you want to format the adjacent range of cells the exact same way.

A quick and easy way to do this is by using the Paint Format tool.

Start by selecting the already formatted range of cells. With these cells selected, click on the Paint Format tool. This will copy the formatting.

All that remains is to select the first cell in the range of cells you want to apply the same formatting to.

The formatting is then applied to that range of cells.

Method 2 – Paste Special

Another way to copy the same formatting over to a new range of cells is to use Paste Special.

Start by selecting the formatted cells, and copy those cells by right-clicking and selecting Copy. You can also use the shortcut CTRL + C.

Next, select where to apply the formatting, right-click, select Paste Special, and then Format Only.

The formatting is then copied over to the new range of cells.

Method 3 – CTRL + ALT + V

This method is the same as the previous method. The only difference is that you are using the keyboard shortcut CTRL + ALT + V instead of selecting Paste Special.

Start by copying the formatted cells. Then select where you want to apply the formatting and use the shortcut CTRL + ALT + V. It’s really as easy as one, two, three!

And that is how you can copy just the formatting from one cell or range to another in Google Sheets.

This Post Has 0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top