filmov
tv
How to create a drop-down list in Microsoft Excel
Показать описание
You can help people work more efficiently in worksheets by using drop-down lists in cells. Drop-downs allow people to pick an item from a list that you create.
Data entry is quicker and more accurate when you use a drop-down list to limit the entries people can make in a cell. When someone selects a cell, the drop-down list’s down-arrow appears, and they can click it and make a selection.
You can make a worksheet more efficient by providing drop-down lists. Someone using your worksheet clicks an arrow and then clicks an entry in the list.
► Follow us on social:
#Microsoft365 #MicrosoftExcel
Data entry is quicker and more accurate when you use a drop-down list to limit the entries people can make in a cell. When someone selects a cell, the drop-down list’s down-arrow appears, and they can click it and make a selection.
You can make a worksheet more efficient by providing drop-down lists. Someone using your worksheet clicks an arrow and then clicks an entry in the list.
► Follow us on social:
#Microsoft365 #MicrosoftExcel