Timeline for How to easily reorder rows in excel with drag and drop or move-up or move-down?
Current License: CC BY-SA 4.0
18 events
when toggle format | what | by | license | comment | |
---|---|---|---|---|---|
Nov 4, 2022 at 19:07 | comment | added | philfreo | Wow, this does work. At first I didn't think it did because there's a very tiny spot you have to have your mouse. On a Mac, your mouse has to be (for a row) right on the line. Too far left and you'll be over the row number, too right right and you'll be over the cell. But just on the line the pointer will change into a hand. | |
Nov 15, 2019 at 7:28 | comment | added | mattboy | SHUT UP AND TAKE MY UP VOTE! | |
Oct 14, 2019 at 8:57 | comment | added | pabouk - Ukraine stay strong | Unfortunately Excel does not allow this when the row/column to be moved contains a merged cell. It does not matter if the destination place would contain the same merged cell. | |
Apr 19, 2019 at 6:42 | comment | added | satoc | As @Korayem commented above, pressing SHIFT actually defaults to overwrite-mode on my environment (Office 365 ProPlus). Left-clicking the four-way-arrow (without SHIFT) actually does the row moving without overwriting. | |
Aug 29, 2018 at 20:25 | comment | added | CindyH | kok made one awesome answer and was never seen again! Who was that masked man? | |
S Jul 18, 2018 at 18:47 | history | suggested | Patrick McElhaney | CC BY-SA 4.0 |
Put important information from a comment into the answer
|
Jul 18, 2018 at 18:23 | review | Suggested edits | |||
S Jul 18, 2018 at 18:47 | |||||
Aug 23, 2017 at 7:17 | comment | added | soneangel | In Google Spreadsheet you can easily drag and drop rows and columns just selecting them and dragging from the number/letter. | |
Jul 18, 2017 at 18:41 | comment | added | Krazy Glew | Does anyone know how to do this Google Sheets? | |
Jul 18, 2017 at 18:21 | comment | added | Krazy Glew | Does anyone know of a shortcut to get this "4-way arrow" - keyboard shortcut, or a macro / Visual Basic (or whatever the new macro language is called)? I find it really hard to do this precisely with a mouse, let alone on a touchscreen or with a pen. Ideally I would like to have a "thumb" to drag rows and columns around like this. | |
Jul 18, 2017 at 18:19 | comment | added | Krazy Glew | I have Office365 (so I think I have whatever is latest version of Excel at time of post - I can't find a proper version number anywhere). Selecting ANY group of cells (not just rows/columns), moving to border to get 4-way arrow, and dragging moves data around - leaving an empty hole behind. Dropping it warns on overwrite. Shift+dragging attempts to reorder rows or columns, but only if full row/column selected. "Full" = all of some rectangular area - not necessarily full spreadsheet. // Confusion: must hover over boundary of data cells, not the row number or column letter - that resizes. | |
Jun 30, 2015 at 21:31 | comment | added | Korayem | I have Excel 2013 and it seems the default behavior now when you move a row after seeing four-way-arrow cursor is shifting behavior. Pressing SHIFT actual replaces destination row | |
Oct 6, 2014 at 12:18 | review | Suggested edits | |||
Oct 6, 2014 at 12:44 | |||||
Jul 10, 2014 at 22:50 | review | Suggested edits | |||
Jul 10, 2014 at 22:52 | |||||
Jun 12, 2014 at 2:11 | comment | added | Scott Ritchie | On mac, for step two you want to move your mouse cursor so that you see the hand icon, not the four-way-arrow cursor. | |
S Oct 30, 2013 at 13:19 | history | suggested | Baumr | CC BY-SA 3.0 |
Formatting and ease-of-reading
|
Oct 30, 2013 at 13:01 | review | Suggested edits | |||
S Oct 30, 2013 at 13:19 | |||||
Jul 24, 2011 at 19:59 | history | answered | kok | CC BY-SA 3.0 |