Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Dropdown Field


  • Please log in to reply

#1
Momof3

Momof3

    New Member

  • Member
  • Pip
  • 2 posts
Hi everyone....new here! I am looking for some help with dropdown fields. I have just mastered them, but have a question. Is there anyway I can see one thing when I use the dropdown, but it shows some thing else when I choose it. For example, I dropdown and see "Language Arts Curriculum Standard 1: Students will read age appropriate material effectively and with purpose." and when I choose this choice have it only show "LA 1". Do you know what I mean? Can I do this?

When you respond, please keep in mind that it took me ALL day to do the dropdown fields! I am NOT a whiz at this!!!

Thanks so much for any help you can give me!!


N
  • 0

Advertisements


#2
peterm

peterm

    Trusted Tech

  • Technician
  • 3,173 posts
are you doing drop down fields in excell access or word forms
  • 0

#3
Momof3

Momof3

    New Member

  • Topic Starter
  • Member
  • Pip
  • 2 posts
I am working in word....haven't figured out the whole excel thing yet!!

:tazz:
  • 0

#4
krishnap2w2

krishnap2w2

    New Member

  • Member
  • Pip
  • 3 posts
There are multiple ways in which you can create a dropdown list in Excel.
Data Validation
Form Control (Combo Box)
ActiveX Control (Combo Box)
But of these methods, Data Validation is the most used method, for its simplicity. Later on, I’ll explain the pros and cons of each method, so that you can choose the best method among these for you.
 
Before going to explain how to create a dropdown list, let me tell you what a Data Validation is? It controls the type of data or the values that users enter into a cell. For example, you may want to enter only positive values in a cell, only ‘time’ in a column, or a text below the specified length. You can define all these conditions through Data Validation. Even dropdown list is a data validation where you’re constraining the user to use only those set of words in that cell. Again, in creating a dropdown list through data validation, there are different ways in doing it.
 
Writing the complete list in the Source Field
1) Select the Cell (or) set of Cells in which you want to see the dropdown. 2) Go to “Data” Tab –> Data Validation –> Data Validation 3) Select List in the “Allow box” 4) Just enter the names you want to see in the dropdown list in the “Source” Box
 

Edited by krishnap2w2, 23 December 2014 - 04:20 AM.

  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP