The Devices table is currently sorted by release date, but Bao prefers to list the device names in alphabetic order. Sort the Devices table in ascending order by Device Name. How to do this in excel

1 answer

To sort the Devices table in ascending order by Device Name in Excel, follow these steps:

1. Select the entire Devices table.

2. Go to the "Data" tab in the Excel ribbon.

3. Click on the "Sort A to Z" button in the "Sort & Filter" group.

4. In the Sort Warning dialog box, select "Expand the selection" if the table includes headers or "Continue with the current selection" if it does not.

5. Click on the "Sort" button.

The Devices table will now be sorted in ascending order by Device Name.