answersLogoWhite

0

If you have two columns to sort on, like firstname and surname, you will want the first sort on surname and the second sort of firstname. That way your surnames will be in order and within each surname, people will have their firstnames in order.

User Avatar

Wiki User

12y ago

What else can I help you with?

Related Questions

How repeat sort data action in Excel 2007?

I've noticed that excel can remember that sort order if the first row of the second group you want to sort equals the first row of the first group you had already sorted. How to change it? I don´t know. No official answer, sorry


Why is Excel for Windows important now a days?

because these days people have finance problems then they can sort it out on them but especially shops.


How do you sort in Microsoft Excel?

Highlight the cell range you want to sort and click on the sort button. For Excel 2007, it is on the Home menu ribbon in the Editing section (on the right side of the ribbon).


How do you order numbers in excel?

Highlight the cells you want to sort and click on the sort button.


What XSL element can you use to sort or order your XML data?

Assuming "XLS" means MS Excel, you can import your XML data to Excel, then filter or sort as desired.


How do you sort out excel typing errors?

If by "sort out," you mean find and correct, then use the spell checker.


Can you sort files in ascending and descending orders?

no only data can be sort from the excel sheet.. not in the file


How do you sort linked data in excel?

You are able to sort linked data within any Excel document. If an error does occur check each columns formula so there Is agreement.


How can you sort data in excel with more than 2 columns?

Select Custom Sort and add as many sort levels as you like.


Excel' sort 'option available in which menu?

The Data menu.


Why do you use Sort Data function in Microsoft Excel?

The sort feature allows you to look at the same data in different orders depending upon what information you seek. Excel allows you to sort by date, sort by text or numbers, sort by multiple columns, like listing values from highest to lowest or names in alphabetical order.


What are the field or fields you select to sort the records in Excel called?

The fields used to sort records in Excel are called "sort keys" or "sort columns." When you sort data, you specify one or more columns as the criteria for ordering the records, allowing you to arrange the data in ascending or descending order based on the values in those columns.