Working with Lists

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/two_icon.jpg

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

graphics/08inf46.jpg

Convert a List to a Range

graphics/one_icon.jpg

Click a cell in the list.

graphics/two_icon.jpg

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

graphics/three_icon.jpg

Click OK.

graphics/08inf47.jpg



Show Me. Microsoft Office 2003
Show Me Microsoft Office 2003
ISBN: 0789730073
EAN: 2147483647
Year: 2002
Pages: 418

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