Sorting in excel Help

[Chrisquad305]

Hi, I wish to sort a very large excel file I have. Be

Excell 2 example.png

Attached is just an example of the scenario presented. ( the real one I have have over 600 Rows, and up to K columns).

I want to sort everything in the "A" column in numeral order, But it also move corresponding row along with it.

So when for this example when sorting column "A" - Number 1 would move to the top bringing the whole row up (Sam, White)

Thanks

[sourabhg98]

Hello that's quite simple
You just need to select your data i.e. from column A to Column K till whatever rows you have then right click>>>sort>>>custom sort>>>then select sort by column A and your data will be sorted...
Hope it helps....
Thanks

[davesexcel]

Hit Column A and goto =>data=> and click the A-z icon,
You will probably be asked if you want to expand the range and you will say yes.

[Chrisquad305]

Thank You!