Farrukh.Alyana
New Member
Respected Seniors,
Good day to you.
I want to know how to sort multiple selections within the same column.
Multiple areas are highlighted in "Yellow", in the attachment which I want to sort in the given sequence of columns (Ascending or Descending Order) without disturbing totals given at the end of each highlighted area.
1. Officers
2. Permanent
3. Retentional
4. Seasonal
5. Daily Wages
Can I sort all sections in one go?
I have had this problem for so long. Every time I attempt this sorting, Excel keep notifying me that "The command you chose cannot be performed with multiple selections. Select a single range and click the command again."
Waiting for your expert advice please.
Thanks and Regards.
Good day to you.
I want to know how to sort multiple selections within the same column.
Multiple areas are highlighted in "Yellow", in the attachment which I want to sort in the given sequence of columns (Ascending or Descending Order) without disturbing totals given at the end of each highlighted area.
1. Officers
2. Permanent
3. Retentional
4. Seasonal
5. Daily Wages
Can I sort all sections in one go?
I have had this problem for so long. Every time I attempt this sorting, Excel keep notifying me that "The command you chose cannot be performed with multiple selections. Select a single range and click the command again."
Waiting for your expert advice please.
Thanks and Regards.