How do you move lines down in Sheets?

To move lines (rows) down in Google Sheets, select the rows you want to move and then use the "Move row down" option in the Edit menu.

Here's a step-by-step guide:

1. Open your Spreadsheet: On your computer, open the spreadsheet in Google Sheets.

2. Select the Rows: Click on the row numbers (located on the left side) to select the rows you wish to move. You can select multiple adjacent rows by clicking and dragging, or non-adjacent rows by holding down the Ctrl key (Windows) or Command key (Mac) while clicking.

3. Access the Edit Menu: At the top of the screen, click on the "Edit" menu.

4. Choose "Move row down": In the Edit menu, select "Move row down". This will shift the selected row(s) downwards, inserting them below the existing row(s).

Alternative Method: Cut and Paste

While the "Move row down" option is the most direct, you can also use the cut and paste method:

1. Select the Rows: As before, select the row(s) you wish to move.
2. Cut the Rows: Press Ctrl+X (Windows) or Command+X (Mac) to cut the rows.
3. Select the Destination Row: Click on the row number above where you want to insert the cut rows. For example, if you want to move the cut rows before row 5, click on row 5's number.
4. Insert Cut Rows: Right-click on the selected row number and choose "Insert cut rows" from the context menu. This will insert the cut rows before the selected row, shifting existing rows down.

Example Scenario:

Imagine you have the following data in your Google Sheet:

	A	B
1	Header 1	Header 2
2	Data Row 1	Data Row 1
3	Data Row 2	Data Row 2
4	Data Row 3	Data Row 3

If you select row 2 and use "Move row down," the data will be rearranged as follows:

	A	B
1	Header 1	Header 2
2	Data Row 2	Data Row 2
3	Data Row 1	Data Row 1
4	Data Row 3	Data Row 3

Data Row 1 has been moved down one row.

Moving lines down in Google Sheets is a straightforward process that can be accomplished using either the dedicated "Move row down" feature or the traditional cut and paste method. Choose the method that best suits your workflow.