How To Create A Text Box In Google Sheets

Question

/docs/community?hl=en

How do I create a text box that will expand as more text is added?

1

I am creating a document and need some text boxes to expand as more characters are added.

Also need to have an expandable text box within a table.

Thanks for the help.

Latest Update Latest Updates (0)

Recommended Answer Recommended Answers (1)

Relevant Answer Relevant Answers (0)

Our automated system analyzes the replies to choose the one that's most likely to answer the question.

This question is locked and replying has been disabled.

Discard post? You will lose what you have written so far.

Failed to attach file, click here to try again.

Edit link

Text to display: Link to:

Notifications are currently off and you won't receive updates. To turn them on, go toNotifications preferences on your Profile page.

Discard post?

You will lose what you have written so far.

Personal information found

We found the following personal information in your message:

This information will be visible to anyone who visits or subscribes to notifications for this post. Are you sure you want to continue?

A problem occurred. Please try again.

Create Reply

Edit Reply

This will remove the reply from the Answers section.

Notifications are off

Your notifications are currently off and you won't receive subscription updates. To turn them on, go to Notifications preferences on your Profile page.

Google user

This reply is no longer available.

Badges

Some community members might have badges that indicate their identity or level of participation in a community.

Google Employee — Google product team members and community managers

Community Specialist — Google partners who help ensure the quality of community content

Diamond Product Expert — Community members with product mastery who help other Google users and Product Experts

Platinum Product Expert — Community members with advanced product knowledge who help other Google users and Product Experts

Gold Product Expert — Community members with in-depth product knowledge who help other Google users by answering questions

Silver Product Expert — Community members with intermediate product knowledge who help other Google users by answering questions

Product Expert Alumni — Former Product Experts who are no longer members of the program

Community content may not be verified or up-to-date.

/docs/threads

//accounts.google.com/ServiceLogin

You'll receive email notifications for new posts at

Unable to delete question.

Unable to update vote.

Unable to update subscription.

You have been unsubscribed

Deleted

Unable to delete reply.

Removed from Answers

Removed from Updates

Marked as Recommended Answer

Marked as Update

Removed recommendation

Undo

Unable to update reply.

Unable to update vote.

Thank you. Your response was recorded.

Unable to undo vote.

Thank you. This reply will now display in the answers section.

Link copied

Locked

Unlocked

Unable to lock

Unable to unlock

Pinned

Unpinned

Unable to pin

Unable to unpin

Marked

Unmarked

Unable to mark

Reported as off topic

Known Issue

Fixed

Marked Fixed

Unmarked Fixed

Unable to mark fixed

Unable to unmark fixed

/profile/0

score -38 · Accepted Answer

Hi, Kimberly,

The best way to create an expandable text box is to use a single-cell table. You can change the border thickness and/or color or style as you like.

You can do the same thing with a table by simply inserting another single-cell table within any cell in your current table.

Does that resolve it for you or do you have additional questions?

~Jo

Google user

recommended this

Original Poster

marked this as an answer

Recommended based on info available

Our automated system analyzes replies to choose the one that's most likely to answer the question. If it seems to be helpful, we may eventually mark it as a Recommended Answer.

-38