You can move or copy selected cells, rows, and columns using the Cut command or the Copy command, but you can also move or copy them using the mouse.
When you move or copy rows and columns, Excel moves or copies all the data they contain, including formulas and their result values, comments, cell formats, and hidden cells.
If the cell contains a formula, the cell reference is not adjusted. Therefore, the contents of the cells that were moved or copied and the contents of any cells that point to them may display #REF!. If this occurs, you will have to manually adjust the references.
The specific steps to move a column are as follows:
1. Use the cut or copy command to move:
1. Select The cell, row, or column to move or copy. Do one of the following:
2. To move rows or columns, on the Home tab, in the Clipboard group, click Cut. Keyboard shortcut: Press CTRL X. To copy a row or column, on the Home tab, in the Clipboard group, click Copy. Keyboard shortcut: Press Ctrl C.
3. Right-click a row or column below or to the right of where you want to move or copy the selection, and then perform one of the following operations:
When moving a row or column, click "Insert Cut Cells".
When copying rows or columns, click Insert Copied Cells.
2. Use the mouse to move or copy rows and columns:
1. Right-click a row or row below or to the right of where you want to move or copy the selected content. One column,
2. Perform one of the following operations:
When moving a row or column, click "Insert Cut Cells".
When copying rows or columns, click Insert Copied Cells.
Select rows or columns to move or copy.
3. Do one of the following:
To move a row or column, point to the border of the selected area. When the pointer changes to the Move pointer, drag the row or column to another location.
To copy rows or columns, hold down CTRL while pointing to the border of the selected area. When the pointer changes to the copy pointer , drag the row or column to another location.
Important: Please make sure to hold down CTRL during the drag and drop operation. If you release CTRL before releasing the mouse button, you will move the rows or columns instead of copying them.
When you use the mouse to insert a copied or cut column or row, the existing content of the target cell will be replaced. To insert copied or cut rows and columns without replacing existing content, right-click the row or column below or to the right of where you want to move or copy the selection, and then click Insert Cut Cell" or "Insert Copied Cell".
For more Excel-related technical articles, please visit theExcel Basic Tutorialcolumn!
The above is the detailed content of How to move or copy columns in excel. For more information, please follow other related articles on the PHP Chinese website!