The only way to make a large amount of data readable is by organising it, not very exciting but it goes a long way! One of the most useful and common ways of arranging data is by ascending or descending order. Simply select the range of cells you wish to sort and then click one of the options; sort ascending, sort descending, or custom sort. You can sort your data with either of the following pathways:
- Right click > Sort > Select option
- Home > Sort & Filter > Select option
- Data > Select option
If the range you select has rows or columns of data next to it you’ll see this message. By expanding and sorting Excel will sort all your connected data accordingly.