In this article:

How to Insert a Text Box in Google Sheets (Easiest Way in 2024)

May 8, 2024

Can You Insert a Text Box in Google Sheets?

Yes, you can insert a text box in Google Sheets. Inserting a text box in Google Sheets allows users to add customizable, free-floating text over their spreadsheets which provides a versatile way to include annotations, instructions, or titles.

How to Insert a Text Box in Google Sheets

Follow the steps below to insert a text box in Google Sheets.

1. Go to "Insert" > "Drawing" > "New" to Open the Drawing Tool

Start by clicking on "Insert" in the top menu. Next, choose "Drawing". This action will open a new Drawing dialog box.

insert text box google sheets

2. Click the "Text Box" Icon to Activate Text Box Drawing

Within the Drawing tool, find and click on the "Text box" icon, which looks like a T inside a square. This icon allows you to insert text boxes into your drawing.

how to insert text box in google sheets

3. Create the Text Box by Clicking and Dragging on the Canvas

Click and drag your cursor across the canvas to create your text box. You can adjust its size according to how much text you plan to add.

how to insert a text box in google sheets

4. Type and Format Your Text Inside the Text Box

Now, type the desired text directly into the text box. You have options to change the font, size, color, and alignment of your text using the toolbar.

google sheets text box

5. Click "Save and Close" to Insert the Text Box into Your Sheet

After you're satisfied with your text, click the "Save and Close" button. Your text box will then be inserted into your Google Sheets document as an overlay.

insert a text box in google sheets

6. Move and Resize the Text Box as Needed in Your Sheet

If you need to reposition your text box, simply click and drag it to the desired spot. To resize it, use the square handles that appear around its edges.

We hope that you now have a better understanding of how to insert a text box in Google Sheets. If you enjoyed this article, you might also like our article on how to rotate an image in Google Sheets or our article on how to do a running total in Google Sheets.

Get Google Sheets productivity and automation tips delivered straight to your inbox
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
We'll email you 1-3 times a week — and never share your information.
Get your copy of our free Google Sheets automation guide!
  • 27 pages of Google Sheets tips and tricks to save time
  • Covers pivot tables and other advanced topics
  • 100% free

Work less, automate more!

Use Lido to connect your spreadsheets to email, Slack, calendars, and more to automate data transfers and eliminate manual copying and pasting. View all use cases ->