ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can you drag/drop rows w/o using Cut/Paste (https://www.excelbanter.com/excel-discussion-misc-queries/17200-can-you-drag-drop-rows-w-o-using-cut-paste.html)

spp

Can you drag/drop rows w/o using Cut/Paste
 
Can you drag/drop rows (or columns) in Excel without using the Cut/Paste
keystrokes. What I would like to do is be able to highlight a row, click the
Ctrl button, and then drop it on another row where it would be moved to?


Dave Peterson

If you select the row and click on the border and drag it, you'll move it.

Experiment a little.

try selecting and dragging.
try selecting and dragging while holding the shift key
try selecting and dragging while holding the ctrl key

Heck, select a cell and rightclick and drag it where you want. When you let go,
you'll see lots of options.


spp wrote:

Can you drag/drop rows (or columns) in Excel without using the Cut/Paste
keystrokes. What I would like to do is be able to highlight a row, click the
Ctrl button, and then drop it on another row where it would be moved to?


--

Dave Peterson


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

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