Google Sheets is packed with dozens of useful features and Format Painter is one of them. It allows you to format data and make it more readable. You can use this feature to make your work easier.
Google Sheets also has a feature that makes copy-pasting of formatting easy. Once you use the formatting option to a cell, you can use the format painter to copy it to another cell or other worksheets in the same document.If you are using this feature for the first time, you may find it a bit tricky. To help you out, we have prepared a step-by-step guide. In this post, we will tell you how to use format painter in Google Sheets. Go through the steps and you will know what to do. The steps are easy-to-follow therefore, you shouldn’t find it confusing. For better understanding, we have explained each of the steps in detail.
Steps to use Format Painter in Google Sheets:
- Open an Google sheet:
- Select the cells that have the formatting that you want to copy and paste on other column:
- Next, Click on the Paint Format icon in the toolbar:
- Next, select the cells on which you want to copy the formatting to: