Whether you are already used to dealing with spreadsheet or handling this format the very first time, editing it should not feel like a challenge. Different formats may require specific apps to open and edit them properly. Nevertheless, if you have to swiftly set city in spreadsheet as a part of your typical process, it is advisable to get a document multitool that allows for all types of such operations without the need of additional effort.
Try DocHub for efficient editing of spreadsheet and also other document formats. Our platform provides easy papers processing regardless of how much or little prior experience you have. With tools you need to work in any format, you will not have to switch between editing windows when working with every one of your documents. Easily create, edit, annotate and share your documents to save time on minor editing tasks. You’ll just need to sign up a new DocHub account, and then you can start your work instantly.
See an improvement in document processing productivity with DocHub’s simple feature set. Edit any document easily and quickly, irrespective of its format. Enjoy all the advantages that come from our platform’s simplicity and convenience.
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 theres 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 Im going to name the lists on this sheet so Im selecting these two cells that are the country names and click in the name box up here and type a one-word name so Ill call this country list and then press ENTER to complete that name same for these city lists so Ill select those three names and call that Canada list and press ENTER and for this one Ill select those cities and call that USA list so I ended all the names with list and Ill be able to use that later when I