I have four columns on my sheet but I only want to sort one of them. When I
clicked that column's header to sort it but the "sort warning" pops up,
saying that there's data next to my selection. I tried to "continue with the
current selection," but everything turns into zero in that column!

Please help! It'll be greatly appreciated!

You must first highlight ALL the data in your spreadsheet before you begin to
sort. Then when you sort the one column all the relating data will be sorted
with it.

"Googi" wrote:

I have four columns on my sheet but I only want to sort one of them. When I
clicked that column's header to sort it but the "sort warning" pops up,
saying that there's data next to my selection. I tried to "continue with the
current selection," but everything turns into zero in that column!

Please help! It'll be greatly appreciated!

I don't know why everything turned to zero, but here's a way to avoid
it. Suppose it is column B that you want to sort. Insert a new column
B (so that your sort column is now C) and a new column D, so that your
sort column now has two blank columns either side of it. Then do your
sort, and finally delete the two columns you added.

Hope this helps.

Pete


On Mar 13, 7:58*am, Googi wrote:
I have four columns on my sheet but I only want to sort one of them. When I
clicked that column's header to sort it but the "sort warning" pops up,
saying that there's data next to my selection. I tried to "continue with the
current selection," but everything turns into zero in that column!

Please help! It'll be greatly appreciated!