Excel is a wonderfully handy tool – It gives you the opportunity to do all kinds of things to your data (processing, sorting, conditional formatting, formula applications, etc.) and you can even graph everything in an easy-to-read manner if you’d like. But, unless you’re already familiar with it or a similar alternative, it can be a lot to grasp the hang of at first.
By default, your data will be sorted in rows with the program. That might work for some, or even most, of your projects but what if you want to sort your data into rows instead? It’s easier than you might think, and this guide will walk you through the whole process, start to finish.
Let’s get started, shall we?
Sorting Your Excel Data In Rows Instead Of Columns
First, open a new file and insert or import your data however you want; for rows, your options are numerical or alphabetical value. Once everything has been inserted into its place, find the data tab on the ribbon (near the top) and click on the sort button. This will bring up a new window that will have numerous tabs at the top; what you’re looking for is the ‘Options’ button on the far-right.
This is the window that gives you the opportunity to choose how you’d like to sort everything out. Since, for the purpose of this post, we’re sorting in rows, you’ll want to click on ‘Sort left to right’. Once you’re done that, click on ‘OK’ and you’ll be brought back to the previous window once more.
There, you’ll be shown three columns – Row, sort on, and order – with dropdown menus. Click on ‘Row’ and choose which row you’d like to sort your data in; you can choose to sort by cell color, font color, cell icon, or value.
Once you’re happy with your selections, click on ‘OK’ once more and your data will be sorted to your specifications immediately.
Please note that this sorting method will not change the default Excel sorting criteria. That means that you’re going to have to go through this whole process any time you want to sort data in rows. You should also keep in mind that this doesn’t work with the Filter feature either since you can only apply filters to columns.
Applying A Filter To Excel Rows – A Trick
Filters are super handy because they give you the opportunity to alter them and/or sort your data quickly and easily whenever you need to. If you’d like to apply a filter to a row instead of a column, you’ll have to use the transpose feature to turn your rows into columns and go from there. While it would be nice if there were a way around this, unfortunately, there’s not.
How do you usually sort your data and what program(s) do you usually use to sort it? Let us know in the comments section below.