Is there an easy way to swap the contents of two cells in Excel?

I think the subject says it all...

=?Utf-8?B?Ti5CLiBZb25k?= <N.B. Yond@discussions.microsoft.com> wrote in
news:4C32CCD5-DA6F-43A8-9502-B2348D183371@microsoft.com:

> I think the subject says it all...
>

You could add a button to the sheet with following code behind it:

Private Sub CommandButton1_Click()
cel1 = InputBox("First cell?")
cel2 = InputBox("Second cell?")
c1 = Range(cel1).Value
c2 = Range(cel2).Value
Range(cel1).Value = c2
Range(cel2).Value = c1
End Sub

You will be asked for the 2 cell addresses and the contents will be
swapped.

manually???

Edit|copy one cell
select a helper cell and edit|paste special|values

edit|copy the second cell
select the first cell
edit|paste special|values

select the helper cell
edit|copy
select the second cell
edit|paste special|Values

clean up that helper cell.

N.B. Yond wrote:
>
> I think the subject says it all...

--

Dave Peterson

N. B.,

You'd like to select the two cells, click the Swap Button, and presto,
they're swapped. Unfortunately, there ain't such a button.

A macro could do it.. Then there could be a swap button. Or a keyboard
shortcut. Or a menu item. If you're interested, post back. We'll write it
for you. What do you want to do with formatting? Leave in the original
locations? Or swap that too? What? Should formula cell references to
these cells get swapped, or remain with the original locations?
--
Earl Kiosterud
www.smokeylake.com

"N.B. Yond" <N.B. Yond@discussions.microsoft.com> wrote in message
news:4C32CCD5-DA6F-43A8-9502-B2348D183371@microsoft.com...
>I think the subject says it all...

Select cell'A', Cut.
Drag cell 'B' to cell 'A', click OK to replace content.
Click cell 'B', Paste.

HTH |:>)


On 7/23/05 8:07 AM, in article
4C32CCD5-DA6F-43A8-9502-B2348D183371@microsoft.com, "N.B. Yond" <N.B.
Yond@discussions.microsoft.com> wrote:

> I think the subject says it all...

I'm missing something; when I replace A in step 2, the clipboard becomes
empty so step 3 is not possible.

"CyberTaz" wrote:

> Select cell'A', Cut.
> Drag cell 'B' to cell 'A', click OK to replace content.
> Click cell 'B', Paste.
>
> HTH |:>)
>
>
> On 7/23/05 8:07 AM, in article
> 4C32CCD5-DA6F-43A8-9502-B2348D183371@microsoft.com, "N.B. Yond" <N.B.
> Yond@discussions.microsoft.com> wrote:
>
> > I think the subject says it all...
>
>