Text Boxes in Google Sheets

Text Boxes in Google Sheets

A text box is a common tool present in most document-creating applications. It is also referred to as a text field. The actual purpose of a text box is to create a specific area or space exclusively devoted to entering text within a document. There are generally two types of text boxes available: one-line text boxes and multiple-line text boxes. The usage of these different types of text boxes depends upon the quantity of the content or text to be entered in it.

When it comes to Google Sheets, the use of text boxes is extremely popular. They are used to enter texts, numbers, etc. into the cells. Often, the cells of a Google Sheet find it difficult to accommodate longer content, and text boxes come in handy in such scenarios. It also enables the user to invite the attention of the reader to cells of high importance.

 The Google sheets let the user manually insert text boxes to any selected sheet and also provides the chance to customize the text box according to the personal liking and requirement of the user. the color of the text box, the color of the font, the border of the text box, etc. can all be customized accordingly in a Google Sheet. It is also equipped to highlight all or part of the text box according to the choice of the user.

How to insert text boxes in Google Sheet?

Step 1. Open the Google Sheet application on the device.

Step 2. Click open the sheet in which the text box has to be inserted.

Step 3. Click on the Insert option of the top menu bar.

Step 4. From the drop-down menu, click on the Drawing option.

Step 5. A Drawing dialogue box opens up. Click on the Text Box icon present at the top of the dialogue box.

Step 6. Click and drag on the text box up to the size that you require.

Step 7. Type the text that has to be written into the text box.

Step 8. Click on the Save and Close option once the text is successfully written into the text box.

Step 9. The created text box can be now found inside the sheet. It acts as an external object to the sheet cells and thus, it can be moved across the sheet over the cells.

The text box would not get affected by any of the operations that you carry out on the cells of the sheet. You can edit or delete or even insert rows and columns to the sheet, yet the text box remains unaffected. The only thing that the user is expected to do is to position the text box by the changes occurring in the cells.

How to format the text boxes in Google Sheets?

When creating the text box with the help of the Drawing dialogue box, the text box can be formatted accordingly. The top right end of the dialogue box consists of options to color the text box, color the font, align the text, etc. 

Step 1. Clicking on the Fill Color icon at the menu bar lets the user choose any color for the text box. This helps in highlighting the text box and the content in it in the sheet.

Step 2. Clicking on the Border Color icon of the box can be used to color the edges of the text box.

Step 3. Likewise, the text box’s border weight, the type of font, the border dash, etc. canal be chosen by the user.

Step 4. If the user happened to miss the formatting process during the creation of the text box, then he or she can click on the three vertical dots present at the top right corner of the text box to reveal the Edit option.

Step 5. On clicking the Edit option, the user is immediately brought to the Drawing dialogue box where the necessary formatting can be carried out.

How to assign script for text box in Google Sheets?

Step 1. After creating the text box, click on the text box to reveal three vertical dots on its top right corner.

Step 2. Click on the Dots and from the drop-down menu that appears, click on the Assign Script option.

Step 3. A small window appears where a slot is dedicated to writing the name of the script required. Enter the name of the script and click OK.