Sheet Sorting by Name Sort data sheet by name. From the menu bar, click Tools > Sheet Sorting by Name. Select sorting order. Ascending Order: A to Z Descending Order: Z to A