Excel  2007

Use the AutoFill feature. It inserts a series of values or text items in a range of cells.

Drag the AutoFill handle (the small box at the lower right of the Active cell) to copy the cell or automatically complete the series

You can create your own list by adding a ‘Custom List’. To add a Custom List click <Office Button> à <Excel options> à <Popular> à <Edit Custom Lists..> and select the [Custom List tab]. In the [List entries] list box, type out your list entries separated by enter.

More Under Finance

Posted Under

Category : Finance (3716)
Type : Articles (17631)
Tags : Excel Tips (36)

Leave a Reply

Your email address will not be published. Required fields are marked *