Use dynamic arrays and tables for fast, scalable cascading drop-down lists in modern Excel.

Fragmenting your data across many Excel tabs is a common habit that silently kills file performance, introduces hidden errors, and turns reporting into a tedious chore. Here's why you need to stop.

Jason Chun is a CNET writer covering a range of topics in tech, home, wellness, finance and streaming services. He is passionate about language and technology, and has been an avid writer/reader of ...