On the canvas, click the shape, line, or text box you want to change. At the top of the page, find and click Select.

Now when you click on the text box, it will automatically run the script. On your computer, open a drawing in Google Drive. In the Assign Script dialog box, enter the name of the script you want to run.Click on the three vertical dots that appear at the top-right of the text box.You can also assign a script to the text box so that when you click on it, it would automatically run the Google Apps script.īelow are the steps to assign a script to the text box: In the options that show up, click in Edit and it will open the text box in the Drawing dialog box where you can edit it. To insert a text box: Click Insert, then select Drawing from the drop-down menu. In case you have already added the text box in the worksheet and you want to format it later, you can do that by clicking the text box and then clicking in the three dots at the top-right of the text box. Highlight all or part of the text within the text box.Changing the font size, font type, and font color of the text in the text box.When you’re inserting the text box, you can also format it a bit within the Drawing dialog box.īelow are the few formatting options you have: In case I delete the rows/column behind the text box, it wouldn’t make any change to the text box.

You can click and move it and place it anywhere on the worksheet.Īlso, the text box is not impacted by what you do to the cells. Since this text box is an object, you can move it over the worksheet cells. Youll have to use the drawing tool to create a text box and add it in the. The above steps would insert the text box in the worksheet in Google Sheets. Unlike Microsoft Word, Google Docs doesnt have a dedicated option to add a text box.

Type the text you want to be in the text box.

Click and hold the mouse key and then drag it to insert the text box.

In the Drawing dialog box that opens, click on the ‘Text box’ option.

Formatting the Text Box in Google Sheetsīelow are the steps to insert a text box in a worksheet in Google Sheets:.

How to Insert Text Box in Google Sheets.

How to insert box in google docs