To see what Excel did, click Manage Data Model in the Data Tools group ... Notice the bold line at the top of the table icon? That means the table is part of a relationship, and hence in the ...

For data nerds, Excel's drop-down lists are a lovely gift. They keep entries consistent across multiple rows — no misspelled words or names written without capitalization. Drop-down lists are ...