Forum home » Delegate support and help forum » Microsoft Excel Training and help » advanced excel course london - Excel formatting/Formular
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
advanced excel course london - Excel formatting/Formular
Resolved · Low Priority · Version Standard
Reply Wed 1 Aug 2007, 12:57Delegate Kasumi said...
Kasumi has attended:
Powerpoint Introduction course
Powerpoint Intermediate Advanced course
Excel Introduction course
Excel Intermediate course
Excel formatting/Formular
How can I sort large data by heading?
For upcoming training course dates see: Pricing & availability
RE: Excel formatting/Formular
Hi Kasumi
Thank you for your question.
Before you do this, it is a good idea to make sure your headings are formatted in bold so that Excel can tell that they are the headings and not part of the data to be sorted.
Select any cell (with data in it) under the heading that you wish to sort by, then you can use the Sort Ascending or Sort Descending buttons (they have A and Z on them) to sort in either ascending or descending order.
Amanda
|