Question

How will you add a list of your five friend in custom list? Explain any one method.​

Answer 1

Answer:

Custom Lists

1 Type Sun into cell B2.

2 Select cell B2, click on the lower right corner of cell B2 and drag it across to cell H2. ...

3 On the File tab, click Options.

4 Under Advanced, go to General and click Edit Custom Lists. ...

5 To create your own custom list, type some list entries, and click Add. ...

6 Click OK.

7 Type London into cell C2.

Answer 2

Answer:

$\huge {\mathbb{\red{Hello Mate!!}}}$

██████████████████████████

$\huge\boxed{\fcolorbox{red}{yellow}{answer}}$

$\huge {\underline{\pink{Thanks:)}}}$ ❤

Explanation:

Custom Lists

If you create a custom list in Excel, you can easily fill a range with your own list of departments, clients, cities, credit card numbers, etc. This can save time and reduce errors.

First, we will look at an example of a built-in list.

1. Type Sun into cell B2.

Built-in List Example in Excel

2. Select cell B2, click on the lower right corner of cell B2 and drag it across to cell H2.

3. On the File tab, click Options.

4. Under Advanced, go to General and click Edit Custom Lists.

Click Edit Custom Lists

Here you can find the built-in 'days of the week' lists. Also notice the 'months of the year' lists.

5. To create your own custom list, type some list entries, and click Add.

Create Custom List

Note: you can also import a list from a worksheet.

6. Click OK.

7. Type London into cell C2.

Custom List Example

8. Select cell C2, click on the lower right corner of cell C2 and drag it down to cell C5.