How to Flow a List Across Multiple Columns
When creating a list in Excel, you may want to merge two columns or cells. This allows you to create longer columns without the overflow into other Excel columns. When cell text overflows into other columns, the text is truncated when the adjacent cell is populated. Using Excel's format menu, you can merge the two columns and enter data into it as if it's one, large column. This is accomplished using Excel 2003 or Excel 2007.
Other People Are Reading
Instructions
-
-
1
Choose the two columns you want to merge. You can also merge several columns on the spreadsheet. Once selected, click the first column and drag the mouse across the others. This will highlight multiple columns at once.
-
2
Click the "Merge and Center" button in Microsoft Excel 2007. In Excel 2003, click the "Format" menu item and select "Merge and Center" from the list of options.
-
-
3
Select "Merge Across" from the menu list in Excel 2007. In Excel 2003, select "Merge." You will notice that the cell lines across the columns disappear. This indicates that the columns have been merged.
-
4
Choose the alignment of the text in the columns. Click the "Center" button to center the list within the selected merged columns. You can also left align or right align the text in the merge cells.
-
5
Click the "Ctrl" and the "S" button on the keyboard. This saves the Excel spreadsheet in both 2003 and 2007 versions.
-
1
