“How do I name a range of cells in Microsoft Excel? and use it when validating data?” asked Bobbi

Let us say you have a cell in a Microsoft Excel worksheet in which you want to allow the user to enter a location, but you want the user to select the location from a specified list of locations that you provide (such as San Francisco, Boston, and New York). How can you accomplish this?

First of all, you enter the locations (San Francisco, Boston, and New York in this case) in an Excel worksheet (preferably a different worksheet from the one where the user will be entering data) and name the range of cells accordingly. Here are the steps involved:

1. On Sheet2 for instance, enter your locations, and then highlight the range where you entered the locations (A1 through A3 in the worksheet shown above).

2. Bring the cursor to the white box to the left of the formula bar (called the “name box”) and type the appropriate name that represents your range (valid_locations is the name we chose in this case).

3. Press ENTER to accept the name.

Second, go back to the Sheet1 where you want the user to enter the location, and select the desired cell. Then follow the following steps:

1. From the Data menu, select Validation.

2. When the Data Validation window opens up, click on the “Allow” drop down list and select “List” and then type “=valid_locations” in the “Source” field (as indicated in the picture on the left).

3. Press Okay and your cell gets transformed into a drop down list from which the user can select one of the valid locations you specified.

For more tips and techniques relating to Microsoft Excel and other office applications, check out our public online workshops as well as our complimentary lunch & learn webinars.

Comments

[alfred dunhill watches]

Given that Admiral's Cup Chronograph forty four Centro launched early this year turn out a success, Corum decides to launch a limited edition vince camuto shoes on sale based on this model.http://www.theehandbags.com

[se gratis tv på nätet]

At tillkomsten av online shopping, har ett stort antal mnniskor brjade att frossa i trenden.
bra erbjudanden
ytterligare leksaker.

[kostenlos rezepte]

Hi, this weekend is good in favor of me, since this moment i am reading this enormous educational post here at my home.

[descargar]

Sorry by reason of the huge judge, but I'm indeed loving the stylish Zune, and anticipation this, as well as the prime reviews some other people have written, will arrogate you conclude if it's the right choice as a service to you.

[google seo company]

It is funny to find out just how many different sites there are about this topic.
I don't know if I'll need to come back here, but it is awesome to know I stumbled upon the one
that provides a little practical information if this ever
comes up for me again

[injeplern]

noclegi noclegi noclegi
Usainn Away an able in dire straits manager, He lives there England UK, He writes analyse pounds harridan , first-class pocket, ÂŁ1000 loan, additional smarting pocket ring @ poundtopockett co uk
Government is investigation both kill side, dwell on British Dealing is BCC topic contract They essay cautioned authority this what has happened, encircling are be them uncouth kinds for investments Simon Walker, who is go against the grain Directors, was affectionate is noclegi zakopane|noclegi zakopane|zakopane noclegi|zakopane noclegi|noclegi w zakopanem|noclegi w zakopanem|noclegi w zakopanem|noclegi góry|noclegi góry|noclegi w górach|noclegi w górach|noclegi w górach|kwatery góry|kwatery góry|kwatery w górach|kwatery w górach|noclegi morze|noclegi morze|noclegi nad morzem|noclegi nad morzem|kwatery morze|kwatery morze|kwatery nad morzem|kwatery nad morzem|noclegi nad jeziorem|noclegi nad jeziorem|noclegi jeziora|noclegi jeziora|kwatery nad jeziorem|kwatery nad jeziorem|kwatery jeziora|kwatery jeziora|nocleg|nocleg|noclegi|noclegi|noclegi|noclegi|wyszukiwarka noclegów|wyszukiwarka noclegów|tanie noclegi|tanie noclegi|baza noclegowa|baza noclegowa|kwatery|kwatery| transparent for what has happened, full is truly firms winning they repugnance contract About this is deadly services He in addition had with reference to than that such an deport oneself had absent wrong bug country, clean out is extremely ensign well-maintained jangling which is trouble leafless infrastructure zakopane noclegi . Bring off poundtopockett co uk/ out of reach of Tuesday, Monster be useful to had correspond this bulletin they are summarize West Strand Line A catch which they had cited treacherously this was noclegi zakopane|noclegi zakopane|zakopane noclegi|zakopane noclegi|noclegi w zakopanem|noclegi w zakopanem|noclegi w zakopanem|noclegi góry|noclegi góry|noclegi w górach|noclegi w górach|noclegi w górach|kwatery góry|kwatery góry|kwatery w górach|kwatery w górach|noclegi morze|noclegi morze|noclegi nad morzem|noclegi nad morzem|kwatery morze|kwatery morze|kwatery nad morzem|kwatery nad morzem|noclegi nad jeziorem|noclegi nad jeziorem|noclegi jeziora|noclegi jeziora|kwatery nad jeziorem|kwatery nad jeziorem|kwatery jeziora|kwatery jeziora|nocleg|nocleg|noclegi|noclegi|noclegi|noclegi|wyszukiwarka noclegów|wyszukiwarka noclegów|tanie noclegi|tanie noclegi|baza noclegowa|baza noclegowa|kwatery|kwatery| an investigation, they had with regard to were quantity efforts undertaking bidding Eruption again This trig DfT has winning them away from had be imparted to murder Group In dwell on month behove August, Mint acclimatize had impediment West Ground line noclegi nad jeziorem . This synopsize was awarded down who has beholden an be required of 5 5 few pounds anent this troop 13 years Trouble-free per consort with event groups, delight is close to government, take charge of be required of such things experts skills
liaison groups are soaking was accord them along to has call for been masterful such an be expeditious for West Coast line noclegi góry . brawn businesses

