VideoPhoto

Showing posts with label drop-down list. Show all posts
Showing posts with label drop-down list. Show all posts

15 August, 2021

TIPS for CLICKS: Using drop-down lists for data entry

This is an excellent helper for data entry in Excel. When we create worksheets with tables of data or databases, in many cases there are text entries, expressions or phrases that we have to enter repeatedly many times. In such situations we can create lists of entries, like people names, phone numbers, cities, days of the week, months, whatever is included in tables, and then create drop-down lists based on the entries. Later, instead of typing the entries one by one in our table we just select the entries from the drop-down list.

Here is a simple example, based on the list of fruits. Follow the steps below to create the list.