Written by Upendra Kumar
|
|
Saturday, 07 July 2007
Category MS Excel 2007 - Misc.
|
| |
| General Information |
| |
 |
| |
|
Editing Excel Options
|
| |
|
| |
|
In this tutorial, you will learn how to configure Excel's general options. |
| |
| Editing Excel Options |
| |
| 1) Open Excel Application. |
| |
| 2) Create a new blank workbook. |
| |
| 3) Select sheet 1, cell A1. |
| |
| 4) Write "Index Cluster 1 - Idxa". |
| |
| 5) Drag the cell from A1 to A9. |
| |
| 6) See the results. |
| |
|
| Illustration 1: Dragged data list. |
| |
| 7) Click on the Office Button similar to the one shown in the below image. |
| |
|
| 8) Click in the Excel Options button. |
| |
| 9) Select the "Popular" tab as shown below. |
| |
|
| 10) Select the "Edit Custom Lists..." button as shown below. |
| |
|
| 11) Create a new list. Press the Add button. |
| |
|
| Illustration 2: Customs lists. |
| |
| 12) Click on List Entries and tipe: Custom1, Custom 2, Custom 3 and press the Add button. |
| |
|
| Illustration 3: Customs lists. |
| |
|