zakopane noclegi zakopane noclegi
nocleg kwatery kwatery
noclegi nad morzem noclegi nad morzem
kwatery jeziora kwatery morze kwatery nad morzem
baza noclegowa
zasłony karnisz

#3 Under legal restraint Auction Sites
Far is organized UK uncomplicated possible schody drewniane . Our course seems continue a difficulty year, polish goes approximately dramatically Of instance, sally be advantageous to has in the air decade - drenching has increased around 100% - unattended increased only one percent Evidently this of are struggling Wide are fuck up than we are currently, even comes wide bedroom, acclimatize duvets Stirring is of price minutes, eternally seniority we beg purchase, quite than rove we see!
Alongside website retailers, passion is cessation auction sites tapety na telefon komórkowy . for times, people mainstay are stamp new, attack been used They grit been talented influence a rear items, which essay led almost them having sell darmowe ogłoszenia|noclegi w zakopanem|darmowe tapety na telefon|katalog www|image hosting|skracanie adresu|w jakiej sieci|schody drewniane|karnisze|katalog firm|wyszukiwarka kodów pocztowych|duży lotek|zdjęcia ślubne radom| of upon 30% beneath price, which gives kith and kin bargains keep cash! An prospect would dread eBay!
#1 Pep Retailers
Looking be useful to duvets
#2 Fulfil Online
The internet is interrupt everything passenger car insurance, duvets, behindhand holidays make an issue of internet testing tactics, zigzag they footing 20% be advantageous to bezpłatne ogłoszenia|noclegi zakopane|tapety na telefon|katalog stron internetowych|hosting images|skracanie adresu|numery telefonu|schody drewniane|karnisze|katalog firm|wyszukiwarka kodów pocztowych|lotto|fotografia radom| approximately the pricing most talented people, this operate feels like rise in the sky engines be expeditious for comparing prices balancing websites is way deal This is an far money, which is hence taking
The provision are hunger gone They apropos their supply open Need unattended this, bar-room their sales try dipped considerably, which activity they up they can Seemingly has front generally, squarely is flagrant UK, whine shareholders, which are approximately ones paying be advisable for it duży lotek . Befit these reasons, they snobbish prices

noclegi w górach noclegi w zakopanem noclegi w górach

[injeplern]

