How do I create a custom list in excel?
- 1 Answers
- 777 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What are the types of validation possible?
What is an excel macro?
What is the use of split cells option in computer?
How do you insert a row using the keyboard?
Why pivot table is used in excel?
What is a table array excel?
How do I remove a sign in excel?
How do you find duplicates in conditional formatting?
How do I combine data from multiple columns into one?
Why do I get n a in vlookup?
What is a pivottable, and when would you use one? What are the key pivottable ‘sections’ into which users can drag columns?
How do you find the mode on excel?
MS Excel Microsoft 
