December 4, 2020

How to copy formatting in Google Sheet

In this lesson we will learn the process to copy formatting from one cell to another in Google sheet. To do that let’s start with a simple example using date format.

We have the below table containing dates in two different formats. In cell A2 the date is in format ‘dd/mm/yyyy’ and in cell B2 the date is in format ‘dd-mmm-yy’.

Now we will copy the format from cell A2 to cell B2. To do that first select the cell from where you want to copy the format. Here select the cell A2 and copy by right click and copy or CTRL+C.

Now click the ‘Paint Format’ icon in the toolbar of the google sheet and then select the cell where you want to paste the copied format as follows.

As you can see above, now the date format in cell B2 is ‘dd/mm/yyyy’ which is the same as A2.

In this lesson we will also learn how we can change the date format in Google sheet. Now we would like to change the date format in cell B2 to ‘dd mmm yyyy’. To do that first select the cell containing the date for which you want to change the format. Here we have selected the cell B2 and then click ‘Format’ menu of google sheet. There navigate to ‘Number’ and then ‘More Formats’ and click ‘More date and time formats’.

Now select the desired format from the below list of available date time format options. Like we have selected here the custom ‘dd mmm yyyy’ date format. Click Apply.

See below the date format in cell B2 has been updated accordingly.

Leave a Reply

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