excel两列数据正确排序
在Excel中排序不正确 (Out of Sorts in Excel)
Without family, where would Excel blog ideas come from? My daughter called today, and asked how to sort more than 3 columns in Excel. She uses Excel 2003, and the Sort dialog box only allows three column choices.
没有家人,Excel博客构想将从何而来? 我女儿今天打电话给我,问如何在Excel中对3列以上进行排序。 她使用Excel 2003,并且“排序”对话框仅允许选择三列。
There's no box to choose the fourth column – Name.
没有选择第四栏的框-名称。
Obviously, she didn't check my website, where she would have found the instructions to sort by four columns in Excel.
显然,她没有检查我的网站,在该网站上可以找到按Excel的四列进行排序的说明。
You can sort in groups of 3, working up from the least important to the most important. So, I told her to sort the fourth column (Name), then the first three (Service, City, Rating).
您可以按3个一组进行排序,从最不重要到最重要。 因此,我告诉她对第四列(名称)进行排序,然后对前三列(服务,城市,评分)进行排序。
在Excel 2007中排序 (Sorting in Excel 2007)
If you like to sort lots of columns, you'll be happier in Excel 2007. There, you can sort up to 64 columns at one time.
如果您希望对很多列进行排序,那么您在Excel 2007中会更快乐。在那里,您一次最多可以对64列进行排序。
If my daughter had Excel 2007, she could choose all four columns, and sort them in one step. In the Sort dialog box, click the Add Level button, to include another column in the sort specifications.
如果我的女儿使用Excel 2007,则可以选择所有四列,然后一步将其排序。 在“排序”对话框中,单击“添加级别”按钮,以将另一列包括在排序规范中。
自动排序 (Automating the Sort)
If you turn on the macro recorder while sorting in Excel 2007, you can create a macro to sort the table. Then, run that macro later, when you need to sort the table again.
如果在Excel 2007中进行排序时打开了宏记录器,则可以创建一个宏来对表进行排序。 然后,当您需要再次对表进行排序时,稍后再运行该宏。
However, if you're sending the workbook to someone who uses Excel 2003, they'll get an error message if they try to run your sort code.
但是,如果您将工作簿发送给使用Excel 2003的人员,则他们在尝试运行您的排序代码时会收到错误消息。
Just like families, sometimes the different generations don't communicate too well. 😉 Because the sort feature changed so much in Excel 2007, the older versions don't recognize some of the new properties.
就像家人一样,有时候不同世代之间的沟通不太好。 😉由于排序功能在Excel 2007中发生了很大变化,因此较旧的版本无法识别某些新属性。
If you plan to use the workbook in both versions of Excel, record the sort macro in Excel 2003. This will also run without problems in Excel 2007.
如果计划在两个版本的Excel中都使用工作簿,请在Excel 2003中记录排序宏。这也将在Excel 2007中正常运行。
Here's the code from this example, with the Name in column D being sorted first.
这是此示例中的代码,其中D列中的Name排在第一位。
翻译自: https://contexturesblog.com/archives/2009/11/13/out-of-sorts-in-excel/
excel两列数据正确排序