Answer Posted / Girja Shankar Vishwakarma
To create a custom list in Excel, follow these steps:
1. Select the cell where you want to start your list.
2. Type the first item of your list and press Enter.
3. Select the cell containing the first item and the blank cell below it.
4. Go to the 'Formulas' tab in the Ribbon, select 'Defined Names', and then click 'Define Name'.
5. In the 'New Name' field, enter a name for your list (e.g., CustomList).
6. In the 'Refers To' field, select 'Formula' and enter `=OFFSET(cell_containing_first_item, 0, 0, COUNTA(list), 1)`, replacing 'cell_containing_first_item' with the address of the cell containing the first item.
7. Click 'OK'.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
