How to Add Text and Text Box in Google Sheets

How to add text in Google Sheets 24

In this article we will learn about how to add text in google sheets. Also this article will cover the topic how to wrap text, adding text box, adding text together with other text and add legend text in google sheets chart.

Understanding Adding Text in Google Sheets

Google Sheet is an online spreadsheet software that is used to keep records of data and utilize as well as manage that data. The basic purpose is to preserve the data and information in a tabular form for making future decisions and amendments. There are cells formed by the combinations of rows and columns in Google Sheets. You can add text in them or apply formulae as per requirements. Adding text to Google Sheets always plays a major role in the development of Sheets. Later the formulae use the entered text for their calculations and operations.

Google Sheets facilitates the users to add text with ease into the Google Sheets. User can simply add text into the sheets or add text in various kinds of ways. Some of them are adding text after a formula in a cell, add a text box in Google Sheets, add text together in Google Sheets, or add legend text in Google Sheets.

In this article, we will discuss the following about adding text in Google Sheets:

  • Add Text after a Formula in Google Sheets
  • Add a Text Box in Google Sheets
  • Add Text Together in Google Sheets
  • Add Legend Text in Google Sheets

The method for adding the text in the above manners are explained in very easy way below and step by step procedure and screenshots have been provided for the ease of users.

See also  How to Slice a String in Google Sheets [4 Easy Methods]

Why we Add & Wrap Text in Google Sheets?

The basic purpose of Google Sheets is to store data and information. That data and information is mostly stored in the form of text, so adding text becomes a main purpose of using sheets. There are different kinds of ways to add text in Google Sheets. We can use any of those method to add text in Google Sheets.

We may have a worksheet which has data about patients of a hospital. We may need to add text in various ways, for instance, we may need to add some text after a formula about survival chance of patient, or add together some text from different cells, or we may need to add a text box to emphasize on something important or provide reading notes in text box. In case, we are using a chart or graph, we can add Legend Text in the Google Sheets.

See also  Extract Numbers from Strings in Google Sheets [REGEX Functions]

Let us demonstrate the methods for adding text in the Google Sheets as below.

How to Add Text in Google Sheets

There are multiple ways to add text in Google Sheets. We can add text after formula, add text together, add a text box or legend text in Google Sheets.

Let us discuss some for the above methods below.

How to Add Text after a Formula in Google Sheets

Step 1: Open the Google Sheet which contains the text which needs to be added together.

How to add text in Google Sheets 1

Step 2: Select the cell which will be used to add text after a formula.

You can select by clicking the mouse over the cell, or writing its number in cell name box.

Here, we are going to calculate survival chance of the patient and will add text after the formula for survival chance.

How to add text in Google Sheets 2

Selected cell will highlight in blue color.

Step 3: Now enter the formula after which text needs to be added.

How to add text in Google Sheets 3

Step 4: Type “&” (concatenation operator) after formula and then add the text to be added written inside double quotation marks as:

How to add text in Google Sheets 4

Cell now displays the text added after formula as:

How to add text in Google Sheets 5

You can also add text from another cell after a formula using the same method, just use cell name instead of string wrapped in double quotes as =formula&cellname

Step 5: Apply the same method to all cells of the column if required as:

You can do so by selecting and dragging the cell containing text after formula to the bottom.

You can see the final result as:

How to add text in Google Sheets 6

See also  How to Split First and Last Name in Google Sheets (2 Methods)

How to Add a Text Box in Google Sheets

Step 1: Open the Google Sheet which needs to add a text box.

Let us use the previous Google Sheet here as:

How to add text in Google Sheets 7

Step 2: Add the text box using the method below:

