ExcelBanter - Re-organise columns so they appear in alphabetical order?

ExcelBanter (https://www.excelbanter.com/)

- Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)

- - Re-organise columns so they appear in alphabetical order? (https://www.excelbanter.com/setting-up-configuration-excel/102428-re-organise-columns-so-they-appear-alphabetical-order.html)

alicat

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

Gord Dibben

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

Anthony Caton

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

All times are GMT +1. The time now is 05:04 PM.