To go down to the stream in Excel, you have many ways to do it, depending on the content and requirements of the stream in Excel to be done. We can adjust to the line in an Excel box and still see the content clearly. Or set up the automatic mode down the line in Excel. The following article will guide you down the line in Excel.
Method 1: Go down the line in an Excel box with ALT + Enter
If you need to write many lines in an Excel box, to go down to the stream in Excel, put the mouse in the position you want to go down and press the excel shortcut combination Alt + Enter On Windows or Command + Enter On macOS.
For example, when entering the content as shown in the picture, the long content will be overflowed to the right. To interrupt the flow below, put the mouse mark on the position you want to go down, then press the key combination Alt + Enter To go down the line.
The results will be as shown below. The content has been cornered in one cell. Then we proceed to edit and adjust the content accordingly.
Method 2: Go down the stream in Excel with Wrap Text
More precisely, Wrap Text is a way to encapsulate content in one cell, making the word not overflow to another umbrella. You enter the content into an Excel box, then click on the box, then click Wrap Text Above as shown.
The content results will also go down as shown. You adjust the content to have a better layout.
Method 3: Adjust in format cells to go down to the Excel line
Step 1:
You click on the content imported in Excel and right -click to select Format cells … Appears in the list.
Step 2:
New dialog box interface appears. Here, press Tab Alignment then accumulated Wrap Text As shown below.
In addition, here you can customize more with the case for example between the content, create angle, change the fonts, create a frame for the cell. Press OK To save.
Step 3:
The content of the word will also be transferred to the line without going to another column. At the same time, the content in the line will also automatically be aligned without we need to manually edit it.
If you want the content in the Excel cell to be automatically aligned, adjust in the format cells, the content will be adjusted to suit the width of the column containing it.
Method 4: Disconnect in Microsoft Excel with Find & Replace
Sometimes, the actual requirement makes you have to go down the stream continuously after certain characters and letters. So what to do?
First, highlighted to select all the cells that you want to insert the line interrupt.
Look up the toolbar, find the tab “HomeAnd click on it. A corresponding option menu will immediately be opened. Here, you navigate to the section Find & Select> Replace. If you do not want to use the mouse, you can also press the Ctrl+H key combination to quickly access this Find & Select dialog box.
In school “Replace with”, Press the key combination Ctrl + J To add signs to the line. This operation will insert the line interrupt instead of each comma.
Now, click the “Replace allAt the bottom to replace all commas with interrupts down.
Method 5: Guide to the line in an Excel cell with a char function
You can use this function to go down the line in a cell when there is a long text.
At the box with the content to go down the line, you enter the content of the function = “Phung Khac Khoan” & char (10) & “Thach That” as shown below and then press Enter. The content is then imported into the Excel box.
Next you just need Click the Wrap Text box On the top, let the characters in an excel box down the line as shown below.
The content of the content in an Exel box has fallen down as shown below.
Method 6: How to get down in a Excel box when connecting the string
For example, we will connect the string in each box and then down the stream for each character.
We enter the formula to connect the string = B12 & char (10) & C12 & char (10) & f12 & char (10) & then press Enter.
Then the chains are connected together as shown below.
Next we just need Click on Wrap Text To go down the line for an excel box.
7. Go down to Excel with the Justify alignment function
Operating down the stream in Excel with the Justify alignment function is not too difficult to perform.
Step 1:
You black up the content that you want to go to the line, then Right -click the cell Then continue Format cells In the display list.
Step 2:
Custom interface display. You click on Tab Alignment To do it.
Next look down below Horizontal sectionwe click on the arrow Click Justify In the display list. Finally click OK to save.
As a result, we will see the content down as shown below.
8. Go down to the Excel with the substitute to connect the character
For example, we have the example. The requirement is down to the instructions to combine the content into 1 and remove the white space.
We will Enter the formula to the line = substitute (C34, char (10), “”) Then click Enter to do.
As a result, we will see the content down the line and form a row as shown below.
9. How to go down in a Excel box on iPhone, Android
The Excel version on the phone also has the option to go down the line for you to quickly use for the content in the spreadsheet.
Step 1:
We click on the content to go down the line, then click 3 -dot symbol In the toolbar below as shown.
Step 2:
Display options for the document content, click on The option of interrupting text line. Immediately we see the content down the stream in the Excel cell depending on the size of the cell as shown below.
Step 3:
Continue Click on combination & between To base between the content you want to go down.
Thus the content in the box will be beautiful when in the middle of the line.
Video instructions down to the line, interrupting in the Excel box
In the process of using Excel, with long or simple content we want to be between content to display more balanced, it is necessary to go down the line. However, going down in Excel is not the same as Word when you just press Enter is done.
Hopefully, with the instructions down the stream in Excel above your spreadsheet will be more beautiful and professional.
