Moving cells in Excel
When you create tables or worksheets in Excel, sometimes you have to move columns or rows. Often, you may also need to move specific cells in Excel. During this process, problems frequently arise if contents, formulas, cell references or formatting are accidentally changed. However, there are several simple options for moving cells in Excel without making unwanted changes. Once you’ve selected the cell or range of cells that you want to move, there are three different ways to move their contents from A to B. We’ll explain these methods and show you exactly how they work.
Moving cells in Excel using drag and drop
Using drag and drop to move cells in Excel is one of the most convenient ways of transferring contents in your spreadsheet. Follow these steps to use this option:
1. First, select the range of cells you want to move.
2. Place the mouse pointer on the border of the selected range. The mouse pointer becomes a four-sided arrow or a hand symbol.
3. Click and hold down the left mouse button.
4. Drag the cells to the desired location.
You can copy the selected cell(s) to the new area using drag-and-drop by holding down the Ctrl key on a PC or the Alt key on a Mac and hovering over the border of the selection. If the area is already filled, the cell contents are overwritten.
Moving cells in Excel using Copy and Paste
As an alternative to drag and drop, you can move cells in Excel using Copy and Paste.
1. Once again, select the range of cells you want to move.
2. Press Ctrl + X to cut.
3. Press Ctrl + V to paste the cell(s) into the destination cell(s).
The advantage of this option is that it requires one less step than Copy and Paste using Ctrl + C because the contents are transferred directly. This saves you the additional step of deletion.
If you move or copy a formula, Excel automatically changes the cell references to the new location.
Moving cells in Excel without changing the contents
If you tend to use formulas or specific cell references often, you should use the $ sign in your formulas.
Organize your data in Excel and quickly create spreadsheets using Microsoft 365 Business packages from IONOS.
If a reference is anchored using $[column]$[row], the cell reference is retained even if you move the Excel cell with the formula.
1. Anchor the cell references by using $ signs in the formula.
2. Copy the range of cells.
3. You don’t have to adjust cells that you wish to remain flexible.
If you want the cell reference in the first column to move when copied, only anchor part of the formula using the $ sign. In the following example, only “B” moves in the row, whereas “C6” was anchored using the $ sign. This means that the formula in “E6” returns a different result.
You can also easily transfer formulas to other cells by dragging the lower-right corner of the formula. In this case, it’s important to anchor the formula so that it’s correctly duplicated.
You can find further practical Excel tips in the following articles: Creating drop-down menus in Excel, Excel shortcuts, Transposing in Excel, Creating spreadsheets in Excel and Deleting empty rows in Excel.
Related articles
Robert KneschkeShutterstock How to use the percentage formula in Excel
Want to know how to calculate percentages in Excel? With the most important formulas for calculating percentages in Excel, the process is a cinch. In this article, you’ll learn how to calculate percentages of totals and growth rates, and how to figure out proportions and totals based on percentages. We’ll also give you tips on increasing and decreasing numbers by percentages.
Ground PictureShutterstock Splitting Cells in Excel: How to Divide Cell Content Among Multiple Columns
If a table field contains several values, it often makes sense to split the respective Excel cell. Although the Microsoft spreadsheet program doesn’t offer a general function for this, you can split the cell content among multiple columns by configuring and using separators. We explain how you can use this option in your Excel document.
Rawpixel.comShutterstock How to merge cells in Excel
Want to merge cells or combine columns in your Excel spreadsheet, but don’t know how? In this article, we’ll explain how to combine, center and split cells in Excel in a way that is clear and easy to understand. You’ll find helpful examples to guide you along as well as information on how to use the “&” sign to combine cells. Let’s get started.
Moving columns and rows in Excel – a step-by-step guide
Moving columns and rows in your Excel spreadsheet is effortless when you use the drag-and-drop function or keyboard shortcuts. In this guide, we’ll show you how to move columns or rows in Excel or cut and paste them into a different location. That way, you can transfer values in Excel without worrying about formula errors or formatting problems.
