Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
the_clasik_ely Profile
 | Femeie
24 ani
Hunedoara
cauta Barbat
24 - 80 ani |
|
|
TRaP
Moderator
Inregistrat: acum 6 ani
Postari: 748
|
|
When the end user has to add new items to a drop down list, you usually make a data validation that also includes some blank cells in the range, for the new names.
The problem is that it displays blank spaces in the list.
Source with images:
1. Make the list of entries you want to add as options to your drop down list - add them a header / title (as simple as possible)
TITLE
Aaa
Bbb
Ccc
Ddd
2. Select the data you created above including the title of the column, and press CTRL+T to create a new table with that data (make sure My table has headers is checked. Press OK.
3. With the table selected go to a tab called DESIGN (it's under TABLE TOOLS and appears only when you are in a table). On the left of the tab there is a field called Table Name: where is the name of your table, in my example is Table3.
4. Select the cells you want your drop down list in and go to the DATA tab and select Data Validation.
5. Choose List and in the Source filed write the following formula:
=INDIRECT("Table3[TITLE]")
Make sure you replace Table3 with your table name and TITLE with your column name. Then press OK.
6. Now check your drop down lists that they are OK, and write in the next cell right below the table you created; in my example it would be in the next cell after Ddd, like this:
TITLE
Aaa
Bbb
Ccc
Ddd
Eee
The table automatically expands to include that cell and your dropdown list will also include the new entry in the table.
IMPORTANT! Always write the next entry right below the previous one and make sure the table includes it - to make sure you can leave the table colored so you can easily see when it expands.
Modificat de TRaP (acum 5 ani)
|
|
| pus acum 5 ani |
|