Sorting ( what happened)

[Crimson]

Excel 2003
Windows XP

I was sorting a list that read:
Store Item Price

I'm not sure what I did but when I look back it was in this order:

Price Item Store

Now I cannot get the "Store" column back without physically moving it.

 

[Ron Coderre]

It sounds like you selecte "Sort left to right" in the sort options.

Try this:

Insert a blank row just above your data list.
Enter sequence numbers (the way they SHOULD be) above each column heading.
(Example: if the Price column should be 3rd....put a 3 above it.)

Select the data list (including the seq numbers above)

THEN
From the Excel main menu:
<data><sort>
Click the [Options] button
Check: Sort left to right
Click the [OK] button
Click the [OK] button (again, to sort)

That should sort the columns based on the seq numbers you entered and put
your columns back in the correct order.

(if NO....undo and try again)

Does that help?
***********
Regards,
Ron

XL2002, WinXP

 

[SteveW]

left to right wouldn't give you "Price, Item, Store"

It sounds like you selecte "Sort left to right" in the sort options.

Try this:

Insert a blank row just above your data list.
Enter sequence numbers (the way they SHOULD be) above each column
heading.
(Example: if the Price column should be 3rd....put a 3 above it.)

Select the data list (including the seq numbers above)

THEN
From the Excel main menu:
<data><sort>
Click the [Options] button
Check: Sort left to right
Click the [OK] button
Click the [OK] button (again, to sort)

That should sort the columns based on the seq numbers you entered and put
your columns back in the correct order.

(if NO....undo and try again)

Does that help?
***********
Regards,
Ron

XL2002, WinXP

Excel 2003
Windows XP

I was sorting a list that read:
Store Item Price

I'm not sure what I did but when I look back it was in this order:

Price Item Store

Now I cannot get the "Store" column back without physically moving it..