Select 5 or more Order Key in Excel Sheet to SORT

[TSWA]

Hello, I am developing Excel Project to my Office and I need to know if is possible select 5 or more rows to Order(Order Key in the option SORT, in Standard Bar, you can Select 3 rows at the same time)

Example
Name Cost AVG Amount Asigned Total
Monique 225 3% 231.75 45 276.75
Theodore 365 7% 390.55 25 415.55
Ralf 415 5% 435.75 65 500.75
Canute 254 4% 264.16 10 274.16

I want to sort the data using Total(Order1), Cost(Order2), Asigned(Order3) and Name(Order4). The Sort option in Excel only accept until Order3. Is possible Select Order4 or more?

Thanks,

Best regards from Panama

 

[bluedragon2]

Sort rows based on the contents of two or more columns
For best results, the list you sort should have column labels.

Click a cell in the list you want to sort.


On the Data menu, click Sort.
Show Me

In the Sort by and Then by boxes, click the columns you want to sort.
If you need to sort by more than three columns, sort by the least important columns first. For example, if your list contains employee information and you need to organize it by Department, Title, Last Name, and First Name, sort the list twice. First, click First Name in the Sort by box and sort the list. Second, click Department in the Sort by box, click Title in the first Then by box, and click Last Name in the second Then by box, and sort the list.

Select any other sort options you want, and then click OK.
Repeat steps 2 through 4 if needed, using the next most important columns.

Notes

If the column you specify in the Sort by box has duplicate items, you can sort the values further by specifying another column in the first Then by box. If there are duplicate items in the second column, you can specify a third column to sort by in the second Then by box.


When you sort rows that are part of a worksheet outline, Microsoft Excel sorts the highest-level groups (level 1) so that the detail rows or columns stay together, even if the detail rows or columns are hidden.