Working with Lists

graphics/microsoft38.gif

After you create a list, you can sort the entries, add new entries, and display totals. You can insert rows anywhere in a list or add rows at the bottom of the list. The last row of the list is a blank row with a blue asterisk (*) inside the left-most cell . You can type a new entry in the list directly into the last row. When the list is inactive, the asterisk does not appear in the list, and the list border shifts up to the bottom of the last row of data. If you no longer need the data in list form, you can convert the list back to normal Excel data.

Insert a Row in a List

graphics/one_icon.jpg

Click a cell in the list where you want to insert a row.

graphics/tow_icon.jpg

Click the List button on the List toolbar, point to Insert, and then click Row.

graphics/10inf22.jpg

See Also

See " Insert a Column or Row " on page 82 for information on inserting a row.

Convert a List to a Range

graphics/one_icon.jpg

Click a cell in the list.

graphics/tow_icon.jpg

Click the List button on the List toolbar, and then click Convert To Range.

graphics/three_icon.jpg

Click OK.

graphics/10inf23.jpg



Show Me Microsoft Office Excel 2003
Show Me Microsoft Office Excel 2003
ISBN: 0789730057
EAN: 2147483647
Year: 2002
Pages: 291

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net