我们了解到，当您在Microsoft Word 中更改文本序列时，您必须手动更改所有内容，因为Microsoft Word 不提供交换行或列以重新排列文本的功能。这可能非常烦人且耗时。但是，您不必使用Microsoft Excel 进行相同的操作，因为您可以使用交换功能来交换 Excel 中的列。 (Excel as you can use swap function to swap columns in Excel. )
在处理Excel工作表时，单元格中填充了一些数据，但不小心将一列或一行的错误数据放入另一列或另一行。此时，问题出现了：如何在Excel中交换列或行或单元格？因此，为了帮助您了解Excel的交换功能，我们提供了一个小指南，您可以按照该指南进行操作。
如何在Microsoft Excel中交换(Microsoft Excel)列(Columns)、行(Rows)或单元格(Cells)
当您为老板做重要任务时，您必须在Excel工作表的特定列或行中插入正确的数据，您不小心将第 1列的数据插入到第 2 列(Column 2)，将第 1 行的数据插入第 2 行. 那么，你如何解决这个错误(how do you fix this error)呢？手动操作会花费您很多时间。这是Microsoft excel 的交换功能派上用场的地方。使用交换功能，您可以轻松交换任何行或列，而无需手动进行。您可以轻松尝试以下任何一种方法来交换Excel工作表中的列或行。
方法 1：通过拖动交换列单元格(Method 1: Swap Column Cells by Dragging)
拖动方法需要一些练习，因为它可能比听起来更复杂。现在，让我们假设您有一个Excel表，其中您的团队成员有不同的每月分数，并且您想将D(Column D)列的分数交换到 C 列，那么您可以按照以下步骤操作此方法。
1. 我们以团队成员的不同月得分为例，如下面的截图所示。在此屏幕截图中，我们将D 列的月度分数交换到 C 列，反之亦然。(swap the monthly scores of Column D to Column C and Vice-versa.)
2. 现在，您必须选择要交换的列(select the column) 单元格。(cells)在我们的例子中，我们通过单击 D 列顶部来选择 D 列(we are selecting column D by clicking at the top on Column D)。查看屏幕截图以更好地理解。
3. 选择要交换的列后，您必须将鼠标光标向下移动到行的边缘(bring your mouse cursor down to the edge of the line)，您会看到鼠标光标将从白色加号变为四边箭头光标(white plus to a four-sided arrow cursor)。
4. 将光标放在列的边缘后，当您看到一个四边箭头光标时，您必须按住 shift 键(hold the shift key)并单击鼠标左键将( left-click to drag)列拖到您喜欢的位置。
5. 当您将列拖到新位置时，您将在要移动整个列的列之后看到一条插入线。(insertion line)
6. 最后，您可以拖动列并释放 shift 键来交换整个列。(you can drag the column and release the shift key to swap the entire column.)但是，您可能必须根据您正在处理的数据手动更改列标题。在我们的例子中，我们有月度数据，因此我们必须更改列标题以保持顺序。
这是交换列的一种方法，同样，您可以使用相同的方法交换行中的数据。这种拖动方法可能需要一些练习，但是当你掌握它之后，这种方法可以派上用场。
另请阅读：(Also Read: )如何将 Excel (.xls) 文件转换为 vCard (.vcf) 文件？(How to convert Excel (.xls) file to vCard (.vcf) file?)
Method 2: Swap Column/Row/Cells by Copy/Pasting
在 Excel 中交换列的(swap columns in Excel)另一种简单方法 是复制/粘贴方法，这对用户来说非常容易使用。您可以按照以下步骤操作此方法。
1. 第一步是通过单击列标题(clicking on the column header)选择( select the column)要交换的列。在我们的例子中，我们将D(Column D)列交换为C 列(Column C)。
2. 现在，通过右键单击列(column)并选择剪切(Cut)选项来剪切选定的列。
注意：(Note:)或者，您也可以通过同时按下Ctrl + X 键(keys)来使用键盘快捷键。
3. 您必须选择要在其之前插入剪切列的列。右键单击所选列(selected column)以从上下文菜单中选择插入剪切单元格(Insert cut cells)选项，如下图所示。
注意：(Note:)或者，您也可以通过同时按下Ctrl + V 键(keys)来使用键盘快捷键。
4. 它会将您的整个列交换到您喜欢的位置。最后，您可以手动更改列标题。
另请阅读：(Also Read:) 在 Excel 中的工作表之间快速切换(Quickly Switch Between Worksheets in Excel)
方法 3：使用列管理器
(Method 3: Use Column Manager
)
您可以使用内置的列管理器来交换Excel中的列。这是用于在Excel(Excel)工作表中切换列的快速高效工具。列管理器允许用户更改列的顺序，而无需手动复制或粘贴数据。
因此，在继续使用此方法之前，您必须在 Excel 工作表中安装Ablebits 的终极套件扩展，如图所示。(The ultimate suite extension of Ablebits)
1. 在Excel(Excel)表上成功安装终极套件附加组件后，您必须转到Ablebits 数据( Ablebits data )选项卡并单击管理( Manage )，如图所示。
2. 在管理选项卡中，单击列管理器(Column manager)。
3. 现在，列管理器窗口将在( column manager)Excel表的右侧弹出。在列管理器中，您将看到所有列的列表，如图所示。
4.在Excel工作表上选择要移动的列，然后使用左侧列管理器窗口中的向上(Select the column)和向下箭头( up & down arrows)轻松移动选定的列。
- 在我们的例子中，我们从工作表中选择 D 列，并使用向上箭头将其移动到 C 列之前。
- 相似地; 您可以使用箭头键移动列数据。
注意：(Note:)但是，如果您不想使用箭头工具，您还可以选择将列管理器窗口中的列拖动(dragging the column)到所需位置。
通过这种方式，您可以完全控制列管理器的所有功能。
另请阅读：(Also Read:)如何从 Excel 文件中删除密码( How to Remove Password from Excel File)
专业提示：将行换成列
(Pro Tip: Swapping Rows Into Columns
)
让我们考虑交换行 (3) 和列 (E)。按照以下步骤将Excel将行交换为列。
1. 单击第3行。
2. 按Ctrl + C键。
3. 将光标放在E列的第一个单元格中。
4. 单击菜单栏中粘贴(Paste)选项下方的箭头。(arrow)
5.点击选择性粘贴(Paste Special)...
6. 勾选转(Transpose)置选项并点击确定(OK)。
7. 现在，行值被交换为列值。
常见问题 (FAQ)(Frequently Asked Questions (FAQs))
Q1。如果使用任何方法错误地交换了值，如何解决？(Q1. How to fix if the values are incorrectly swapped using any methods? )
答。(Ans.)您可以通过按Ctrl + X keys轻松撤消该过程，以修复错误交换的值。
Q2。剪切和粘贴方法是否适用于多列？(Q2. Does the cut and paste method work for the multiple columns?)
答。(Ans.)是的，您可以使用剪切和粘贴方法来交换(cut and paste method)Excel中的多个列、行或单元格。
Q3。是否可以使用剪切和粘贴方法和键盘快捷键来交换行？(Q3. Do the cut and paste method and keyboard shortcuts can be used to swap rows?)
答。(Ans.)是的，您可以使用剪切和粘贴方法以及键盘快捷键在行之间交换值。
Q4。是否有任何工具可用于在行、列或单元格之间进行交换？(Q4. Are there any tools available to swap between rows, columns, or cells?)
答。(Ans.) Kutools和Ablebits是可用于MS Excel的顶级和最佳工具。
受到推崇的：(Recommended:)
我们希望本指南对您有所帮助，并且您能够了解如何在 Excel 中交换列、行或单元格(how to swap columns or rows or cells in Excel)。上面的方法很容易执行，当你在做一些重要的任务时它们会派上用场。继续访问我们的页面以获取更多很酷的提示和技巧，并在下面留下您的评论。
How to Swap Columns or Rows in Excel [Step by Step]
We understand that when you are changіng the text ѕequence in Mіcrosoft word, you have to change everything manually because Mіcrosoft word does not gіve yoυ the feature of swаpріng the rows or columns for rearrаngement of text. It can be pretty аnnoying and time-consuming. However, you do not have to go through the same thing with Microsoft Excel as you can use swap function to swap columns in Excel.
When you are working on an Excel sheet, you have the cells filled with some data, but you accidentally put the wrong data for one column or row in another column or row. At that point, the question arises: how to swap columns or rows or cells in Excel? Therefore, to help you figure out Excel’s swap function, we have come up with a small guide that you can follow to do so.
How to Swap Columns or Rows or Cells in Microsoft Excel
When you are doing an important assignment for your boss, where you have to insert the correct data in the specific columns or rows in an Excel sheet, you accidentally insert the data of column 1 in Column 2 and the data of row 1 in row 2. So, how do you fix this error? Doing it manually is going to take you a lot of time. This is where the swap function of Microsoft excel comes in handy. With the swap function, you can easily swap any rows or columns without having to do it manually. You can easily try any of the following methods for swapping the columns or rows in an Excel worksheet.
Method 1: Swap Column Cells by Dragging
The dragging method requires some practice as it could be more complex than it sounds. Now, let us suppose you have an Excel sheet with different monthly scores for your team members and you want to swap the scores of Column D to column C, then you can follow these steps for this method.
1. We are taking an Example of different monthly scores of our team members, as you can see in the screenshot below. In this screenshot, we are going to swap the monthly scores of Column D to Column C and Vice-versa.
2. Now, you have to select the column cells that you want to swap. In our case, we are selecting column D by clicking at the top on Column D. Look at the screenshot to understand better.
3. After you have selected the column you want to swap, you have to bring your mouse cursor down to the edge of the line, where you will see that the mouse cursor will turn from a white plus to a four-sided arrow cursor.
4. When you see a four-sided arrow cursor after placing the cursor on the edge of the column, you have to hold the shift key and left-click to drag the column to your preferred location.
5. When you drag the column to a new location, you will see an insertion line after the column where you want to move your entire column.
6. Finally, you can drag the column and release the shift key to swap the entire column. However, you may have to change the column heading manually depending upon the data you are working on. In our case, we have monthly data, so we have to change the column heading to maintain the sequence.
This was one method for swapping the columns, and similarly, you can use the same method to swap the data in the rows. This dragging method may require some practice, but this method can come in handy after you have mastered it.
Also Read: How to convert Excel (.xls) file to vCard (.vcf) file?
Method 2: Swap Column/Row/Cells by Copy/Pasting
Another easy method to swap columns in Excel is the copy/pasting method, which is pretty easy to use for users. You can follow these steps for this method.
1. The first step is to select the column that you want to swap by clicking on the column header. In our case, we are swapping Column D to Column C.
2. Now, cut the selected column by right-clicking on the column and choosing the Cut option.
Note: Alternately, you can also use keyboard shortcut by pressing the Ctrl + X keys together.
3. You have to select the column before which you want to insert your cut column. Right-click on the selected column to choose the option of Insert cut cells from the context menu, as depicted below.
Note: Alternately, you can also use keyboard shortcut by pressing the Ctrl + V keys together.
4. It will swap your entire column to your preferred location. Finally, you can change the column heading manually.
Also Read: Quickly Switch Between Worksheets in Excel
Method 3: Use Column Manager
You can use the in-built column manager to swap columns in Excel. This is a fast and efficient tool for switching columns in an Excel sheet. The column manager allows users to change the order of the columns without manually copying or pasting the data.
So, before proceeding with this method, you have to install The ultimate suite extension of Ablebits in your Excel sheet, as shown.
1. After you have successfully installed the ultimate suite add-ons on your Excel sheet, you have to go to the Ablebits data tab and click on Manage as shown.
2. In the manage tab, click Column manager.
3. Now, the column manager window will pop up on the right side of your Excel sheet. In the column manager, you will see the list of all your columns, as shown.
4. Select the column on your Excel sheet that you want to move and use the up & down arrows in the column manager window on the left to move your selected column easily.
- In our case, we are selecting column D from the worksheet and using the upward arrow to move it before column C.
- Similarly; you can use the arrow keys for moving the column data.
Note: However, if you do not want to use the arrow tools, then you also have the option of dragging the column in the column manager window to the desired location.
In this way, you can have full control over all the functions of the column manager.
Also Read: How to Remove Password from Excel File
Pro Tip: Swapping Rows Into Columns
Let us consider swapping row (3) and column (E). Follow the below steps to Excel swap rows into columns.
1. Click on Row 3.
2. Press Ctrl + C keys.
3. Place the cursor in the first cell of column E.
4. Click on the arrow below the Paste option in the menu bar.
5. Click on Paste Special…
6. Check the option Transpose and click on OK.
7. Now, the row values are swapped into column values.
Frequently Asked Questions (FAQs)
Q1. How to fix if the values are incorrectly swapped using any methods?
Ans. You can easily undo the process by pressing Ctrl + X keys to fix incorrectly swapped values.
Q2. Does the cut and paste method work for the multiple columns?
Ans. Yes, you can use the cut and paste method to swap multiple columns or rows or cells in Excel.
Q3. Do the cut and paste method and keyboard shortcuts can be used to swap rows?
Ans. Yes, you can swap values between rows using the cut and paste method and keyboard shortcuts.
Q4. Are there any tools available to swap between rows, columns, or cells?
Ans. Kutools and Ablebits are the top and best tools available for MS Excel.
Recommended:
We hope this guide was helpful and you were able to understand how to swap columns or rows or cells in Excel. The above methods are pretty easy to perform, and they can come in handy when you are in the middle of some important assignment. Keep visiting our page for more cool tips & tricks and leave your comments below.
