View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default Sorting multiple colums ???

Hi,
if excel 2007
select the whole range, then go to sort, sort by column A, Add Level and
there choose the second column you want to sort, add level ...

if this helps please click yes, thanks

"Drew Leyda" wrote:

I have a 5 column worksheet.
I want to sort the first column A to Z
Then, without changing the first column, I want to sort the second column
A to Z.
I have read the Help page but I can not seem to "select" the columns.
Help ......
TIA
Drew