Method:

  • Click on Insert option on the menu.
  • How to add text in Google Sheets 8
  • In the dropdown, choose Drawing
  • How to add text in Google Sheets 9
  • From the pop-up menu, select Text Box.
  • How to add text in Google Sheets 10
  • Click anywhere on the screen panel to drop a text box.
  • How to add text in Google Sheets 11
  • Now type the text that need to be added to the text box.
  • How to add text in Google Sheets 12
  • Format the text according to requirements.
  • How to add text in Google Sheets 13
  • Click “Save and Close”.
  • How to add text in Google Sheets 14
  • Adjust the positioning of text box according to requirements by dragging the text box.
  • How to add text in Google Sheets 15

Step 3: Text box has been added, you can change the text in it if required.

How to add text in Google Sheets 16

Which is the required output.

See also  How to Find Slope on Google Sheets (3 Methods)

How to Add  & Wrap Text Together in Google Sheets

Step 1: Open the Google Sheet which contains the text which needs to be added together.

How to add text in Google Sheets 17

Step 2: Select the cell which will be used to add text from other cells together.

You can select by clicking the mouse over the cell, or writing its number in cell name box.

How to add text in Google Sheets 18

Selected cell will highlight in blue color.

Step 2: Now enter the formula for adding the text together using the method below:

Method:

  1. Type “=” into the cell box.
  2. Type in the name of cells whose content is to be displayed first.
  3. Now type concatenation operator (Ampersand) “&” to join together next text.
  4. Type in the name of other cell.
  5. Press enter to submit the formula.

Formula will look like this: =E2&” “&D2&”% risk”

How to add text in Google Sheets 19

Cell will now display the text added together in the cell as:

How to add text in Google Sheets 20

Step 3: You can apply the same formula to the whole column by dragging the mouse from cell containing formula to the bottom as:

How to add text in Google Sheets 21

Which is the required output.

See also  How to Get Correlation Coefficient in Google Sheets (Best Practice)

How to Add Legend Text in Google Sheets

Step 1: Open the Google Sheet which contains the chart to add legend text.

Suppose we are using the same Google Sheet as above. We made a pie chart of Blood Groups of Patients as:

How to add text in Google Sheets 22

Step 2: Edit the chart by clicking on Triple Dot Icon on its top right corner and then choose Edit as:

How to add text in Google Sheets 23

Chart Editor will appear as:

How to add text in Google Sheets 24

Step 3: Go to Customize menu of the Chart Editor and then select Legend as:

How to add text in Google Sheets 25

Step 4: Select Legend Text position and properties according to requirements.

Here, we choose the following requirements for the legend text as:

How to add text in Google Sheets 26

Step 5: We can see the final output of Legend Text in Pie Chart as:

How to add text in Google Sheets 27

Notes

  • While adding the text together, you may need to add some space between them. You can do so by concatenating “ “ between them as =cell1&” “&cell2
  • You can get cell name by clicking on it automatically when you are entering a formula.

See also  How to use Color Scale in Google Sheets [Complete Guide]

Conclusion

Google Sheets allows us many features. They are possible to use based on customized data, because we can add text according to our requirements and then perform various functions on it. Most of the data entered in Google Sheets is in the form of text. So adding text in Google Sheets serves a major purpose in the use of Google Sheets.

In this article, we discussed how to add text in Google Sheets using various types of texts and their uses. We can add text boxes to add text, or add text after a formula, or add text together or add legend text in charts and graphs in Google Sheets.

Any queries about the above described topics are most welcomed. Feel free to comment below for any questions or suggest a topic you want us to describe next. Stay tuned for more!

Thanks for Reading!

Content Protection by DMCA.com

Widad Khan

Hi, I am Widad Khan. I was born and raised in Pakistan. I have always loved the field of Computer Sciences and since I was a kid, I would say I wanna grow up to be a scientist, now this term is mostly related to "Computer Scientist" and not scientist alone. I am pursuing my Bachelor Degree in Computer Sciences from GCU, Lahore. I have always loved keeping records of different types of data. Earlier, I would use MS Excel for that. But with the advancements in Google Sheets, my work has become much easier. And also it's very easy to share and coordinate data with fellows and coordinates.

OfficeDemy.com
Logo
Enable registration in settings - general