Using Basic Sorting in Excel

October 16, 2012 Excel  No comments

Want to sort your data alphabetically? There are a couple of key facts you need to know about sorting in order to make sure your data doesn’t get skewed when you sort by certain criteria. Take a look at this quick tutorial about basic sorting in MS Excel, and make sure your data is correct. If you have any questions, as always, feel free to email us at questions@pbttinfo.com.
* * * * *


1. Most people use the “Sort & Filter” button under the “Home” tab – here’s how it works. Click on the cell in the column by which you want to sort your data, and then click on the Sort & Filter option at the top right of your screen:

 

 

 

 

 

 

 

2. Now, choose the kind of sort you prefer; here, we’re going to click on “Sort A to Z”.

 

 

 

 

 

 

 

3. Now the data has been sorted by “Dept”, or column C, and the data entries (rows) have remained cohesive.

 

 

 

 

 

 

 

If you have any question or suggestion, feel free to comment or email us at questions@pbttinfo.com

See you soon for the next trick!

Jess – Desktop Training Academy

Leave a reply

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>