How do you rearrange columns in a list in Excel?

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



On 1/1/09 10:52 PM, in article
93c611ac-baa5-4ae1-b697-9e14ffa748af.TakeThisOut@41g2000yqf.googlegroups.com,
"daleremote@gmail.com" <daleremote.TakeThisOut@gmail.com> wrote:

> 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.