ExcelBanter - Columns

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Columns (https://www.excelbanter.com/excel-worksheet-functions/146772-columns.html)

albericht

Columns

Can columns be sorted alphabetically? If so, how?

Vasant Nanavati

Columns

Columns cannot be sorted natively in Excel.
__________________________________________________ ____________________

"albericht" wrote in message
...
Can columns be sorted alphabetically? If so, how?

FSt1

Columns

hi,
yes.
on the menu.... click datasort
when the sort dialog box pops up, click options. at the bottom click sort
left to right.
as a regular sort keys on columns, the sort left to right keys on rows.

regards
FSt1

"albericht" wrote:

Can columns be sorted alphabetically? If so, how?

Stan Brown

Columns

Sat, 16 Jun 2007 18:15:00 -0700 from albericht
:
Can columns be sorted alphabetically? If so, how?

Highlight the range of interest, and click Data | Sort.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

All times are GMT +1. The time now is 07:02 PM.