Home>Article>Topics> How to connect two cells in excel?

How to connect two cells in excel?

coldplay.xixi
coldplay.xixi Original
2020-06-12 16:12:58 21602browse

How to connect two cells in excel?

How to connect two cells in excel?

How to connect two cells in excel:

1. Open the excel software, open the table document we need to process, and then find a cell in the table The blank cells are used to place the merged cell contents.

How to connect two cells in excel?

2. Then enter an equal sign "=" in the selected blank cell. After inputting, we use the mouse to click on the first cell to be merged together. The cell where the content is located.

If we want to merge the contents of cells A1, B1, and C1 together, after we enter the equal sign, we can first click on cell A1 with the mouse.

How to connect two cells in excel?

3. After clicking on the first cell, we press the "Shift" key and the "7" key on the keyboard (located above the keyboard letters Y and U) Enter an "&" character.

How to connect two cells in excel?

How to connect two cells in excel?

4. After entering "&", we continue to use the mouse to click on the unit where the second content to be merged is located. grid.

If we want to merge the contents of cells A1, B1, and C1 together, after we enter &, then click on cell B1 with the mouse.

How to connect two cells in excel?

5. The next steps are the same as above. We continue to enter "&", and then use the mouse to click on the third content to be merged together. cell, then enter "&", then click on the cell where the fourth content is located, and so on.

How to connect two cells in excel?

#6. After selecting the content, we can directly press the Enter key on the keyboard. You can see that the cell contents are merged together, and the remaining The data to be merged can also be merged together using the same method.

How to connect two cells in excel?

Recommended tutorial: "excel"

The above is the detailed content of How to connect two cells in excel?. For more information, please follow other related articles on the PHP Chinese website!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn