How to Create Own Custom List in Microsoft Excel│कस्टम लिस्ट कैसे बनाये एक्सल में।

▬▬▬▬▬▬▬▬▬ஜ۩۞۩ஜ▬▬▬▬▬▬▬▬
▓▓▓▒▒▒░░░ Open This Description ░░░▒▒▒▓▓▓
▬▬▬▬▬▬▬▬▬ஜ۩۞۩ஜ▬▬▬▬▬▬▬▬
How to Create a Custom List in Microsoft Excel and how to add custom list in excel
Do you frequently have to fill in the same sets of data into spreadsheets? Just create a custom list in Excel. The next time you need one of your lists, let Auto Fill do the heavy lifting.
How to AutoFill in Excel
Excel includes several built-in lists, including months and days of the week. Let’s look at a simple example to see how AutoFill works.
Type Sun (for Sunday) into cell B2. Then, put the cursor over the lower-right corner of cell B2 until it turns into a plus sign and drag right to cell H2.
How to Create a Custom List in Excel
You can use the custom list feature to create and store lists you use often, such as a list of department names, employee names, clothing sizes, states, and just about any other list you can think of. These lists can be used as headings on columns or rows or to populate dropdown lists to make data entry quicker and more accurate.
To create your own custom list, click the File tab. Then, click Options
On the Excel Options dialog box, click Advanced. Then, scroll down to the General section on the right and click Edit Custom Lists.
In the Custom lists box, you’ll see the predefined lists of days of the week and months of the year.
There are three ways you can create your own custom list.
1. Enter Your List Directly
The first way to create your own custom list is to enter it directly on the Custom Lists dialog box.
Type some list entries into the List entries box, one item per line, and click Add.
This is the easiest way if you have a short list not included on any of the worksheets in your workbook.
2. Import Cells From a Worksheet
The second way to create a custom list is to import them from cells in one of your worksheets.
Click the cell selector button on the Import list from cells box.
The Custom Lists dialog box shrinks down to just the Import list from cells box. Select the worksheet containing the list you want to import. Then, select the range of cells containing the items in the list and click button on the right side of the Import list from cells box.
The Custom Lists dialog box expands again. You may notice that the title of the dialog box changes to Options. It’s still the same dialog box, though. Click Import to add the list items from the worksheet to the List entries box.
This method makes it easy to add a custom list that you already have in cells in your workbook.
Create Your Own Custom Lists
The custom lists feature in Excel allows you to easily and quickly customize your spreadsheets to fit your needs. Once you add a custom list to Excel, it’s available in all new and existing spreadsheets.
how to create custom list in excel
ＬＩＫＥ | ＣＯＭＭＥＮＴ | ＳＨＡＲＥ | ＳＵＢＳＣＲＩＢＥ
अगर आप को यह विडियो पसंद आया तो कृपया लाइक करें और अगर आप कुछ कहना या पूछना चाहते है तो कृपया नीचे दिए गए कमेंट बॉक्स में लिखें !
ComTutor हिन्दी युटूब चैनल है जो आपको इन्टरनेट, कम्प्यूटर, मोबाईल और नयी टेकनालाजी के बारे में हिन्दी में जानकारी देता है।
आप हमारे चैनल को Subscribe करे।
/ @comtutor
फेसबुक पर पसंद करने के लिए क्लिक करें
/ comtutor4u
ट्विटर पर फॉलो करने के लिए क्लिक करे
/ comtutor4u

[@prisupandey1160]

Tnxxx sirr maine bhut videos dekhi but smjh nhi aaya but esme pura clear ho gya

[@ComTutor]

Thanks and plz subscribe for more videos

[@rupeshbhai1]

Actual video which tell about custom list starts from 3:07

[@crafiteee]

Thank you sir
It helped a lot ☺

[@ComTutor]

Your welcome..

[@MS-fe6hk]

Thank you my computer my teacher said to do practicl

[@user-vinodkumar143]

Badiya sir ji

[@ComTutor]

Thanks

[@arundhatimaharana7056]

Very helpful

[@simachaurasiya4344]

Thank you sir

[@ComTutor]

So nice of you

[@abhinavchikate493]

Very nice information.

[@mehmetekram8003]

amazing thank yu sir

[@sanchiraut786]

Thank you sir.. 🙂🙂

[@ComTutor]

thanks

[@speed-writer]

I like the name of your channel 😏

[@ComTutor]

thanks for your comment

[@devendrayadavyd]

Very helpful sir

[@maheshkumar9206]

Nice video 👍👍😀

[@ComTutor]

Thank you

[@arunkumarsinghark3024]

🌹राधे राधे 🌹ARK 🔥🏹हमेसा हंसते मुस्कुराते रहिये l

[@SANJAYKUMAR-oz3gb]

Super 👌

[@swetasinha8185]

thanks

[@anupamasarangi7233]

Ya really understandable performance

[@beenakashyap1978]

Love you

[@AshishKumar-hc3km]

Nice Sir

[@ComTutor]

Thanks

[@vijaysharma-sk3nl]

Pls guide for update same in office 2007

[@rahulsinhchauhan6380]

Nice......

[@ComTutor]

Thanks

[@devendrayadavyd]

Sir Computer Institute ke liye Ek poora. Complete excel software banaye jisme student ka reg. With photo Fee deposit , fee slip exam assessment and other option samil ho

[@AjayT81]

Sir, आपने एक वीडियो में बताये थे कि कैसे अलग अलग शीट के डेटा को एक शीट पर consolidate करेंगे बिना vva के । और नॉट pade की सहायता से। please सेंड that लिंक

[@vikasrajani7122]

Sir ye custom list office 07 me nahi bnti h kya

[@ujjwalafibreindustries3465]

Purchase order ke liye koi formula he kya???

[@vijaysharma-sk3nl]

Excel 2007 me advanced me general me "edit custom list" wala option nahi aa raha hai.

[@swetasinha8185]

Not for numbers list

[@atul2047]

*ThankYou Sir*

[@ComTutor]

your welcome

[@RahulSingh-mf2fc]

Thank you sir