Quick Links ▼

Bookmark page

Printable version

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Sorting

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Sorting

Resolved · Low Priority · Version 2007

Reply Mon 8 Dec 2008, 15:57Delegate Dagmar said...

Dagmar has attended:
Excel Introduction course
Excel Intermediate course

Sorting

how do you sort a table of data by one of its columns? eg names

For upcoming training course dates see: Pricing & availability

Reply Tue 9 Dec 2008, 10:17Trainer Pete said...

RE: sorting

Hi Dagmar,
Thank you for your question;
In answer; If your table is laid out with each column having a field header, and relevant data below the header, you should format the header slightly differently from the data below (ie bold is sufficient) then click in the column you wish to sort, in your case Names and on the standard toolbar click one of the sort buttons (sort ascending or sort descending). If you table is constructed correctly with no gaps between headings and data it will sort the column and maintain data in the rows correctly. I hope that has helped ...Pete

Mon 15 Dec 2008: Automatically marked as resolved.

Excel articles

· Excel and Inventory Management
· Benefits of learning about Excel charts
· Trust Excel To Protect Your Data
· What You Need To Know About LOOKUP Functions In Excel 2007/2010
· Reasons Why VBA for Excel Training Fails

Please browse our web site to find out more about
course excel training vba london and other Microsoft training courses.

Excel tip:

Filtering Data in an Excel 2010 Worksheet

When you have an Excel Worksheet with masses of data, it's not going to be easy to sift through it. So, in order to view sections of data, you can use the filter tool. Select the cells you want to filter (no need to select the column headers), then click the Home tab on the Ribbon, click Sort and Filter (you will find this in the Editing Section) then click Filter.

You will now see arrows in the top row of all the columns. If you click on an arrow, it will give you some filtering options so you can sort your data into ''Smallest to Largest'' or ''Oldest to Newest'' and so on..

To turn off the filtering, go back to the Home tab and click the Filter button again.

View all Excel hints and tips