Notice how sorting method is changed on the upper left side of the window: From here on, it is very similar with sorting data vertically. Select by which row you want your data to be sorted. For our example, we will sort our table based on calories. Which

Now, open your sorting window. And, sort columns by using your temporary row as a base. After that, just delete the temporary heading now. Conclusion. It’s the biggest time saver when you have large data sets, 50-100 column. Once you sort all of them, i

When you sort horizontally, the option “My data has headers” is greyed out. Click on Sort within the Data ribbon. Click on Options in the Sort window. Select “Sort left to right” instead of “Sort top to bottom”. Select your search row. In our