How to copy formatting in Google Sheets app e.g. B. the Paint formatting tool

Stylizing text and other elements within a sheet not only makes it look pleasing to the reader, but also helps maintain the integrity of the sheet. While it’s convenient to create long sheets on a computer, some styles can be adjusted and a few finishing touches added effortlessly on a smartphone – Android or iOS.

If you’re in the Google ecosystem and use Google Sheets to create spreadsheets, you can use those tool for painting formats, just like other similar apps to copy formatting from one part of the sheet to the other.

While the Paint formatting tool is available on the web version of Google Drive services and Google Sheets, you can only find the Paint formatting tool if you want to put the finishing touches on your sheets with your smartphone (Android or iOS) knowing exactly where, or rather, how to replicate the same tool in the Google Sheet app.

It can be a difficult task to remember the different formatting options to apply the same in different parts of the sheet, so today I’m going to talk about how to copy the format from one part of the sheet to the other.

So, without further delay, let’s start using the Paint formatting tool in Google Sheets to copy the formatting from one part of the sheet to the other.

Using the copy of the Paint format in the Google Sheets app

Let me assume you already have a sheet with some formatting. What you need to do here is to copy the formatting from the existing Google sheet part to the other on Android or iOS smartphones.

  1. Start by selecting the item or cells already formatted the way you want and long-tap on the item to open the context menu. Just tap ‘Copy’ here.
  1. In the next step, select the cells within the sheet to copy the formatting to. Therefore, long-tap on the selection and tap ‘ in the context menu that appearsInsert special‘.
Paste content into Google Sheets
  1. Here you will find several options. All you have to do is select the item you want to insert. As the ‘Copy’ Function copies everything in the selection, like borders, background color, font settings, etc., you just have to click ‘Paste format only‘, and now the source formatting is replicated in the selected part of the sheet.
    Paste format only

Even if at this point you know how to copy formatting in Google Sheets, pasting the formatting should be much easier, just like we can do in Google Sheets web. Whatever, if you use Google Drive apps like Google Sheets, this is a great way to copy and paste the formatting.

So that’s all about how you paste the formatting from one part of one sheet to the other. Do you have any questions? Feel free to comment below.