How do you rearrange columns in a list in Excel?

[daleremote]

I know how to rearrange regular columns in Excel. What I need to do is
rearrange columns in a "list", which is what Excel calls a specially
formatted group of cells that have sorting options. I use the List
Wizard to make the list, and can add or delete columns, but can't
figure out how to rearrange them. I'm wondering if it's even possible.
Thanks.

 

[CyberTaz]

There is no "rearrange columns" command Insert the new column within the
list, select & cut the column to be repositioned, then paste to the top cell
in the new column of the list. IOW, the only difference with a list is that
you have to work within the list range.

Alternatively you can turn the List Manager off, reconstruct the sheet, then
reapply the List Manager.

HTH |:>)
Bob Jones
[MVP] Office:Mac

 

[daleremote]

There is no "rearrange columns" command Insert the new column within the
list, select & cut the column to be repositioned, then paste to the top cell
in the new column of the list. IOW, the only difference with a list is that
you have to work within the list range.

Alternatively you can turn the List Manager off, reconstruct the sheet, then
reapply the List Manager.

HTH |:>)
Bob Jones
[MVP] Office:Mac

Thanks. I was guessing it was a manual process but wasn't sure...