Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 20-07-2009
Member
 
Join Date: Apr 2008
Posts: 10
How to sort column in alphabetical order?

Hi,

I am a newbie here.
I am working with Ms excel for the first time & I have stored all my Contacts with Phone numbers, Mobile numbers, addresses & email ids in the excel sheet.
But the problem is that I want to make the column to show the contacts alphabetically. I mean to sort the column in alphabetical order?
I know it can be done in excel but don't know how?
Reply With Quote
  #2  
Old 20-07-2009
Member
 
Join Date: Apr 2008
Posts: 46
Re: How to sort column in alphabetical order?

Sort data in Excel spreadsheet

1. To apply a sort in Excel, highlight the data that you wish to sort.
2. Under the Data menu, select Sort.
3. When the Sort window appears, select the columns that you wish to sort by.
4. Click on the OK button.
5. Now when you return to the spreadsheet, the data should be sorted.
Reply With Quote
  #3  
Old 20-07-2009
Member
 
Join Date: Apr 2008
Posts: 61
Re: How to sort column in alphabetical order?

Hello friend,

I have been using this web tutorial for myself & I found it very nice & up to the point. I would like you to have a look at it.
http://office.tizag.com/excelTutorial/excelsorting.php

I hope this helps.
Reply With Quote
  #4  
Old 20-07-2009
Member
 
Join Date: May 2008
Posts: 21
Re: How to sort column in alphabetical order?

Hey I have a same question but I want to do it through VBA project for the excel spreadsheet.
Is there any guide or tutorial for Macro?
Reply With Quote
  #5  
Old 21-07-2009
Member
 
Join Date: May 2008
Posts: 56
Re: How to sort column in alphabetical order?

Try Manual sort order.
Vba code to sort manually you need to set the position properly for PivotItem.
Always set error checking.

Code:
On Error Resume Next
PT.PivotFields("Region").PivotItems("South").Position = 1
On Error GoTo 0
I hope this helps you.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to sort column in alphabetical order?"
Thread Thread Starter Forum Replies Last Post
Some songs are listed in reveres alphabetical order in SanDisk sansa fuze DamarisK Portable Devices 6 23-07-2011 10:27 PM
Sort a row or column in MS Excel Itronix Tips & Tweaks 1 15-06-2011 09:52 AM
Alphabetical Sort Order is not really an Alphabetical on Windows 7 Chesnokov Operating Systems 4 18-08-2010 04:12 AM
How to place list in alphabetical order in ms word? Yudhajit Windows Software 2 05-05-2009 07:21 PM


All times are GMT +5.5. The time now is 06:25 AM.