The issue was easy. I had a protracted desk of delivery information that I wanted to export from Numbers to Excel by way of File > Export To > Excel. After making selections and saving the exported file, Numbers popped up with an error: “Some modifications have been made to your exported spreadsheet. Filtered desk cells have been exported hidden.”
I hadn’t recalled enabling a filter within the Arrange Inspector’s Filter tab. However there it was. Filters allow you to exclude or embody rows based mostly on detailed standards you possibly can set. They apply to the at present chosen desk. As an illustration, maybe you need to see solely rows that comprise a film you ranked as 4.0 or larger, simply tackle entries for folks in Texas, or folks born after 1979. It is a highly effective solution to form outcomes, letting Numbers act only a bit like a database.
Nevertheless, as soon as a filter is enabled for a desk, should you don’t entry the desk for some time, you may overlook it exists should you don’t view the inspector’s tab. Numbers offers solely a easy visible clue as soon as a filter is in place: any omitted row has a barely thicker line between row numbers, and the row numbering will not be sequential—that’s, 1, 2, 3, 4, 5 with row 4 filtered will seem as 1, 2, 3, 5.
In the event you ever use filters, concentrate when utilizing Numbers to keep away from omitting information whenever you’re exporting:
Look ahead to the Excel or comparable export error.
Choose a desk, go to View > Inspector > Arrange, and click on Filter.
Choose a desk and select Arrange > Flip Filters Off or press Command-Choice-F.
Conversely, if you wish to filter a desk earlier than exporting, keep in mind to depart the filters on. An export all the time displays the state of information as you see it in Numbers.
Ask Mac 911
We’ve compiled a listing of the questions we get requested most incessantly, together with solutions and hyperlinks to columns: read our super FAQ to see in case your query is roofed. If not, we’re all the time searching for new issues to resolve! E mail yours to firstname.lastname@example.org, together with display screen captures as acceptable and whether or not you need your full identify used. Not each query can be answered, we don’t reply to e mail, and we can not present direct troubleshooting recommendation.
Welcome to Handcuff Herald The goal of Handcuff Herald is to give you the absolute best news sources for any topic! Our topics are carefully curated and constantly updated as we know the web moves fast so we try to as well.