move column in 2004

[[email protected]]

It used to be you'd just grab the colum and move it. Now all it seems
I can do is select the column and then do all kinds of machinations to
get it to move. How do I just put, column A right after column B
without deleting or adding any columns (I know, of course, that column
B will then become "Column A" and so on.
Also: is there any way of sorting column headers alphabetically after
they have been entered?

[Bernie Deitrick]

Select column A, then move your pointer onto the black border around column
A. When it turns into a 4 pointer arrow cursor, hold down the Shift key and
click and drag it to the right. When it is between columns B and C, and the
'chadow' column is show between them, let go of your mouse button.

HTH,
Bernie
MS Excel MVP

<[email protected]> wrote in message
news:[email protected]...
> It used to be you'd just grab the colum and move it. Now all it seems
> I can do is select the column and then do all kinds of machinations to
> get it to move. How do I just put, column A right after column B
> without deleting or adding any columns (I know, of course, that column
> B will then become "Column A" and so on.
> Also: is there any way of sorting column headers alphabetically after
> they have been entered?
>

[Gord Dibben]

Bernie has looked after the move column.

To sort headers........assuming headers are in row 1 select that row and
Data>Sort>Options> "sort left to right".


Gord Dibben Excel MVP

On Fri, 4 Feb 2005 14:00:18 -0500, "Bernie Deitrick" <deitbe @ consumer dot
org> wrote:

>Select column A, then move your pointer onto the black border around column
>A. When it turns into a 4 pointer arrow cursor, hold down the Shift key and
>click and drag it to the right. When it is between columns B and C, and the
>'chadow' column is show between them, let go of your mouse button.
>
>HTH,
>Bernie
>MS Excel MVP
>
><[email protected]> wrote in message
>news:[email protected]...
>> It used to be you'd just grab the colum and move it. Now all it seems
>> I can do is select the column and then do all kinds of machinations to
>> get it to move. How do I just put, column A right after column B
>> without deleting or adding any columns (I know, of course, that column
>> B will then become "Column A" and so on.
>> Also: is there any way of sorting column headers alphabetically after
>> they have been entered?
>>
>

[Ken Wright]

Or when you see that 4 pointed arrow, you can Right Click on it and hold it
down, drag it to where you want, let go of the button and choose from one of
the options that will appear.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Bernie Deitrick" <deitbe @ consumer dot org> wrote in message
news:[email protected]...
> Select column A, then move your pointer onto the black border around
column
> A. When it turns into a 4 pointer arrow cursor, hold down the Shift key
and
> click and drag it to the right. When it is between columns B and C, and
the
> 'chadow' column is show between them, let go of your mouse button.
>
> HTH,
> Bernie
> MS Excel MVP
>
> <[email protected]> wrote in message
> news:[email protected]...
> > It used to be you'd just grab the colum and move it. Now all it seems
> > I can do is select the column and then do all kinds of machinations to
> > get it to move. How do I just put, column A right after column B
> > without deleting or adding any columns (I know, of course, that column
> > B will then become "Column A" and so on.
> > Also: is there any way of sorting column headers alphabetically after
> > they have been entered?
> >
>
>

[Laurie Pepper]

Thanks all! Very much. Ken, I like the the quote.

[Ken Wright]

:-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Laurie Pepper" <[email protected]> wrote in message
news:[email protected]...
> Thanks all! Very much. Ken, I like the the quote.
>