View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Elkar
 
Posts: n/a
Default Sorting by Column Headers

Yes, select your columns to sort.
From the Data Menu, select Sort.
In the Sort dialog box, click the button called "Options"
You should see a toggle for "Orientation"
Change this to "Left to Right"
Click OK
You should now be able to sort by Rows instead of Columns.
Choose the Row that your headers are in.

HTH,
Elkar


"Richard" wrote:

Is it possible to sort a sheet by column headers? I tried to convert the
information into rows to sort it but there are too many rows. The information
has numerical column headers and I would like to put it in order from left to
right. Not all columns have headers, but they're not critical.