Re: how do i exchange the contents of two columns?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jack Sadie (jacksadie_at_btinternet.com)
Date: 10/11/04 

Date: Mon, 11 Oct 2004 09:01:57 +0100

John & Gord
I've tried your suggestion and can't get it to work in the way expected. The
columns are NOT exchanged. The cursor changes in the Header cell to the
black line with 2 opposing arrows, and as the cursor is slid down to the
edge of the main column it changes to a white arrow.
I get a message which asks if I want to replace the contents of the
destination
column and giving the options "ok" or "cancel".
Cancel doesn't do anything - obviously ! - while ok does exactly what was
promised and I have "lost" the contents of the destination column as
predicted.
Still ;>(

"Gord Dibben" <gorddibbATshawDOTca> wrote in message
news:tp4jm0lasatr0ho0seffehnjr1tcnp3bba@4ax.com...
> Jack
>
> The trick is to select the column header first.
>
> Hold down the SHIFT key then slide the cursor down to the edge of the top
> cell.
>
> You will get a black "move" cross.
>
> Left-click and drag left or right then drop.
>
> Gord Dibben Excel MVP
>
> On Sun, 10 Oct 2004 20:13:48 +0100, "Jack Sadie"
> <jacksadie@btinternet.com>
> wrote:
>
>>How do you "edge-drag" please? When I tired to grab the selected column it
>>merely inserted a new column adjacent. Am I missing something or is my
>>version (excel97) too out of date? :>(
>>Jack Sadie
>>
>>"Earl Kiosterud" <nothanks@nospam.com> wrote in message
>>news:uAG8IFtrEHA.2724@TK2MSFTNGP14.phx.gbl...
>>> behzad,
>>>
>>> Select one column, move (edge-drag) it to the other side of the other
>>> column
>>> holding Shift.
>>>
>>> --
>>> Earl Kiosterud
>>> mvpearl omitthisword at verizon period net
>>> -------------------------------------------
>>>
>>> "behzad" <behzad@discussions.microsoft.com> wrote in message
>>> news:74006CF0-7041-4790-9591-D7C81D35FBDA@microsoft.com...
>>>>
>>>> --
>>>> ba
>>>
>>>
>>
>

Relevant Pages

  • Re: how do i exchange the contents of two columns?
    ... One way would be to highlight the column you're going to move, ... place the cursor over the edge of the column until it changes from a cross to ... "Jack Sadie" wrote: ... >> Earl Kiosterud ...
    (microsoft.public.excel.misc)
  • Re: mouse pointer
    ... The mothod being used "through the internet" is confusing me. ... talking about the cursor changes when you visit certain websites or ... to lock the cursor in Group Policy Editor and Google and came up with ... under the User Config-Admin Templates-Control Panel. ...
    (microsoft.public.windowsxp.hardware)
  • Re: Excel-formatting
    ... Good Morning Gord, ... I wish that I enter 145, it will be 15.5 as soon as I place the cursor out ... Right-click on the sheet tab and "View Code" ... if I enter to a cell 100, ...
    (microsoft.public.excel.misc)
  • Re: Any Other Whachamacallits Besides "Cursor:Pointer"??
    ... ignore cursor changes (just as I can tell it to ignore status-line ... exercise than anything else, why my code doesn't work (or, rather, ... little image of a dog (which is, BTW, animated but timed via ...
    (comp.infosystems.www.authoring.stylesheets)
  • Re: changing mouse cursor over certain DataGrid columns
    ... > How can I customize DataGrid so that when the mouse hovers over certain> columns the cursor changes to the Cursors.Hand cusror? ... I was unable to use> the MouseEnter/MouseLeave events on DataGrid itself because those events> do ...
    (microsoft.public.dotnet.languages.csharp)