Current location - Recipe Complete Network - Complete cookbook - What does it mean to set the source of data validity in EXCEL? Can the general ledger account in the bill list table be set as a drop-down menu? Yes, how?
What does it mean to set the source of data validity in EXCEL? Can the general ledger account in the bill list table be set as a drop-down menu? Yes, how?
The content or range of cells used as drop-down options.

Select the GL account column in the bookkeeping list, and under the data option in Data Validity and Settings, select the series as the type, enter the source GL account names separated by English commas, or directly select the cell area where the GL account is located, and click OK to generate the GL account drop-down menu.