To create a drop-down list in Excel, execute the following steps.
1. On the second sheet, type the items you want to appear in the drop-down list.
We can also hide the list appeared and it's sheet so that users can not see it
2. On the first sheet select cell a1
3. Select the data tools group in data tab and select data validation
4. On the allow list box click list and select range of the cells
5. Click in the source box and select the range from second sheet
Excel-Xpert is a all about excel, a professional series where everyone would get a chance to participate and we would try to explore and find new things, this would serve people who are keen to learn excel in detail.
Subscribe to:
Post Comments (Atom)
Excel formulas and functions
Excel formulas and functions Formulas and functions are the bread and butter of Excel. They drive almost everything interesting and useful...

-
Excel Ribbon can be accessed by selecting the ribbon's Home tab when you open it. Ribbon in excel is the name given to the row of tabs a...
-
1 Count and Sum : The most used functions in Excel are the functions that count and sum. You can count and sum based on one criteria or mu...
-
Index Function in excel is used to return the value at a given position in a array. We can use excel index function with the MATCH function ...
No comments:
Post a Comment