Want more? Check out all the Google Sheets Tutorials. In this tutorial, I covered how to insert text box in Google Sheets.

You can click on the text box and drag it to whatever location in the spreadsheet you want SummaryĮxample Spreadsheet: Make a copy of the example spreadsheet The text box will appear in your spreadsheet, floating on top of the cells. Once you’re happy with how your textbox looks, click Save and Close in the upper right corner of the Drawing Editor window. If you don’t see these options, click on the three dots at the end of the toolbar to open the hidden menu Step 7

You can also change the font, font size, color, text alignment, etc of the text itself using the options in the toolbar. Use the Fill and Border Icons in the toolbar to change the color and border style of your textbox Step 6 Click the Mask image arrow next to the Crop image button in the toolbar. Drag the black handles to set the crop boundaries, then press Enter. Click and drag on the checkerboard canvas to create the shape in the size you want Step 4ĭouble click on the textbox to enter text edit mode and type your text into the text box Step 5 Click the Crop image button in the toolbar. 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. Hover over the submenus to see the available options and click on one to select it Step 3 The Shapes menu contains four submenus for Shapes, Arrows, Callouts and Equations. The Drawing Editor window will open Step 2Ĭlick on the Shape icon in the toolbar to open the Shapes menu. Open the Insert menu and click on Drawing. Here’s how to insert a text box in Google Sheets: Step 1 Unlike formatted cells, text boxes can be any of a number of shapes.įor 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. 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.

How To Insert Text Box In Google Sheets.

How to insert shape in google sheets