Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 1
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   Report Post  
Posted to microsoft.public.excel.setup
external usenet poster
 
Posts: 22,906
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   Report Post  
Posted to microsoft.public.excel.setup
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I place items in alphabetical order in a column and keep da Angela33 Excel Worksheet Functions 7 March 16th 07 08:54 PM
in order of columns ceemo Excel Discussion (Misc queries) 1 April 19th 06 10:20 PM
Alphabetical columns faustrocket New Users to Excel 3 October 7th 05 12:43 AM
Regarding Sorting Columns Ben Excel Discussion (Misc queries) 2 April 4th 05 08:05 PM
how do i arrange column A (last name) in alphabetical order? t. hershy Excel Discussion (Misc queries) 2 November 28th 04 11:23 PM


All times are GMT +1. The time now is 06:36 PM.

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

About Us

"It's about Microsoft Excel"