You have not remember there’s a filter active for a spreadsheet.
The problem was simple. I had a long table of shipping data that I needed to export from Numbers to Excel via File > Export To > Excel. After making choices and saving the exported file, Numbers popped up with an error: “Some changes were made to your exported spreadsheet. Filtered table cells were exported hidden.”
Numbers warns you when you have filtered rows and export data.
I hadn’t recalled enabling a filter in the Organize Inspector’s Filter tab. But there it was. Filters let you exclude or include rows based on detailed criteria you can set. They apply to the currently selected table. For instance, perhaps you want to see only rows that contain a movie you ranked as 4.0 or higher, just address entries for people in Texas, or people born after 1979. This is a powerful way to shape results, letting Numbers act just a bit like a database.
