How to swap up and down data in Excel

Tools Raw materials.

Excel2016 version, computer.

1. Open the computer to find and click on the Excel2016 version of the software;

2. After opening the excel** document, in order to do a good job of demonstrating, first arbitrary text content in the blank**;

3. After the text content is good, if you want to swap A2 and A3 data at this time, select the cell of A2 first;

4. After selecting the cell of A2, place the mouse above the cell and hold down the "Shift" key and drag it to the cell of A3 when the cross-shaped symbol appears.

1.With two rows of data selected, move the mouse over the border and the mouse will display the cross arrow.

2.Hold down the shift key on your keyboard, click the left mouse button and drag the data to the appropriate position (a horizontal "work" appears), then let go.

3.Finally, see if the order has been adjusted.

Select one of the rows you want to move, hold down the shift key, move the mouse to the edge of the row, and drag the mouse when the mouse turns into a cross arrow, then you will see a dotted line, just drag the dotted line to the position you want to move.

First, select the row or column you want to convert, copy, then click the target cell, right-click - paste selectively, and click "Transpose" to confirm.

1. Open the "excel" program, and then import the ** that needs to be processed.

Second, then use the mouse to click on one of the rows of data in the interchange row.

<> Fourth, then hold down the "shift" key on the keyboard, and then drag the mouse to the edge line of the next row, and the shape in the picture will appear.

5. Finally, you can release the mouse and the "shift" key, and the excel line and the bumper line are reversed.

Tools Raw materials: dell5300, win10 student edition, office2016

1. Open the document and select the data cells that need to be moved.

2. Hold down the shift key, put the mouse on the selected number of acres, and press the left button when it becomes a cross several times.

3. Hold down the left mouse button, drag the cell to the designated location of the friend brother, release the mouse in Dusty Town, and complete the exchange of the two lines.

01.Excel Word Wrap FunctionFirst of all, select the cell range that needs to be wrapped, and then click the Start - Word Wrap button. The length of the word wrap is based on the cell column width, and when the column width is changed, the line break will be adjusted automatically.

02.If you need to wrap a line according to the position you want, you can double-click the cell, position the cursor behind the line break content, and then use the key combination Alt + Enter.

<> yes. It's okay to wrap lines inside a grid. Just press and hold at the same time"alt"+ Enter key, you can force a line break in a cell!

Oh attention. Doing so will invalidate the formula!

Good luck!

Tools Raw materials.

Excel2016 version, computer.

1. Open the computer to find and click on the Excel2016 version of the software;

2. After opening the excel** document, in order to do a good job of demonstrating, first arbitrary text content in the blank**;

3. After the text content is good, if you want to swap A2 and A3 data at this time, select the cell of A2 first;

4. After selecting the cell of A2, place the mouse above the cell and hold down the "Shift" key and drag it to the cell of A3 when the cross-shaped symbol appears.

Summary:The steps to swap the positions of two lines in excel are as follows: 1. Create a new excel** on the desktop.

2. Enter the content in ** to facilitate the swap of positions later. 3. After the content is good, select the content of the second row of cells first. 4. Place the mouse on the edge of the cell, when the cross-shaped sign appears, hold down shift and don't let go, drag the content of the second row to the cell of the third row.

5. Final effect.

Demo Ruler Environment Information:Computer model: ThinkPad Wing 14 Slim, system version: window10, software version: excel2020.

The steps to swap positions between two lines in excel are as follows:

1. Create a new excel on the desktop. The specific steps are as follows: <>

2. Enter the content in **, and it is convenient to swap positions after the chaos. The specific steps are as follows: <>

4. Place the mouse on the edge of the cell, when the cross-shaped sign appears, hold down shift and don't let go, drag the content of the second row to the cell of the third row. The specific steps are as follows: <>

5. Final effect: Lu file <>

Excel is very convenient in data processing, sometimes Li will involve the exchange of two rows and two columns of data in daily work, which we can achieve by copying and pasting, but the efficiency is not very high. Excel provides a very convenient way to interchange, let's take a look at the specific steps:

1. First of all, we need to open an excel** and import the data that needs to be processed. As you can see from the example below, there are 2 rows of data.

2. Now we use the missing mouse to select one of the two rows of data that need to be exchanged, as shown in the figure below.

3. Move the mouse to the edge of our selected area, at which point the mouse shape changes and becomes a cross arrow, as indicated by the red circle.

4. Press the "shift" key at this time, and then move the mouse to the bottom of the next row, at this time, pay attention to the shape under the row data (in the red circle, similar to a "work").

5. Now when we release the mouse and the "shift" key, we can see that the two rows of data have been successfully exchanged.

Now that we've learned how to swap the contents of two adjacent rows, we can also swap the contents between two adjacent columns in the same way.

Use Displacement in Paste Special.

Copy, paste selectively, tick 'Transpose', and you're good to go.

Row and column swapping: Select the data region and click the Copy command.

Execute the Paste Values Transpose OK command in a new cell area.

You can also use the transpose() function in the paste function "Find & Reference" to swap rows and columns.