Enter the data in a sheet of calculation without formatting it is the fastest way to induce migraine. Google sheets (and all the main apps for calculation sheets) incorporate the concept of styles that simplifies collective formatting. Here are some ways to replicate the desired style on all spreadsheets.
The spreadsheets are excellent for organizing and manipulating the data, whether it is a report of the office, the monthly budget of the house or a guide to the Gifts of Standew Valley. Copying and pasteing the data is an integral part of the work on the spreadsheets eGoogle Sheets(Google Sheets) is no different.
What are styles and why do you need them?
A style is a set of formatting characteristics (such as character size, color and alignment of the text) that can be applied to the document, as a design model. Suppose that you want all the cells in the heading line to be displayed with a white character on a blue background. Instead of doing it individually for all the cells of the calculation sheet, form a cell and then replicate the same style for the remaining cells.
The main purpose of a spreadsheet is to paint an image with the data. If used correctly, styles can attract users' attention to data models and help them collect information faster. Copying a certain style and gluing it in the relevant cells saves time and makes your sheet of calculation coherent and visually captivating.
If you use Google sheets for your needs to calculate numbers, here's how to glue the styles in the document to maintain a coherent formatting. That you use one of the best Chromebooks, a normal desktop PC or an Android phone, we show you how to do it.
How to copy a style in Google sheets
Before starting to glue a style, we first copy some cell data.
- Select the cell you want to copy the style.
- Go to the menuModificationand selectCopy.
- Alternatively, use the shortcutCtrl + Con Windows (Command + Con Mac) to copy the desired style.
How to paste a style in Google sheets for the web
Google sheets for the web offers options to glue the style you copied. The methods we list below complete the work in a few steps.
Paste a style using the drawing format tool
The Google sheet drawing tool tool (the painting roller icon in the quick access bar) allows you to copy the formatting inside the document. This is the easiest method to glue a style.
- Select the cell you want to copy the style.
- Go to the quick access bar and click the Paint format icon.
- Select the cell in which you want to copy the style. This paste the style into the destination cell.
Paste a style using the toolbar menu
- Select the cell in which you want to glue the style.
- Open the menuModificationAnd pass the mouse on a special paste.
- From the submenu, selectFormat only.
- This transfers the style of the cell you copied, leaving the existing cell data intact.
Paste a style using the notes menu
- After copying the desired style, select the cell you want to format and pressCtrl + vOn Windows (orCommand + Von Mac).
- Clickon the notes iconin the lower right corner of the selected cell.
- Select the optionPaste only formatfrom the notes menu.
- This paste the style into the destination cell without disturbing the original data.
How to paste a style in Google sheets on Android
The web version of Google sheets for desktop is more convenient than the Google mobile app. But if you do not have access to a PC, the Google sheet app works in the blink of an eye, allowing you to make quick changes to the formatting of your spreadsheet while you are on the move.
For this tutorial we used an Android phone. However, the steps are the same for iPhone and iPad.
- Open your worksheet in the appGoogle Sheets.
- Select the cell you want to copy by pressing it for a long time. This opens a contextual menu.
- Touch the optionCopy.
- Select the cell in which you want to copy the style by pressing on it for a long time.
- A context menu appears. Touch iThree vertical pointsto the right of the menu.
- Choose the optionPaste special, therefore it is up to the option paste only format.
- This paste the style into the destination cell.
Comment first