How to sort data quickly in Microsoft Excel

Newsletter Subscription:

Removing McAfee Agent from your machine
Recently had a job where I had to remove McAfee from 40 machines in order to replace them with F-Secure PSB. Removing the McAfee AV was not a problem ...
Amazon Phishing Scam Alert
A new phishing scam is being reported in the media and this time it's emails that are made to look like they come from Amazon. According to Moneywi...
Installing Microsoft Office 365 Desktop Apps Configurator
I recently came across a problem when trying to install the Office 365 desktop apps configurator. The machine in question was a Windows Vista Home Pre...
axon IT takes Federation of Irish Societies into the Cloud
axon IT has provided a cloud computing solution to the Federation of Irish Societies (FIS) – the national representative body for the Irish in B...
Migrate Small Business Server 2003 to Windows 2008 Standard
Network administrators might consider migrating from a Small Business Server 2003 environment for number reasons. These include, reaching the SBS 2003...

How to sort data quickly in Microsoft Excel

Posted by Richard on Wednesday, November 5th, 2008

Sorting data in Microsoft Excel is simple. There are several ways of sorting data so we’ve put together this short tutorial to help you.

To sort one column in ascending/descending order. Highlight the column you’d like to sort by and press the ascending or descending button from the data menu (see the picture below).

The other option is to sort data by several rows for example, date then customer’s first name. To sort your data in this way you should highlight the data you wish to sort and press the sort button this then lets you choose your sorting preferences (see the picture below).

Alternate Row Highlighting in Microsoft Excel

Tags: excel tips, Microsoft Excel

This entry was posted on Wednesday, November 5th, 2008 at 4:01 pm and is filed under Microsoft Excel, Microsoft Office. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

How to sort data quickly in Microsoft Excel

Leave a Reply