How to move a row using mouse but not overwrite other row?

[Oneswolf]

Stupid Excel question:

How do I move a row after selecting it with the mouse without overwriting an
existing row. In other words, I want to rearrange row ordering using the
mouse and not have to cut and insert, etc.

[Dave Peterson]

Hold the shift key when you click and drag your selection.

Oneswolf wrote:
>
> Stupid Excel question:
>
> How do I move a row after selecting it with the mouse without overwriting an
> existing row. In other words, I want to rearrange row ordering using the
> mouse and not have to cut and insert, etc.

--

Dave Peterson

[Oneswolf]

Thanks! Thought I had tried all the key combos. Missed that one!

"Dave Peterson" wrote:

> Hold the shift key when you click and drag your selection.
>
> Oneswolf wrote:
> >
> > Stupid Excel question:
> >
> > How do I move a row after selecting it with the mouse without overwriting an
> > existing row. In other words, I want to rearrange row ordering using the
> > mouse and not have to cut and insert, etc.
>
> --
>
> Dave Peterson
>