Adding names to dropdown list already created (Excel)
I have a dropdown list referencing a column of names in another sheet, however when I try to add names to the source column it will not add them to my list...
Do you know how I can edit that to add more names? Further clarification: When I created the list
originally in the second sheet, I selected the column of names and clicked in the white box that usually indicates the cell and changed it to the name of my list (in this case I selected the list of names, clicked in the white box on the top right that usually
says what cell I'm in, and changed it to "Advisors".
How do I edit this "Advisors" list after I initially created it?
Anwsers to the Problem Adding names to dropdown list already created (Excel)
Select the named range Advisors (along with the first row as the header row) and press Ctrl+T. Now go to the cell where you want to create the drop down list and go to Data > Validation > Allow > List and in the source box, tap the F3 key. Select the name
(Advosors) and click on OK.
Now whenever you add further rows of data to the Advisory named range, the validation drop down list will keep updating.
Hope this helps.
To check for Windows updates. Open Windows Update by clicking the Start button , clicking All Programs, and then clicking Windows Update. In the left pane, click Check for updates, and then wait while Windows looks for the latest updates for your computer. If any updates are found, click Install updates.
Install the latest updates for Windows and for the program displaying the error. Note that the update for the program might be listed as an optional update on the Windows Update page.
Open Windows Update by clicking the Start button Picture of the Start button. In the search box, type Update, and then, in the list of results, click Windows Update.
Recommended Method to Fix the Problem: Adding names to dropdown list already created (Excel):
How to Fix Adding names to dropdown list already created (Excel) with SmartPCFixer?
1. Download SmartPCFixer . Install it on your computer. Click Scan, and it will perform a scan for your computer. The junk files will be shown in the list.
2. After the scan is done, you can see the errors and problems need to be repaired. Click Fix All.
3. The Fixing part is done, the speed of your computer will be much higher than before and the errors have been removed.
,Troubleshoot:External Hard Drive not listed in Windows 7 backup wizard Error
,How to Fix Error - Getting an error "not connected to the internet" while trying to install Samsung Kies?
,How to Fix - Internet Explorer shuts down and reopens tab when attaching to email or uploading files.?
,Fast Solution to Problem: Sending Error Message
,[Anwsered] Thinkpad 8611 Boot,How to Resolve - Svchost Helper?,Fast Solution to Problem: L30 101 Driver Windows 7,Troubleshooter of Error: Io Device,How to Fix Error - Dell Laptop Code 39?
Read More: How to Resolve - Adobe CS 5.5 Master's Collection Install Failure error 1935.?,After I shut down my computer running Windowa 7, it re-starts on it'e own a short time later [Anwsered],How Can You Fix - Add-ons became incompatible?,Fast Solution to Error: Add to Favorites button,[Anwsered] adobe flash keeps sending update notices. i did 3 days ago.,a file called mDNSResponse.exe. is causing bonjour not to operate properly,what should I do?,A QUESTION USING THE "IF'S" Formula.,A continuos flashing window with which title is C:Windows\System32\cmd.exe, and has the following message: The syntax of the command is incorrect.,Acrobat compatibility issue and you tube problems____,ActiveX on IE 9 not loaded