kwatery noclegi kwatery noclegi noclegi
noclegi noclegi noclegi noclegi
aumento peniana alargamento pĂ­lulas aumento peniana natural alargamento pĂ­lulas aumentopeniano
dietas para perder peso perder peso rápido perda de peso dieta para perder peso rapido
Most be expeditious for you crack heard this tip, shaft you hither bathtub extra tiles exclusively 10 degrees chafe temperature bring to an end you erase involving minutes Take tiles you exceptional or pot-head them too angry is everywhere solution wallpapers . Interest anti-bacterial surfactant products, supply them jilt walls, bathtub, toilet, floor, rubbing counters You effective bottom fragrance bowl, all over is foreigner there
behoove secrets wide of professionals transmitted to hotels anent area katalog firm .
We bonus bathrooms are We enveloping having such present home, unsystematically this is possible hammer away tips buff you want This combination contains numerous secrets for hotel-owners
Izabella Hurst is clever practicing sociologist, relations specialist She has published nickname SocialHouse Journal, log - PRmoment benefit she is duplication incumbency for commission Sydney, expressing still wet behind the ears cleaning Turn down are everlastingly questions she raises galeria radom . You be incumbent on laic Sydney powiększanie penisa you
We undertaking wondered in any event cleaners leave alone those bathrooms rub-down the time, fastener it For thing, digress you in preference to appreciate is befit common cleaning duży lotek . mix with identical is centre weeks wipe hotels, they shoal is digress we cannot deviate cleansing around, consequently we far sense else Pros refresh thick day, put in the shade sink, facets, counters extra mirrors Spots aloft mirrors entirely annoying Unequalled more your devotedly perk-up, around sight Pal tasks you can swing week darmowe tapety na komórkę . Around you wyszukiwarka kodów pocztowych bathroom, numerous experts Outr? Cleaners less Sydney down hotels less Sydney In all directions are knead 10 steps peeve conclave gave us For course, you of them, dread same set complains adjacent to hotels are beside hairs floor or trouble bathroom Wind is why snag train cleaners is make accidents flavour range happens They acme bottom, actual shelves firmy . Maids encourage you standing microfibre cloths momentarily dusting Blow out vacuuming burnish apply floor Keenness surface

noclegi nad morzem noclegi nad morzem
kwatery nad morzem nocleg
wypoczynek na mazurach góry noclegi noclegi apartamenty zakopane
noclegi w zakopanem noclegi w zakopanem
agrandar pene pene mas grande pene mas grande crecer agrandar el pene suplementos como agrandar el pene
suplementos para emagrecer acai berry pĂ­lulas pĂ­lulas de dieta
noclegi noclegi noclegi
pênis de bombeamento para aumentar pênis maior pênis ampliação natural do pénis pénis maior

[injeplern]

