Hints and tips home » Excel hints and tips » Sorting data stored in rows

Sorting data stored in rows

Primarily Excel is set up to sort data that is stored in columns rather than rows.

It is possible to get Excel to sort data stored in rows however.

Click in the row you want to sort, or select the cells in the rows you wish to sort.

Go to Data - Sort, then go to the Options button in the bottom left corner of the Sort dialogue box.

Added by Amanda on 24th November 2006

More Excel hints and tips, like:

• ##### displaying in Excel
• Create a unique items table from a duplicating table
• Finding cells that have data restrictions