A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Setting up and Configuration
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Re-organise columns so they appear in alphabetical order?



 
 
Thread Tools Display Modes
  #1  
Old August 1st, 2006, 10:48 AM posted to microsoft.public.excel.setup
alicat
external usenet poster
 
Posts: 2
Default Re-organise columns so they appear in alphabetical order?

Does anyone know how to re-organise columns in Excel so that they appear in
alphabetical order from left to right
  #2  
Old August 1st, 2006, 05:37 PM posted to microsoft.public.excel.setup
Gord Dibben
external usenet poster
 
Posts: 20,252
Default Re-organise columns so they appear in alphabetical order?

Select columns then DataSortOptionsLeft to Right


Gord Dibben MS Excel MVP

On Tue, 1 Aug 2006 02:48:01 -0700, alicat
wrote:

Does anyone know how to re-organise columns in Excel so that they appear in
alphabetical order from left to right


  #3  
Old August 2nd, 2006, 05:47 AM posted to microsoft.public.excel.setup
Anthony Caton
external usenet poster
 
Posts: 1
Default Re-organise columns so they appear in alphabetical order?

"alicat" wrote:

Does anyone know how to re-organise columns in Excel so that they appear in
alphabetical order from left to right


In the Data menu choose Sort
In the Sort dialog box choose Options
Select the Left to Right radio button
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Add New Field to DB Karen Database Design 7 October 19th, 2005 08:03 PM
sort rows in alphabetical order and move the corresponding data lianeanddave Worksheet Functions 3 August 26th, 2005 04:43 PM
The months in a query appearin alphabetical order. FC Running & Setting Up Queries 10 June 14th, 2005 04:19 PM
How do I sort each category in alphabetical order with first name. Peter General Discussion 0 April 25th, 2005 04:04 PM
HOW TO: NUMBERED LIST BUT KEEP ENTRIES IN ALPHABETICAL ORDER riverdog007 New Users 1 April 15th, 2005 03:22 AM


All times are GMT +1. The time now is 05:19 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.