Sitemap

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 » Excel

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

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

Training information:

Excel

Resolved · Low Priority · Version 2003

ReplyWed 24 Jun 2009, 14:07Delegate Nicola said...

Excel

How do I sort data alphabetically?

For upcoming training course dates see: Pricing & availability

ReplyWed 24 Jun 2009, 15:34Trainer Simon said...

RE: Excel

Hi Nicola,

Thank you for your question.

Click into one of the data cells underneath the heading you want the excel list sorted by.

E.g. If you want sort the data by County, click in any cell containing a county and go to the Data menu and then Sort.

Ensure that the County field is selected from the options available in the Sort By box.

I hope this answers your question.

Regards

Simon

Wed 1 Jul 2009: Automatically marked as resolved.

Excel articles

· How To Create An Excel 2010 Chart To Show Both A Number And A Percent Data Series
· How Excel Can Help You See Into Your Business's Future
· Microsoft Excel Training: Essential for Today's Employees
· Features of Microsoft Excel that assist in Analysis of Financial Data
· Understanding XML Within Excel

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

Excel tip:

Entering text in Multiple Worksheets

If you have a number of worksheets in a workbook that require the same information (data or tables) on each worksheet, this can be done as follows:

Hold down the Ctrl key and click one or more of the additional worksheet tabs (i.e. Sheet2, Sheet3, etc).

In your mainsheet (Sheet1) enter the required data or design a table.

When done 'Click' on the other sheet tabs and you will see that the information entered in Sheet1 is on all the other selected worksheets.

NB Do not forget to deselect the worksheets - otherwise you may add data to the main worksheet and all the selected worksheets will also have that data!

View all Excel hints and tips

How do I group categories in a column chart?

» Forum post: How do I group categories in a column chart

Rate this page:

Currently 2.16/5
1
2
3
4
5

2.2/5 (211 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions