Connecting Tech Pros Worldwide Forums | Help | Site Map

Excel 2007: Sorting Rows

Member
 
Join Date: Nov 2008
Posts: 52
#1   Dec 9 '08
By default, Excel allows you to sort your data by columns. If you run into a situation that requires that you sort the rows, you could do it by hand or let Excel do it for you.


1. Highlight the data to be sorted.


2. Go to the Ribbon and select the Data tab.


3. In the Sort & Filter section, select Sort.

4. In the Sort window, click the Options button.



5. In the Orientation section, select the Sort left to right radio button.


6. Click the OK button.

7. Now use the dropdowns in the Sort window to select the desired row and how you want it sorted.

8. Click the OK button.



Stang02GT's Avatar
Moderator
 
Join Date: Jun 2007
Location: USA
Posts: 1,152
#2   Dec 10 '08

re: Excel 2007: Sorting Rows


Is there a question here or are you just explaining how to do this for people?
Nepomuk's Avatar
Moderator
 
Join Date: Aug 2007
Location: Germany
Posts: 2,466
#3   Dec 10 '08

re: Excel 2007: Sorting Rows


This is the insights section, so I'm pretty sure it's an explanation.

Greetings,
Nepomuk
Reply


Similar Microsoft Windows / Vista / XP / ME / 95 & 98 bytes