![]() For example, if you do department reporting, you might want to create a custom list that includes all of them. The list of items you see is dependent on another cell reference value. In contrast, Excel Dependent Lists are conditional. They tend to be used frequently and are known entities. When you think about Excel’s built-in lists, there are some common denominators. One question you may want to answer is which type of list you need. ![]() This is helpful to people who do similar reports on a frequent basis. In addition to not having to type the list each time you need it, the lists can be used across workbooks. Maybe it’s employee names, product SKUs, or sports teams. The difference is you define the values that pertain to your work or reports. Think of them as your version of Excel’s built-in lists for months, days, etc. When you drag the fill handle, you see your pre-defined entries appear.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |