To sort data in Excel, there are some rules that you should follow.

Do not select

Although it will work to sort a column after selecting it, it’s absolutely unnecessary. In fact, it was so in the past that it destroyed the table – because Excel only sorted the column that was selected. Today, Excel warns you if you try to sort after selecting one column in a table.

Select a cell in the column

All you have to do is to stay in the column. Press the sort button and the entire table will be sorted by that column.


Standing in the column will only sort a column without empty cells. If you want to sort only one column and sometimes it’s empty cells – well yes, then it is actually correct to select all the data.

Read more about the definition of a table in Excel here.