Ask Your Question
0

Sort text column including 1st cell

asked 2015-06-25 14:18:07 +0200

colion gravatar image

updated 2015-06-25 14:19:18 +0200

If I sort a column of numbers all is well but not when I have a column of text.

I have a column of text that looks like this (note I type a column of text below but it displays as a line of text???)

ZZZ DDD BBB

If I choose Data > Sort > Ascending the column is sorted EXCEPT that the first cell is not included and remains unchanged, resulting in:

ZZZ BBB DDD

How can I force the first cell to be included in the sort?

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2015-06-25 14:29:17 +0200

karolus gravatar image

Uncheck Option: []Range contains Columnlabels

edit flag offensive delete link more
0

answered 2015-06-25 14:41:07 +0200

colion gravatar image

Thanks. That did it.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2015-06-25 14:18:07 +0200

Seen: 230 times

Last updated: Jun 25 '15