There are lists that are built-in in Excel like the days of the week, month names. You can also create your own lists. Perform the following steps to create a custom list in Excel 2007:
1. Open Microsoft Excel.
2. Click the Microsoft Office Button and click Excel Options.
3. From the Excel Options dialog box, click Popular from the left pane.
4. From the right pane, under Top options for working with Excel, click the Edit Custom Lists... button to open Custom Lists dialog box.
5. We will add a list that has the entries Access, Excel, PowerPoint, and Word. Place your mouse in the List entries: box and click to see the mouse cursor blinking in the box.
6. Type Access and press the Enter key. After making an entry press the Enter key to type the next entry name. Fill the list by typing the four entries.
7. Once you had finished entering the four names, click Add.8. Click OK twice.
Mar 15, 2011
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment