[libreoffice-users] Re: Calc: Sort By Column Names?

Rich Shepard wrote:
> I have a large spreadsheet with column titles in row 1, and I need to sort
> the columns alphabetically by their titles. It appears that the sort
> function (as in all the spreadsheets I've used in the past) will sort by
> rows in a specified column, but I need to sort columns by a specified row.
>
>    Possible? If so, please point me to instructions.

Yes, it is possible but not very intuitive :)

Select the block to be sorted, click on Data, Sort, click on the Options tab
and uncheck the "Range contains column labels" option, click on the last
radio button " Left to right (sort columns)".
Click on the Sort Criteria tab, make sure that Row 1 is showing the Sort by
box and press OK.

Worked for me :)

--
View this message in context: 
http://nabble.documentfoundation.org/Calc-Sort-By-Column-Names-tp3495112p3495199.html
Sent from the Users mailing list archive at Nabble.com.

-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted