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+h...@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