sort in excel spread sheet

Copper Contributor

sort headings in columns by a to z.

1 Reply

@drccolo1960

If you only want to sort the headings, select them. If you want to sort the rest of the data with them, either select the entire range, or a single cell in the header row.

On the Home tab of the ribbon, in the Editing group, select Sort & Filter > Custom Sort...

Alternatively, activate the Data tab of the ribbon, and click Sort in the Sort & Filter group.

In the Sort dialog, click Options...

Select 'Sort left to right', then click OK.

HansVogelaar_0-1719500737929.png

Select the row on which you want to sort:

HansVogelaar_1-1719500796954.png

Click OK.