Among all office applications, Excel occupies a special niche. Spreadsheets have long been an integral part of working with data sets. Among other features, Excel allows flexible formatting of the table structure. With the help of special commands, you can combine, split cells in Excel and make other settings for the appearance of tables.
Instructions
Step 1
You can split cells in Excel only those that have been previously combined. To merge cells, select their range and copy the data to the top left cell of the selected range. Select the cells you want to merge and click the Merge and Center button on the toolbar. The address of the new merged cell will be the address of the top left cell in the range.
Step 2
If necessary, align the text in the merged cell using the Left, Center, Right buttons on the Formatting panel. To make other formatting changes, such as vertical alignment, go to the Format menu, choose the Cells command, and go to the Alignment tab.
Step 3
To split cells in Excel, select the merged cell. After combining the cells, you will see the Merge and Center button on the toolbar. Click on it.
Step 4
Using menu commands, you can not only split cells in Excel, but also split text into columns. To do this, select the range of cells containing text values. You can select any number of rows, but only one column. One or more empty columns should remain to the right of the selected range. The data in them will be overwritten.
Step 5
Go to the Data menu and select the Text by Columns command. Then follow the instructions of the program to select the method and parameters for splitting the text into columns.
