With the Maveric upgrade, we cannot categorize or sort just a section of a table. ANyone knows how to do it?
iMac, Mac OS X (10.6)
The only control to survive the upgrade is the hidden menu for the column. Hover over the bar above the selected column and click the little triangle that appears, or Right-Click the bar, to get the menu that includes the Sort command.
Jerry
But the sort by category is gone. I cannot find it.
The Reorganize Panel is gone. The only sorting left is what I described. Go to Numbers Feedback and tell Apple...
Jerry
I believe they left the old version of Numbers, Pages and Keynote on the system after the upgrade. I do not know if they plan on leaving it there or just wanted to see how many liked the new formats...
I've left feedback about this, but I guess I'm headed back to Excel. This function was critical to what I'm using Numbers for at this point. I can understand changing an interface if you think you have a better way to do someting, but to completely remove a function that has existed for some time seems strange to me. Numbers can make pretty presentations of information, but if it can't perform the underlying functions that one needs, what's the point.
Joe,
For now, there is nothing stopping you from using the old Numbers app. If you liked it better than Excel last week, it should still be better this week.
Jerry
I updated my post to say that I found the "old" Numbers and was able to launch it, but unfortunately I'm not connected to my Time Machine backup drive at the moment, and I didn't make a copy of the file before I opened it. I was able to copy and paste the table from the "new" Numbers into the old Numbers.
I started using Numbers about two years ago. There are things I like about it and things I don't. For me, figuring out how to consistently format borders in cells is much easier in Excel than in Numbers. But Excel doesn't have checkboxes or the new "stars" cell formatting.
I worked at Apple for about ten years in about five different jobs. I love Apple and I'm not a big fan of Microsoft. That said, Apple is a product/tech driven company and Microsoft is a customer driven company. Other than the sales folks that have to deal directly with customers, Apple doesn't really care much about what existing customers really want and need. Microsoft does. MS would never make a change to Excel that dropped functionality that might affect people's ability to get their work done — certainly not without a warning. But this isn't the place to make that argument, so I'll drop it here and take it to the feedback section.
Joe,
The Cell Border controls are more Excel-like in Numbers 3.0.
Set your line thickness and color, then click the Paintbrush/Line icon. When you choose a border segment, your preset will be immediately applied.
Jerry
I didn't make a copy of the file before I opened it. I was able to copy and paste the table from the "new" Numbers into the old Numbers.
Joe,
Just in case you have other documents you've opened in Numbers 3.0 that you want to take back to Numbers 2.3, you don't necessarily have to resort to copy and paste. You can export the document back to Numbers 2.3 format:
I don't look at this as Apple taking stuff away. I still have my Numbers 2.3 (and Excel). And now I have a new Numbers, for free, that is making life easier in other ways, in particular showing work via cloud sharing or tablet rather than having to print out a whole bunch of stuff and carry it around. Of course, you are right that Apple maybe has too much of an attitude that it knows what most of us really want before we even know.🙂
SG
Everytime I Use the Sort Function, My Values get lost in some rows and Change and are Incorrect in Others.
I Have a Column of Sum Totals and Just want to Sort in a Desending Order and All Heck Breaks out everytime I try...
Looks as if there has been enough feedback that Apple is going to restore some of the functionality they didn't have time to include in iWork if they wanted to make the announce deadline.
http://news.softpedia.com/news/Apple-Backpedals-on-Decision-to-Remove-iWork-Feat ures-398037.shtml
and
Multi-column sorting in Numbers appears to be on the list.
Would it have killed them to have this announcement ready to go at launch and put up a disclaimer for existing users so they could wait for the changes before executing the upgrade or at least pointing out that the older versions would still be there and where to look? 😉
Would it have killed them to have this announcement ready to go at launch and put up a disclaimer for existing users so they could wait for the changes before executing the upgrade or at least pointing out that the older versions would still be there and where to look? 😉
Would have been nice, wouldn't it! Especially since many people who use their phones and tablets just assume that upgrading means the old version is gone on the Mac too.
Thanks for posting the links. Here's Apple's announcement itself. I choose to interpret it as saying we can expect several releases in coming months and won't have to wait until May. But I'm an optimist in these things.🙂
SG
I miss Categorize too, but I now have started using Filter Table ... to get almost the same result in a different way.
changes to sorting on numbers