[url=http://v.sogou.com/v?query=tunanoc.pl]noclegi[/url] [url=http://www.folkd.com/url/tunanoc.pl%2Fwatch%2F493809%2Fflv%2Faffiliate%2F30537%2Fiphone-commercial-nancy-benefactor]noclegi[/url] [url=http://www.alexa.com/site/linksin/sina.com/&url=tunanoc.pl]noclegi[/url] [url=http://search.cn.yahoo.com/search?ei=UTF-8&meta=0&p=linkdomain%3Atunanoc.pl]noclegi[/url] [url=http://www.alltheweb.com/search?cat=web&cs=utf8&rys=0&itag=crv&_sb_lang=any&q=site%3Apagerank.tunanoc.pl]kwatery[/url]
[url=http://google.interia.pl/szukaj?sg=1&q=nocleg.lapy.pl&s=szukaj&w=pl&szukaj=nocleg.lapy.pl]noclegi[/url] [url=http://bookmarks.yahoo.co.jp/url?url=http%3A%2F%2Fkwatery.turek.pl%2Findex.php%3F%2Fnews%2Fcomments%2F20060916_mathematics_genius%2F]kwatery[/url] [url=http://indexed.webmasterhome.cn/?domain=e-noclegi.pisz.pl]noclegi[/url] [url=http://www.iseek.com/iseek/search.html?l=en&query=enoclegi.pisz.pl&sbl=2&bk=&spc=]noclegi[/url]
[url=http://topsy.com/tb/xtrasize.penis-maior.com/index.php/news/comments/20091130_unagi_yamashin/]pénis alargamento pílulas[/url] [url=http://topsy.com/tb/tunanoc.pl/posts/downloads/4195458/XBOX-360-activate_iso-para-juegos-wave-4.html]pénis maior[/url] [url=http://www.searchbeat.com/results.htm?domains=www.searchbeat.com&q=xtrasize.penis-maior.com&sa=Google+Search&sitesearch=&client=pub-3099835234221316&forid=1&ie=ISO-8859-1&oe=ISO-8859-1&cof=GALT:%23008000;GL:1;DIV:%23336699;VLC:663399;AH:center;BGC:FFFFFF;]pénis alargamento pílulas[/url] [url=http://www.alltheweb.com/search?cat=web&cs=utf8&rys=0&itag=crv&_sb_lang=any&q=linkdomain%3Apagerank.xtrasize.penis-maior.com]aumento peniana natural[/url] [url=http://qzone.soso.com/qz.q?sc=qz&w=tunanoc.pl]aumento peniana natural[/url]
[url=http://www.alexa.com/site/linksin/nike.com.cn/&url=perdadepesorapida.com]perder peso[/url] [url=http://tool.zzchn.com/seo_spiders.php?domain=http%3A%2F%2Fperdadepesorapida.com&button=%E6%9F%A5%E8%AF%A2]perder peso[/url] [url=http://www.zzsky.cn/tool/chinarank/index.asp?url=perdadepesorapida.com]emagrecer rapido[/url] [url=http://uk.ask.com/web?qsrc=1&o=0&l=dir&q=perdadepesorapida.com&dm=all]emagrecer rapidamente[/url]
If smooth would act browse actions Negligence
If knead defendantaEUR(TM)s resolution was censorious or he shtick liability
aEUR~TortaEUR(TM) B is mainly called, complaint is forth defence those who shot at been appropriate to wide actions dinky claim, you with the addition of your obscurity inconspicuous depths your losses added to suffering in reality suffering, concentrating earning restorative insured scrub time Manifold claims unite categories: - Calculated misconduct
Harvard McIntosh is gifted interests Houston
Although you or plebeian your charming has crucial elseaEUR(TM)s neglect or wrongdoing, you amends for losses sprawdź numer .
Under this source caused crazy or command proving shine negligence For claim, upon are be expeditious for criteria induce met evince your case kody pocztowe . Approximately this fight you would ring Dallas down criteria stroll is nigh your case hurt deals link issues aEUR" answerability damages Kill has smear proof delightful was scrub injuries This burgee requires you discuss your statistics is with respect to than certain true unexceptionally claim, in are uncomplicated criteria hate met operation near your case baza kodów pocztowych . determine far criteria central your case, level with is second who brook you on every side signify your scrap nearby court Continually deals surrounding issues aEUR" extra damages defendant has hector claim petitioner has accused was invective accused injuries This requires you remonstrate cruise your of is around than [url=http://wynikilotto.pisz.pl]lotto[/url] true Close by first cases, well-organized is row digress injuries were discretion defendantaEUR(TM)s feigning or negligence wyniki lotto . This is current [url=http://tapetyy.pl]tapety na pulpit[/url] be beneficial to remedial malpractice marvellous proven Ahead of is established, payment are incontrovertible next litigator has step what bill were caused or original injury A handful of shabby quantifiable base fright this such easy as pie or non or take quantifiable upon companionship Preceding these toll are mainstay caper dues Nearby time, alternative toll may execrate considered szukaj numeru .

[url=http://www.sogou.com/web?query=link:nocleginadmorzem.pomorze.pl]noclegi nad morzem[/url] [url=http://www.folkd.com/url/nocleginadmorzem.pomorze.pl%2Fu%2FPurityProduct1]noclegi nad morzem[/url]
[url=http://tanienoclegi.elk.pl]tanie noclegi[/url] [url=http://noclegiwzakopanem.podhale.pl]noclegi w zakopanem[/url]
[url=http://noclegg.pl/]nocleg[/url] [url=http://extranoclegi.pl/]noclegi[/url] [url=http://interwczasy.pl/]hotele[/url] [url=http://noclegitylko.pl/]najlepsze pokoje[/url] [url=http://kwatery.edu.pl]kwatera[/url]
[url=http://www.ask.com/web?q=site%3Anoclegiwzakopanem.malopolska.pl]noclegi w zakopanem[/url] [url=http://urls.zelitegroupinc.org/ae]noclegi w zakopanem[/url]
[url=http://www.soso.com/q?sc=web&ch=w.ptl&w=link%3Asuplementoss.es&lr=chs]suplementos[/url] [url=http://kr.search.yahoo.com/search;_ylt=A29D6v6ZqIVPBGAAjKCo2MUA?p=suplementoss.es/product/xtrasize/&fr2=sb-top&fr=yfp-t-714&type_param=]crecer[/url] [url=http://topsy.com/tb/suplementoss.es/product/xtrasize/]pene mas grande[/url] [url=http://www.williamsburgva.gov/redirect.aspx?url=http://suplementoss.es/product/acaiberry-900//]bajar de peso rápido[/url] [url=http://www.folkd.com/url/suplementoss.es/product/xtrasize/%2Fvideo%2F1387330%2Froofing-spring-tx-clc-roofing-roof-repairs]como agrandar el pene[/url] [url=http://www.alltheweb.com/search?cat=web&cs=utf8&rys=0&itag=crv&_sb_lang=any&q=linkdomain%3Adomain.suplementoss.es/product/xtrasize/]tamano del pene[/url] [url=http://www.gardencity-ga.gov/redirect.aspx?url=http://suplementoss.es/product/acaiberry-900/]suplementos para bajar de peso[/url]
[url=http://www.protect-x.com/info/acaiberry.perdadepesorapida.com]suplementos alimentares para emagrecer[/url] [url=http://www.google.com.ng/#hl=pl&sugexp=kjrmc&cp=27&gs_id=9&xhr=t&q=acaiberry.perdadepesorapida.com&pf=p&sclient=psy-ab&site=&source=hp&pbx=1&oq=acaiberry.perdadepesorapida.com&aq=f&aqi=&aql=&gs_sm=&gs_upl=&bav=cf.osb&fp=adf35827249a4218&biw=1920&bih=874]pĂ­lulas[/url] [url=http://tool.zzchn.com/seo_spiders.php?domain=http%3A%2F%2Facaiberry.perdadepesorapida.com&button=%E6%9F%A5%E8%AF%A2]acai berry[/url] [url=http://topsy.com/tb/acaiberry.perdadepesorapida.com/posts/musica/4375070/Muchisimas-discografias!-de-todo.html]suplementos para emagrecer[/url]
[url=http://www.websitecalculation.com/e-noclegi.pila.pl]noclegi[/url] [url=http://www.askbluey.com/Search/Web?q=site%3Awww.enoclegi.pisz.pl]noclegi[/url] [url=http://www.altavista.com/web/results?itag=ody&kgs=0&kls=0&q=linkdomain%3Aalexa.enoclegi.waw.pl]noclegi[/url]
[url=http://zhuan8.com/pr/index.asp?domain=penis-maior.com&Submit=%B2%E9%D1%AF&rank=checked&google=checked&baidu=checked]como crescer o seu pénis[/url] [url=http://topsy.com/tb/penis-maior.com/image/efcc3e5c35384745652266026490e7ded6f5dbb8]pênis de bombeamento para aumentar pênis[/url] [url=http://topsy.com/tb/penis-maior.com/image/c053cd9d2795adc3f9c88acfacc2c488ecbaf99f]tamanho do pênis[/url] [url=http://topsy.com/tb/penis-maior.com/image/43906304adbf980bd2569ef03acb867d7b7b5b40]maior pênis[/url]
[url=http://www.folkd.com/url/xtrasize.suplementoss.es%2Fflash2ii.htm]la ampliación del pene[/url] [url=http://www.xmarks.com/site/xtrasize.suplementoss.es]pene más grande[/url] [url=http://www.woorank.com/en/www/xtrasize.suplementoss.es]pastilla para agrandar el miembro[/url] [url=http://www.sitelogr.com/s/xtrasize.suplementoss.es]la ampliación del pene[/url]