How To Switch Two Rows In Excel

Download Article

Download Article

This wikiHow will swap the value of an Excel jail cell with another cell's value. You can swap the data betwixt adjoining cells or transpose the information in a row to a cavalcade using built-in Excel features. If you want to swap prison cell data between two separate range, you'll demand a tertiary-party tool like Kutools.

1. 1

   Open up your document in Excel. Yous tin find this program in your Kickoff menu or Applications binder.

   • You can either open up your document from Excel past clicking Open from the File tab, or you can correct-click the file in your file browser and click Open With.
   • The cells accept to be touching for this to work; for example, you can switch the info in cells A4 and B4. You tin can not, nevertheless, switch the data in A1 and G150.

2. 2

   Click the cell you want to switch. The jail cell will highlight to testify it has been selected.

   Advertisement

3. 3

   Press and hold ⇧ Shift and click the cell you want to switch with. The cursor will modify to a 工 to indicate it volition swap information.

4. four

   Release ⇧ Shift . The information in the cells will switch.^[1]

   Advertisement

1. i

   Open your document in Excel. You lot tin find this plan in your Start menu or Applications folder.

   • You can either open up your document from Excel by clicking Open from the File tab, or you tin can right-click the file in your file browser and click Open With.
   • In this method, you will switch your rows with your columns.

2. 2

   Select the unabridged data range y'all want to rotate. You can click and hold down the mouse button and drag over the cells to select the entire range.

3. 3

   Press Ctrl+C (Windows) or ⌘ Cmd+C (Mac). The option will be outlined with a broken line to indicate information technology has been copied.

4. 4

   Select a cell in a bare expanse. When yous paste your cells, you don't want to paste over any data you lot might need.

5. 5

   Click the arrow nether Paste . You'll find this in the "Home" tab of the editing ribbon above your certificate.

6. 6

   Click Paste Special… . This is at the bottom of the drop-down menu.

7. 7

   Click the box to select information technology next to Transpose. The box will make full with a checkmark to point it has been selected.

8. eight

   Click OK . The data you copied in the previous step will paste with the information transposed.^[2]

   Advertizement

1. 1

2. 2

   Open your certificate in Excel. You tin can find this plan in your Showtime menu or Applications folder.

   • Y'all can either open up your document from Excel by clicking Open from the File tab, or y'all can correct-click the file in your file browser and click Open With.

3. 3

   Click the Kutools tab. You lot'll find this in the ribbon higher up your certificate.

4. 4

   Click Range and click Swap Ranges . You'll detect this button on the left of the Kutools menu.

5. 5

   Click the first jail cell-range icon that looks similar a red arrow pointing to a blue prison cell. You'll discover this under the header "Swap Range 1".

6. 6

   Click to select your kickoff cell or cell range. The cells on your document will be highlighted to signal they are selected.

7. vii

   Click the second cell-range icon that looks similar a red pointer pointing to a bluish prison cell. You'll find this under the header "Swap Range 2".

8. 8

   Click to select your second cell or cell range. The cells on your document volition be highlighted to indicate they are selected. The cells or cell ranges you lot have selected will switch data.

9. 9

   Click Ok . The information in the selected cells will switch.^[3]

   Advertisement

Ask a Question

200 characters left

Include your email accost to get a message when this question is answered.

Submit

Advertisement

Virtually This Commodity

Article Summary 10

1. Open your document in Excel.
2. Click the cell y'all want to switch.
iii. Press and hold the Shift cardinal while you click the other jail cell.
4. Release the Shift key.

Did this summary assistance you?

Thank you to all authors for creating a folio that has been read 24,118 times.

Is this commodity up to date?

Source: https://www.wikihow.com/Switch-Cells-in-Excel

Posted by: ballardmationsills.blogspot.com

Share this post