sort

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

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

Sort

resolvedResolved · Medium Priority · Version 2003

Lennon has attended:
Excel Intermediate course
Excel Advanced course
Access Introduction course

Sort

I have 3 options for sorting out my excel sheet but would like to sort it using 4 or 5 citeria. Is it possible to add more sort options?

RE: Sort

Hi Lennon

Thanks for your question.

It is possible to sort by more than 3 criteria, you would need to do two separate sorts to sort by 4 or 5 criteria.

For more information, please see the following article from the Microsoft Knowledgebase:
http://support.microsoft.com/kb/268007

Kind regards
Amanda

Wed 3 Dec 2008: Automatically marked as resolved.


 

Excel tip:

Ctrl+d's double life

Suppose I have a formula in B1 that I wish to copy into B2:B10. I can select B1:B10 then press Ctrl+d to copy the formula down the selected range. Users generally ignore this shortcut in favour of double-clicking on the fill handle to copy down, but Ctrl+d is useful sometimes particularly when there is no data in surrounding columns to guide to how far the double-click method should copy formulae.

Ctrl+d has another use though. When I use the drawing toolbar to draw objects such as Text Boxes, Rectangles and Ovals onto a worksheet, Ctrl+d makes an instant duplicate of selected shapes. For example, I need five Text Boxes the same size. I draw one Text box and adjust it to the size I want, select it, then press Ctrl+d four times to get four identical copies.

View all Excel hints and tips


Server loaded in 0.08 secs.