Question

When you sort a cell range using a to z or z to a, what is rearranged?

Answer 1

Only those cells names. Most common mistake in excel. If you want to sort rows make sure you highlight everything and then use sort function on column