In this tutorial, you will learn how to make paragraph in google sheets.
When you’re working with text in Google Sheets, you may find you want to add separate distinct paragraphs to a single cell. However it’s not immediately clear how to do so. Hitting enter while typing in a cell exits edit mode instead of adding a new line like it does in a word processor, so how do you add paragraphs in Google sheets? Fortunately, Google Sheets has a few quick and easy methods for making paragraphs in a cell. Read on to learn more.
Keyboard Shortcut Method
The simplest way to make a paragraph in Google Sheets is to use the keyboard method. Here’s how:
Start typing in a cell till you get to the point you want to start a new paragraph.
Type the keyboard shortcut CTRL+ENTER to move the cursor to a new blank line within the cell. Repeat the command if you’d like to add a blank row between the paragraphs
Continue typing in the new paragraph
Split existing blocks of text within a cell into paragraphs by positioning your cursor in the middle of the text and hitting CTRL+ENTER
All text after the cursor will move to a new paragraph
Another option is to use the CHAR(10) function in a text formula to add a line break in the middle of your text. This method is especially useful when the text you want to split into paragraphs is generated via a formula: For example, if it includes a date that is updated in a separate cell.
Double click a cell containing a formula that generates text to start editing it. If you don’t already have a text formula, you can convert a simple text value to one by wrapping the text in quotation marks, then adding an equals sign at the start of the text
Next, split the text into two separate sections joined by the ampersand (&) operator. Be sure both sections are wrapped in quotes. Your formula should be something like this: “=”Paragraph 1.” & “Paragraph 2””
Now we can add CHAR(10) between the sections to insert a line break and split the text into paragraphs. Just like the split sections of text, CHAR(10) needs to be joined to the existing sections of the formula using an ampersand. Your formula should now look something like this: “=”Paragraph 1.” & CHAR(10) & “Paragraph 2””
Hit enter and the paragraph will appear in the cell
Example Spreadsheet: Make a copy of the example spreadsheet
In this tutorial, I covered how to make paragraph in google sheets. Want more? Check out all the Google Sheets Tutorials.
More ways to design in Google Sheets:
- Add Borders
- Add A Line
- Add A Tab
- Change Default Font
- Change Cell Color
- Alternate Colors
- Color Code
- Make Cells Bigger
- Make A Button
- Get Rid Of Lines
- Remove Borders
- Bold Lines
- Set Margins
- Make A Header
- Make Categories
- Make A Template
- Shift Cells Down
- How Many Sheets Can You Have?
- Create A Header
- Content Calendar
- Make All Cells The Same Size
- Outline Cells
- Remove Cell Lines
- X Out A Cell
- Group Cells
- Format Cells
- Add Serial Number