Topics

Mar 15, 2011

Create a custom list by importing data from cells in Excel 2007

We will have the following data in the cells A1 - Access, A2 - Excel, A3 - PowerPoint, and A4 - Word. Perform the following steps to add a custom list by importing data from cells.
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. Click the Import list from cells: button.
6. Select cells A1 to A4 to select Access, Excel, PowerPoint, and Word and press the Enter key.
7. Click Insert and click OK twice.

0 comments:

Post a Comment