组织您的Excel电子表格并不总是那么容易,尤其是当这些电子表格很大时。但是,如果您知道如何更有效地在Excel中移动列,您甚至可以重新组织大型电子表格,而不会弄乱其中的所有数据和计算。
在本文中,您将学习在Excel中移动列的三种方法以及每种方法是最佳使用方法的情况:
- 复制和插入列
- 使用复制和粘贴快捷方式
- 使用 Shift 键和鼠标
通过这些技术中的每一种,您将学习如何使用它们来移动列,而不会覆盖其他列(overwriting other columns)或丢失电子表格中的任何数据。
(Move Columns)在Excel 中(Excel –)移动列-标准方式(Standard Way)
当大多数人想要将列从一个位置移动到另一个位置时,他们会采用大多数人都知道的方法。与本文中描述的其他方法相比,此方法需要额外的步骤。但是,显示该过程很重要,这样您就可以看到使用其他方法之一节省了多少时间。
1. 右键单击要放置列的列标题,然后选择插入(Insert)。这将创建一个空白列,您可以在其中放置要移动的列。
2.从要复制的列中选择所有单元格。(Select)只选择(Select)单元格,而不是整个列。右键(Right)单击突出显示的单元格并选择Cut。
3. 右键单击您创建的空列中的第一个单元格,然后选择粘贴(Paste)。或者使用Ctrl-V键盘快捷键将数据粘贴到空白列中。
4. 现在原来的列将是空白的。选择整个列,右键单击标题,然后选择Delete。
现在原始列被删除,列中的数据被放置在您想要的位置。
使用复制和插入移动列
在Excel(Excel)中移动列的一种更快的方法是使用 Excel 中的插入功能(Insert feature in Excel)。这种方法可以让您跳过两个步骤——创建一个空白列和删除移动的列。
1.选择第一列的顶部,以便选择整个列。右键(Right)单击并选择剪切(Cut)。或者,您可以按Ctrl + C剪切列。
2. 选择要移动列的右侧的列。右键(Right)单击列顶部并选择插入剪切单元格(Insert Cut Cells)。作为选择此选项的替代方法,您可以选择Ctrl和键盘上的加号 ( + )。这也会将剪切的单元格插入到您选择的列的左侧。
仅在这两个步骤之后,您的剪切列就会插入到您选择的位置。
真的就这么简单。
您还可以按照相同的步骤在Excel中移动多个列。(Excel)您只需要在选择Cut(Cut)之前选择多个列。当您插入剪切的单元格时,它会插入您之前剪切的两列。
唯一的限制是您使用的列需要并排放置。
(Move Columns)使用Shift 键(Shift Key)和鼠标(Mouse)移动列
在Excel(Excel)中移动列的另一种方法是使用键盘上的Shift键和鼠标。
这种方法确实需要您创建
- (Insert)在电子表格中要将列移动到的位置插入一个空白列。使用与本文第一部分相同的过程。右键(Right)单击该列并选择Insert。
- 选择要复制的整列(或多列)。将鼠标光标移动到列的左边界或右边界,直到鼠标指针变为带有目标符号的指针。
3.左键(Left)单击并按住鼠标,将列拖到您创建的空白列中。当您释放鼠标指针时,Excel会询问您是否要替换列的内容。由于您已将该列设为空白,因此您只需选择OK。
这会将您的列置于空白列的位置。
如果您想跳过创建空白列的步骤,只需右键单击鼠标即可拖动该列,而不是使用鼠标左键。以相同的方式拖动列,但将其释放到要在左侧插入列的列上。释放后,您将看到几个如何将列插入插槽的选项。
如果您选择了要放置移动列的右侧的列,请选择Shift Right 和 Move(Shift Right and Move)以插入您的列并将其余列向右移动。
使用这种方法(右键单击)减少了仅选择列、右键单击并将列拖动到您想要的任何位置所涉及的步骤数。到目前为止,这是在Excel中移动列的最简单方法。
哪种方法适合您?
不同的人更喜欢使用键盘或鼠标在Excel(Excel)中做事。没有一种方法一定比下一种更好。这实际上归结为上述哪个过程最适合您通常使用Excel的方式。
在Excel(Excel)中移动列不必很复杂,也不必弄乱整个工作表。只需(Just)仔细完成上述详细步骤,您就可以快速轻松地移动整个列。
所有这些技术也适用于 Excel 中的移动行(moving rows in Excel)。
How To Move Columns In Excel
Оrganizing your Excel spreadsheets isn’t alwаys easy, especially when those spreadsheets are large. But if you know how to move columns in Excel more еfficiently, you can reorgаnize even large spreadsheets without messing up all of the data and calculations inside of them.
In this article, you’ll learn three ways to move columns in Excel and the situations where each approach is best approach to use:
- Copying and inserting columns
- Using copy and paste shortcuts
- Using the Shift key and the mouse
With each of these techniques, you’ll learn how to use them to move columns without overwriting other columns or losing any data in your spreadsheet.
Move Columns In Excel – The Standard Way
When most people want to move a column from one position to another, they take the approach most people know about. This approach takes extra steps than the others described in this article. However, it’s important to show the process so you can see how much time is saved by using one of the other approaches.
1. Right-click the header of the column where you want to place the column and select Insert. This will create a blank column where you can place the column you want to move.
2. Select all of the cells from the column you want to copy. Select only the cells, not the entire column. Right click the highlighted cells and select Cut.
3. Right-click the first cell in the empty column you created and select Paste. Or use the Ctrl-V keyboard shortcut to paste the data into the blank column.
4. Now the original column will be blank. Select the entire column, right click the header, and select Delete.
Now the original column is deleted, and the data from the column is placed where you wanted it to go.
Move Columns With Copy And Insert
A much faster approach to move columns in Excel is using the Insert feature in Excel. This approach lets you skip over two steps – creating a blank column and deleting the moved column.
1. Select the top of the first column so that the whole column is selected. Right click and select Cut. Alternatively, you can press Ctrl + C to cut the column.
2. Select the column to the right of where you want to move your column. Right click the top of the column and select Insert Cut Cells. As an alternative to selecting this, you could instead select Ctrl and the plus sign (+) on the keyboard. This will also insert the cut cells to the left of the column you’ve selected.
After just these two steps, your cut column gets inserted in the location you’ve selected.
It’s really as simple as that.
You can also move multiple columns in Excel by following the same steps. You just need to select multiple columns before you select Cut. When you insert the cut cells, it’ll insert the two columns that you previously cut.
The only limitation is that the columns you use need to be positioned beside one another.
Move Columns With Shift Key And Mouse
Another way to move columns in Excel is using the Shift key on your keyboard, and the mouse.
This approach does require that you create
- Insert a blank column where you’d like to move your column to in your spreadsheet. Use the same procedure as you did in the first section of this article. Right click the column and select Insert.
- Select the entire column (or multiple columns) you want to copy. Move the mouse cursor to either the left or right border of the column until the mouse pointer changes to a pointer with target symbol.
3. Left click and hold the mouse, and drag the column into the blank column you’ve created. When you release the mouse pointer, Excel will ask you if you want to replace the contents of the column. Since you’ve made the column blank, you can just select OK.
This will place your column into the position of the blank one.
If you want to skip the step of creating a blank column, just right-click your mouse to drag the column rather than using the left mouse button. Drag the column over in the same way, but release it on the column where you’d like to insert your column to the left. When you release you’ll see several options of how to insert to column into the slot.
If you’ve selected the column to the right of where you want to place your moved column, select Shift Right and Move to insert your column and shift the rest of the columns to the right.
Using this approach (right-clicking) reduces the number of steps involved to just selecting the column, right clicking and dragging the column to wherever you would like it to go. By far this is the easiest way to move columns in Excel.
Which Method Is Right For You?
Different people prefer using the keyboard or the mouse to do things in Excel. No approach is necessarily better than the next. It really comes down to which procedure above fits in best into how you normally use Excel.
Moving columns in Excel doesn’t have to be complicated, and it doesn’t have to mess up your entire worksheet. Just carefully work through the steps detailed above and you can move entire columns quickly and easily.
All of these techniques also work with moving rows in Excel as well.