ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to move a row using mouse but not overwrite other row? (https://www.excelbanter.com/excel-discussion-misc-queries/83143-how-move-row-using-mouse-but-not-overwrite-other-row.html)

Oneswolf

How to move a row using mouse but not overwrite other row?
 
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

How to move a row using mouse but not overwrite other row?
 
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

How to move a row using mouse but not overwrite other row?
 
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



All times are GMT +1. The time now is 09:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com