Change the order of an Excel 365 Data Table

Question

How can I change the order of an Excel 365 Data Table please?

Answer 1

Hello, Bob Turner

Welcome to Microsoft Community.

To change the order of a Data Table in Excel 365, you can sort the data based on one of the columns. Here’s how you can do it:

1. Click anywhere within the Data Table.
2. Navigate to the “Data” tab on the Ribbon.
3. Use the “Sort” options to reorder your data based on the values in the selected column.

Additionally, if you want to sort by more than one column, you can use the “Sort” dialog box to add levels and specify the order for each column. Here's how:

Sort data using a custom list - Microsoft Support

Sorting a Data Table will rearrange the rows based on the criteria you’ve set, so make sure this is what you want before you proceed.

Yuhao Li

Microsoft Community Technical Support

Answer 2

Thanks Yuhao Li,

When I do as you advise and navigate to the Data tab, all of The Sort & Filter Options are Greyed Out, see below:

I am trying to move the DPI row to the bottom.

Answer 3

Is the worksheet protected to prevent changes?

To check if protected, on the Home ribbon, select Format and if there is an option to Unprotect then the worksheet is protected. To unprotect, if a password has been applied then you will need to know the password.

Answer 4

OssieMac,

Thanks but no protection has been applied.

Answer 5

OssieMac,

Thanks but no protection has been applied.

I am at a loss to know what has occurred. In your screen shots, most of the ribbon, excepting Format, is greyed out (disabled) and that is why I assumed that the sheet is probably protected.