The job was simple . I had a long table of shipping data that I needed to export from Numbers to Excel viaFile > exportation To > Excel . After make choices and saving the exported file , routine pop up with an erroneousness : “ Some change were made to your export spreadsheet . trickle board cadre were exported hidden . ”
Numbers warns you when you have filtered row and export data .
Foundry
Numbers warns you when you have filtered rows and export data.
I had n’t recalled enabling a filter in the Organize Inspector ’s Filter tab . But there it was . Filters let you turn out or include rows based on detailed criterion you could set . They put on to the currently select table . For instance , perhaps you require to see only rows that curb a movie you range as 4.0 or higher , just name and address entries for multitude in Texas , or citizenry tolerate after 1979 . This is a powerful means to work answer , letting Numbers play just a bit like a database .
However , once a filter is enable for a table , if you do n’t reach the mesa for a while , you might forget it exist if you do n’t view the examiner ’s check . number provides only a simple visual clue once a filter is in place : any miss row has a slightly thicker line between row phone number , and the row enumeration is not successive — that is , 1 , 2 , 3 , 4 , 5 with row 4 filtered will appear as 1 , 2 , 3 , 5 .
number has the lilliputian potential visual index of a filtered row . At top , I ’ve used a big red arrow and a magnify blowout to show where the thicker row marker is . At above mightily , you may see the filter setting . At bottom , observe that the filter was remove and the row indicator is gone : the row numbers are consecutive .
Numbers has the tiniest possible visual indicator of a filtered row. At top, I’ve used a big red arrow and a magnified blowout to show where the thicker row marker is. At above right, you can see the filter setting. At bottom, note that the filter was removed and the row indicator is gone: the row numbers are sequential.
If you ever use filters , pay attention when using number to avoid leave out information when you ’re exporting :
Conversely , if you want to permeate a mesa before exporting , call back to allow the filters on . An export always reflects the state of data point as you see it in Numbers .
Ask Mac 911
We ’ve compiled a list of the doubt we get asked most ofttimes , along with answer and contact to columns : translate our super FAQto see if your question is traverse . If not , we ’re always looking for new problem to figure out ! netmail yours tomac911@macworld.com , including covert captures as appropriate and whether you want your full name used . Not every question will be answer , we do n’t respond to electronic mail , and we can not put up direct troubleshooting advice .
