Select all columns in your range to sort.

Then DataSort on the column of vendors.


Gord Dibben MS Excel MVP

On Fri, 22 Aug 2008 11:38:01 -0700, jasonprouse
wrote:

I want to be able to add an option of adjusting a spreadsheet in Excel 2003by
clicking on an arrow at the top of each column that will change the entire
sheet to fit the requested order of that specific column. For example: i have
a column in my spreadsheet that contains 5 different vendors; I have 75 rows
in this column. I want to be able to add an arrow box at the top of the
column to arrange the entire spreadsheet according to the alphabetical order
of this one column