Also, ensure that are sufficient empty columns to the right-so that none of your data is deleted. Note: Select as many rows as you want, but no more than one column. Select the cell or column that contains the text you want to split. This is the opposite of concatenation, in which you combine text from two or more cells into one cell.įor example, you can split a column containing full names into separate First Name and Last Name columns:įollow the steps below to split text into multiple columns: You can take the text in one or more cells, and distribute it to multiple cells. Split text from one cell into multiple cells If you need to reverse a cell merge, click onto the merged cell and then choose Unmerge Cells item in the Merge & Center menu (see the figure above). To merge cells without centering, click the arrow next to Merge and Center, and then click Merge Across or Merge Cells. Cells formatted as a table typically display alternating shaded rows, and perhaps filter arrows on the column headings. If you change the direction of text and save the document as a Web page, the text will not appear changed when the page is viewed in the browser.If Merge & Center is disabled, ensure that you’re not editing a cell-and the cells you want to merge aren’t formatted as an Excel table. Note When you merge several cells in a column to create a vertically oriented table heading that spans several rows, click Change Text Direction on the Tables and Borders toolbar to change the orientation of the heading text. Note You can also select rows, columns, or the entire table by clicking in the table and then using the Select commands on the Table menu, or by using keyboard shortcuts. Text in the previous cell Press SHIFT+TAB The entire table In print layout view, click the table move handle, or drag over the entire table. Click the first cell, row, or column you want, press CTRL, and then click the next cells, rows, or columns you want. Or select multiple items that are not necessarily in order. Multiple cells, rows, or columns Drag across the cell, row, or column. A row Click to the left of the row.Ī column Click the column's top gridline or border. To select: A cell Click the left edge of the cell. Some parts of a table can only be seen if you display all formatting marks by clicking Show/Hide on the Standard toolbar.

How to merge cells in word online