Friday, January 14, 2011

How to Break a Column to List in Excel


1. Open the saved Excel worksheet.
2. Click 'Insert' tab on the command ribbon.
3. Click the 'SmartArt' command. A window of graphics appears, including 'List.'
4. Click the 'List' option in the window's left pane. A display of 40 list formats appears. Examples include the basic block list with both horizontal and vertical display or the segmented process list to display a sequence of steps.
5. Click the preferred list style.
6. Click 'OK.' The list template floats over the worksheet. A 'SmartArt Tools' ribbon appears.
7. Type in the '[Text]' spaces. You can also click the template's left arrow to open a 'Type your text here' pane. As you type the text, the text copies to the list.
8. Refine the list's shape by clicking a preferred 'SmartArt Styles' button in the 'Design' tab on the 'SmartArt Tools' ribbon. To adjust the color, click the 'Format' tab on the 'SmartArt Tools' ribbon for 'Shape Styles' and 'WordArt Styles.'
9. Click and drag on the template's frame to resize and position the list in the preferred column of the worksheet.

Blogger news