How to Insert a Text Box in Google Sheets

Last Updated on April 21, 2023 by Jake Sheridan

In this tutorial, you will learn how to insert a text box in Google Sheets.

How to Insert a Text Box in Google Sheets

Google Sheets is a powerful spreadsheet program that you can use to store and analyze data.

One of the lesser-known features of Google Sheets is the ability to insert a text box into your sheet. This can be useful if you want to add a caption or title to your sheet, or if you need to add a comment to a particular cell.

The text box can be created through Google Sheets’ Drawing tool. The Drawing feature allows users to insert various shapes and visual elements to a spreadsheet.

Users can create a rectangle object using the Drawing tool and add text inside to create what is essentially a text box.

In this guide, we will explain how to insert a text box in Google Sheets using the Drawing feature. We will also explore some of the customization options available for text boxes.

How to Add a Text Box Shape in Google Sheets

Here’s how to add a text box shape in Google Sheets.

Step 1

Open the sheet you want to insert a text box into.

In this example, we want to add a text box that tells the user what kind of data is being displayed in the current sheet.

Step 2

In the Insert menu, click on the Drawing option.

Step 3

You should now see a Drawing dialog box with an empty canvas in the middle.

Step 4

To create a text box, you can select any shape form the Shapes menu.

In this example, we’ve chosen a rounded rectangle shape.

Step 5

Use your cursor to draw the shape into the blank canvas.

Ensure that the shape has the right dimensions to fit your desired text.

Step 6

Click on the shape to start writing text inside.

In this example, we’ve written the text “2023 Monthly Data”. We’ve also formatted the text by increasing the font size slightly.

The Drawing tool also allows you to modify the formatting of the shape itself such as the shape’s outline and background color.

Step 7

Click on Save and Close to add the new text box into the current spreadsheet.

Summary

This guide should be everything you need to insert your own text box in Google Sheets.

You may make a copy of this example spreadsheet to test it out on your own.