How To Insert Text Box In Google Sheets
When you’re working in Google Sheets, sometimes it’s useful to use text boxes to call attention to certain areas or add visual interest.
Unlike formatted cells, text boxes can be any of a number of shapes.
For example, in addition to rectangles a text box can be an arrow to direct attention, a banner to add a stylish caption to your sheet, or various other interesting shapes like lightning, stars, hearts, etc.
Here’s how to insert a text box in Google Sheets:
Open the Insert menu and click on Drawing. The Drawing Editor window will open
Click on the Shape icon in the toolbar to open the Shapes menu. The Shapes menu contains four submenus for Shapes, Arrows, Callouts and Equations. Hover over the submenus to see the available options and click on one to select it
Once you’ve selected a shape option, the cursor will change to a black cross to show you can now draw the shape on the canvas. Click and drag on the checkerboard canvas to create the shape in the size you want
Double click on the textbox to enter text edit mode and type your text into the text box
Use the Fill and Border Icons in the toolbar to change the color and border style of your textbox
You can also change the font, font size, color, text alignment, etc of the text itself using the options in the toolbar. If you don’t see these options, click on the three dots at the end of the toolbar to open the hidden menu
Once you’re happy with how your textbox looks, click Save and Close in the upper right corner of the Drawing Editor window. The text box will appear in your spreadsheet, floating on top of the cells.
You can click on the text box and drag it to whatever location in the spreadsheet you want
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to insert text box in Google Sheets. Want more? Check out all the Google Sheets Tutorials.
Get more Google Sheets stuff
Subscribe to our mailing list and get interesting Google Sheets stuff and updates to your email inbox.
Thank you for subscribing.
Something went wrong.