excel programming vba - sorting

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 programming vba - Sorting

excel programming vba - Sorting

resolvedResolved · Low Priority · Version Standard

Sean has attended:
Excel Advanced course

Sorting

How do you sort data?

RE: sorting

Sean

Simply select the data you want to sort, then click the A-Z or Z-A button on the toolbar.

You can also access more detailed options under the Menu bar by clicking DATA, then SORT.

Richard


 

Excel tip:

View a unique list

You have a column with hundreds of entries, and you need to see what unique items are entered in it. Select any cell in that column, hold down Alt and press the down arrow: Excel produces an alphabetically-sorted list of unique entries in that column.

View all Excel hints and tips


Server loaded in 0.1 secs.