After creating the relationship, Excel will identify those tables as a Data Model Table, not a Worksheet Table in the dropdowns. To see what Excel did, click Manage Data Model in the Data Tools group.

This post is brought to you by Diego Oppenheimer a Program Manager on the Excel team. I am very happy to be writing this blog post today. Not just because I will be showing you another way Excel can ...

If you've ever wanted to leverage the power of Data Validation in Excel combined with the flexibility of Web Excel, now you can! In this post we walk through an example of how easy it is to collect ...

A drop-down list in Excel is a great way to manage data and prevent mistakes. Shutterstock 2019-11-20T16:49:00Z ... An icon in the shape of a lightning bolt.