How excel displays ascending order of data in other spreadsheet

Closed
akshay@kumar Posts 1 Registration date Tuesday January 12, 2016 Status Member Last seen January 12, 2016 - Jan 12, 2016 at 11:47 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Jan 12, 2016 at 11:53 AM
hello,

I try to prepare data of students details with random serial no.s in one excel spreadsheet. How I link it to display ascending order i.e.smallest no. to largest no. in other spreadsheet.
Please explain solution.

Thanking you.
Related:

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
Jan 12, 2016 at 11:53 AM
Hi Akshay,

You can find the option to sort your data under the data ribbon.

Not sure what you mean by automatically.

Best regards,
Trowa
0