People often need to cover up city in excel when processing forms. Unfortunately, few applications provide the tools you need to accomplish this task. To do something like this normally requires changing between several software applications, which take time and effort. Luckily, there is a solution that works for almost any job: DocHub.
DocHub is an appropriately-developed PDF editor with a full set of helpful capabilities in one place. Editing, approving, and sharing forms gets simple with our online tool, which you can use from any internet-connected device.
By following these five easy steps, you'll have your modified excel quickly. The intuitive interface makes the process fast and effective - stopping jumping between windows. Try DocHub today!
in this excel file I have a data entry sheet with two columns where I would like users to select a country and then a city from that country I would like a drop-down list in each of these columns so here they can select from a drop-down list of countries and then only the city for whatever country they have selected should show up in column C thereamp;#39;s another sheet here called my list and I have a list of the two countries and two lists that show the cities from Canada and the cities from USA to use those lists here Iamp;#39;m going to name the lists on this sheet so Iamp;#39;m selecting these two cells that are the country names and click in the name box up here and type a one-word name so Iamp;#39;ll call this country list and then press ENTER to complete that name same for these city lists so Iamp;#39;ll select those three names and call that Canada list and press ENTER and for this one Iamp;#39;ll select those cities and call that USA list so I ended all the names with
