Now when you click on the text box, it will automatically run the script.

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. 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. Grab your Move Tool by pressing V or access it in the toolbar.

With this new selection active, click on the text layer you want to center. This will turn the outline of your shape into a selection. 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. To turn this shape into a selection, hold the Command Key (Mac) or Control Key (PC) and click on the layer thumbnail.

Since this text box is an object, you can move it over the worksheet cells. The above steps would insert the text box in the worksheet in Google Sheets.

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 text box in photoshop