Excel Move Cells
Moving Cells
Cells can be moved using either drag and drop or copy and paste.
Drag and Drop
Let’s begin by entering or copying a few useful values:
Next, start by marking the area A1:B4:
By clicking and holding the left mouse button on the boundary, you may drag and drop the range. Hovering your mouse cursor above the boundary will cause it to transform to the move symbol.
As soon as you see the symbol, drag and drop.
Adjust the range to B2:C5, as the image indicates:
Fantastic! We now have more room for data because of the additional space you have made.
Note: It’s critical to provide context for the data and ensure that the spreadsheet is simple to read. You can accomplish this by including text that clarifies the facts.
Now let’s add extra context to the data. Enter or duplicate the subsequent values:
Yes, you are correct—we are examining Pokemons! Contextualizing the facts is usually beneficial.
Let’s now examine how to use cut and paste to shift data.
Cut and Paste
Values can be transferred between ranges simply copying and pasting them.
Use the hotkeys CTRL+X to cut and CTRL+V to paste. You’ll save time by doing this.
Note the range. A1:C5.
Once the designated region has been right-clicked, select the “Cut” command, which has scissors as its icon:
Cutting results in a white-grey spectrum with dotted edges. This means that the range has been sliced and is prepared for pasting.
Right click the paste destination B6 and left click the paste icon.
You have successfully cutted and pasted the range from A1:C5 to B6:D10.
Copy and paste
Cut and paste and copy and paste function in the same way. The original cells are left in place, which is the difference.
Now let’s duplicate the cells back to A1:C5 from B6:D10.
Use the hotkeys CTRL+C to copy and CTRL+V to paste. You’ll save time by doing this. Give it a go!
Mark the range B6:D10.
Right click the marked area, and click on the “Copy” command which has two papers as its icon.
The range has a dotted green border after copying. This means the range has been copied and is prepared for pasting.
Right click the paste destination A1 and left click the paste icon:
Right click the paste destination A1 and left click the paste icon:
Cutting eliminates the originals, but copying preserves them. This is the distinction between the two operations.
Let’s now remove the original data and preserve the data inside the range of A1:C5.
Delete Data
By selecting the original cells and using the keyboard’s “Delete” button, erase them:
