Home >Topics >excel >How to merge cells on computer

How to merge cells on computer

藏色散人
藏色散人Original
2020-05-14 10:24:4727229browse

How to merge cells on computer

How do you merge cells on a computer?

1. Open the Excel table that needs to be operated, and select the area that needs to be merged. The merged area must be continuous. The selection method is to place the mouse arrow on the first part of the merged area. cells, hold down the left button and drag the mouse to the last cell of the merged area. Or select the first cell first, hold down the Shift key and select the last cell to select the required area.

Recommended: "Excel Tutorial"

How to merge cells on computer

#2. Find "Merge and Center" in the toolbar and left-click this button.

How to merge cells on computer

3. After left-clicking "Merge and Center", a warning dialog box will appear, "The selected area contains multiple values. After merging into one cell, only "Keep the data in the upper left corner", the values ​​selected in the table are all the same, you can click OK directly. If the values ​​are different during the operation, be sure to see them clearly when merging cells to avoid losing data.

How to merge cells on computer

#4. Click the "Confirm" button in the warning dialog box, and the cell merging is completed.

How to merge cells on computer

The above is the detailed content of How to merge cells on computer. 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