This will open the Drawing dialog box to edit your text box.

Click the three vertical dots in the top right corner of your text box.

How to Edit a Text Boxįollow these steps if you want to open the Drawing dialog box to format or edit the text box. The text box will remain unchanged if you delete or insert rows and columns beneath the text box. What you change in the cells has no effect on the text box. The text box you inserted using the above steps in Google Sheets is an object that floats above the grid. You can click, drag and drop it anywhere on the sheet.

Type your text to replace Your text here… in the text box.

Click and hold the mouse key, then drag it to the desired size of your text box.

Click the Text box Icon in the drawing dialog box.

Get your copy of the example workbook used in this post and follow along! How to Insert a Text Boxįollow the below steps to insert a text box in Google Sheets In this article, you will learn how to insert, format, edit, and assign an app script a text box. Text boxes allow you to insert text or images and then move them anywhere over the Sheet. There is currently no obvious way to insert a text box in Google Sheets but it can be added using the drawing command.

Text boxes have more formatting options available than inside a cell and can help make your Google Sheets appear more formal and professional, especially when you create a report or dashboard.

It allows you to create a large text area without having to change the row height or column widths. Text boxes can take any shape, unlike formatted cells.Ī text box can be used to direct attention, or as a banner to add a stylish caption to your sheet. Text boxes can be used to draw attention to specific areas or to add visual interest. Even though Google Sheets already has cells for adding numbers or text, you may also need to insert a text box in Google Sheets at times. This post is going to show you how to insert and edit a text box in Google Sheets.

Google docs how to insert a text box