excel

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

Excel

resolvedResolved · Low Priority · Version 2003

Julia has attended:
Excel Intermediate course

Excel

How do I make my list on Excel alphabetical

RE: Excel

Hi Julia,

Thank you for your post and welcome to the forum:

In answer to your question: Sorting is one of the main functions that we can perform in a List (Database) in Excel, If you have set up your list to conform to the required rules, Heading, no gaps row or column etc. Then select the Field (Column) you wish to sort by, and from the Standard Toolbar click the Sort Ascending A-Z or Sort Descending Z-A buttons to perform your Sort.

I hope that has helped, regards Pete
.


 

Excel tip:

Editing Formulas in Excel Cells

Although people like to edit a formula in the Formula bar, you can also edit a formula in the cell.

To do this select the cell and press "F2". This puts Excel into Edit mode, and you can move around in the cell and make any necessary changes.

Double-clicking the cell also puts Excel in Edit mode.

View all Excel hints and tips


Server loaded in 0.1 secs.