For this example, check California, click OK, and the database is reduced to only those rows and records equal to California. Note that the rows now say 1, 7, 8, and 18 through 1048576.

Excel's checkboxes seem like a very simple feature on the surface—which is probably why they're often overlooked. But when used properly, this underrated feature can transform your spreadsheets into ...