Saturday, October 27, 2012

How to Flow a List Across Multiple Columns


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.

Blogger news