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

sorting

ResolvedVersion 2003

Joanne has attended:
Excel Intermediate course

Sorting

Sequence of sorting with more than 3 criteria...

RE: Sorting

Hello Joanne

Thank you for your question and welcome to the forum.

OK, so here's what you need to do. Say you are sorting by 4 columns:

1. First, select a cell in the database.
2. Go to Data-Sort.
3. In the first Sort by box, select the column that you wish to sort by last (after all the others). Click OK.
4. Go to Data-Sort again.
5. In the Sort by and Then by boxes, select the other three columns you want to sort by, starting with the most important first. Click OK.

I hope this helps.

Kind regards
Amanda

Tue 25 Aug 2009: Automatically marked as resolved.

Excel tip:

Screen Splitters in Excel

Screen splitter icons can be set from the ribbon bar, or dragged from the scroll bars. The icon just above the up arrow on the right scroll bar controls the horizontal splitter; the icon to the right of the right arrow on the bottom scroll bar controls the vertical splitter.

These icons can be double-clicked to split the screen at the top left of the cell currently in use.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.