How to move rows in Excel (move a row, row to column, copy row, go last row)
When we move a row, we can keep the row at the destination or replace it. we can move one row or multiple rows at a time. we can use formulas to move a row into a column. In addition, if there are many records, moving from the header to the last row or from the footer to the header will be troublesome, especially if the response is very slow, but it can be quickly achieved with shortcut keys.
Chapters:
0:00 How to move a row in Excel?
0:21 How to move rows in Excel?
0:40 How to replace rows in Excel?
1:01 How to copy a row in Excel?
1:48 Excel move row to column
2:51 Go last row in Excel
Description:
How to move rows in Excel (move a row, row to column, copy row, go last row)
One. How to move rows in Excel?
(1) Method 1: Insertion
1. How to move a row in Excel? (How to move a row up or down in Excel?)
if we want to move row 3 to row 5. Click the 3 before row 3 to select it, move the pointer to the lower border of the third line, the pointer will change to a cross with four arrows, hold down the "Shift" on your keyboard, drag the pointer down, and release the left button after going to the bottom border of line 5, then row 3 will be moved to row 5, and row 5 will be moved up to row 4.
2. Move multiple rows, if we want to move rows 3 to 4 to rows 9 to 10.
A. Select row 2, hold down the left button and drag down to select rows 3 and 4, move the pointer to the bottom border of row 4, and it will change to a cross with arrows.
B. Press and hold the left button, drag down until the bottom border of row 10, release the left button, then rows 3 to 4 are moved down to rows 9 to 10 as a whole, and the original lines 9 to 10 are moved up.
(2) Method 2: Replace (How to replace rows in Excel?)
1. Suppose we replace row 5 with row 2. Select row 2, move the pointer to the bottom border of row 2, the pointer will change to a cross with arrows, hold down the left button and move to the bottom border of row 5, release the left button, and an inquiry window pops up, click "OK" and then row 5 is covered by row 2.
2. If we want to replace multiple rows, select the rows we want to replace and drag them down.
Two. How to copy a row in Excel?
1. If we copy the third row to the sixth row. Select the third row, hold down the "Ctrl" on your keyboard, move the pointer to the bottom border of the third row, the pointer will then change to "the arrow with a small plus sign + in the upper right corner", hold down the left button and drag down, drag until the bottom border of the sixth row, the operation is complete.
2. If we want to copy rows to empty rows, just insert empty rows at the destination location. If we want to copy multiple rows at once, we only need to select multiple rows at once, and the rest of the operations are the same as copying a row.
Three. Excel move row to column
1. Suppose we move the first row to column E. Double-click E1 and copy the formula =INDIRECT(CHAR(ROW(INDIRECT("A"&(64 + ROW()))&1) into E1, press "Enter" on your keyboard. Move the pointer to the fill handle of cell on the lower right corner of E1, the pointer changes to a Bold black plus sign (+), hold down the leftbutton and drag down until the text in the first row is all moved to column E.
2. If we want to go the second row to column F. Just change the formula to =INDIRECT(CHAR(ROW(INDIRECT("A"&(64 + ROW())&2).
Formula Explanation:
ROW() returns the row number of the row where the formula is located; The formula is at E1, which returns 1. Because the number of A is 65 in the ASCII table, use 64 + ROW().
INDIRECT returns the reference specified by the text string. INDIRECT("A"&(64 + ROW()))) is computed to become INDIRECT("A"&65), which returns $A$65.
ROW($A$65) returns 65.
CHAR returns the character specified by a number. CHAR(65) returns A.
INDIRECT("A"&1) returns a reference to A1, i.e. "Clothes".
Four. Go last row in Excel
Select cell A1, press "Ctrl + Down Arrow" on your keyboard to quickly navigate to the last row of the table; Press "Ctrl + Up Arrow" on your keyboard to quickly navigate to the first row.
Watch video How to move rows in Excel (move a row, row to column, copy row, go last row) online without registration, duration hours minute second in high quality. This video was added by user Loinsure 25 April 2023, don't forget to share it with your friends and acquaintances, it has been viewed on our site 489 once and liked it 0 people.