excel 2003 visual basic intermediate course - sort function

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

TrustPilot

starstarstarstarstar Excellent

  • Home
  • Courses
  • Promotions
  • Schedule
  • Formats
  • Our Clients

Forum home » Delegate support and help forum » Microsoft Excel Training and help » excel 2003 visual basic intermediate course - Sort function

excel 2003 visual basic intermediate course - Sort function

resolvedResolved · Low Priority · Version Standard

Sylvain has attended:
Excel Advanced course
Upgrade to Office 2010 course

Sort function

How do i sort multiple columns in 2007?

RE: Sort function

Hi Sylvain

Thank you for your question.

To sort by multiple columns in Excel 2007:

1. Select a cell in the data area that you want to sort, or select the data range you wish to sort.
2. Select the Data tab at the top of the screen, then click the Sort button.
3. In the Sort by box, select the name/heading of the first column you wish to sort by, and what order to sort in.
4. If necessary, click the Add Level button to introduce another row, and repear step 3.
5. Continue repeating steps 3 and 4 until you have finished selecting all the columns you want to sort by; and click OK.

I hope this helps.
Amanda


 

Excel tip:

No Zeros

Want all the zeros in your worksheet to appear blank? Choose Tools/Options, Click on the View Tab, Deselect the Zero Values Option, Click OK.
Easy wasn't it? But be aware that these cells are not actually blank, they still contain the value zero. This is important because certain functions (ie AVERAGE) make a distinction between blank cells and those with a zero value.

View all Excel hints and tips


Server loaded in 0.08 secs.