Next, press and hold the Shift key on the keyboard, move your cursor to the edge of the selection (either top or bottom). Select your row (or contiguous row) that you want to move the same you did in the above section. You can quickly move or swap a row without overwriting the existing row by holding the Shift key when dragging the selected row(s). In the below screenshot, you can see that row 11 is now replaced with row 6. Click ‘OK’ to replace row 11 with the data of row 6.īut, when you move your row to an empty row, Excel won’t show you this pop-up, it will simply move the data to the empty row. Then, release the left mouse button and you will see a pop-up asking “There’s already data here. In the example, we’re dragging row 6 to row 11. ![]() While you’re dragging the row, it will highlight the current row in a green border. Now, hold down the left mouse click, and drag it (top or bottom) to the desired location where you want to move the row. You should see your cursor change to a move pointer (cross with the arrows). Here, we’re selecting row 6.Īfter selecting the row, move your cursor to the edge of the selection (either top or bottom). You can select an entire row by simply clicking the row number or clicking on any cell in the row and pressing Shift+ Spacebar. The first method is a simple drag and drop but the moving row will replace the destination row.įirst, select the row (or contiguous rows) that you want to move. There are three ways you can drag-and-drop rows in Excel, including drag and replace, drag and copy, and drag and move. But dragging rows in Excel is a bit more complex than you realize. The drag and drop method is the easiest way to quickly move rows in a dataset. Move a Row/Column by Dragging and Dropping in Excel ![]() ![]() In this tutorial, we will cover all three methods one by one. There are three ways to move rows or columns in Excel, including the drag method using the mouse, cut and paste, and rearrange rows using the Data Sort feature. If you work with Excel tables a lot, it’s important to know how to move rows or columns in Excel. Whether it’s a simple mistake or the data is not at the right spot or you simply need to rearrange the data, then you have to move rows or columns in Excel. While working on a worksheet that has numerous rows of data, you may have to reorder the row and columns every now and then.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |