Excel cell how to merge excel cell merge tutorial

Excel is an essential software for office workers. The cell in excel is the smallest unit in the table and can be easily split. A cell is the intersection of a row and a column in a table. It is the smallest unit that makes up a table. The input and modification of a single data are performed in a cell. The following small series gives you an excel how to merge cells!
excel merge cell method:
first select the area to be merged, note that the merge can only be connected cells. The selected method is as shown below, you can drag directly from A1 to D1; or select A1, then hold down the shift key and click D1 to select the area of ​​A1--D1.

then find the & ldquo in the above format bar; Merge and Center & rdquo ;, click on this button.

Click & ldquo; Merge and Center & rdquo; after warning dialog box appears, say & ldquo; the selected area contains multiple values, merged into a single cell can retain the upper corner of the data & rdquo ;, here we select The content values ​​are the same, you can click OK. If you have different values ​​in the operation, it is recommended to see the cells clearly when you merge them to avoid losing data. Click OK after

box warning, the merged cell is complete.