More realistically, you wouldn’t choose to sort just one column. You'd be seeking to sort multiple columns of data by day. Suppose you have a dataset as shown beneath where you need to sort it based on the date in Column A. When you stop dragging, the chosen space appears https://www.customguide.com/excel/data-validation-excel