Cut & Paste

To move data from one place to another you can use the Cut & Paste commands.

For example, let’s say you’ve already entered data in cell A1 when you realise that you actually want it to appear in cell D1.

Select cell A1 and either click the Cut symbol on the Home tab in the Clipboard group, or use the shortcut key Ctrl + X.

Next select cell D1 and either click the Paste symbol on the Home tab in the Clipboard group, or use the shortcut key Ctrl + V.

Your data will now have successfully moved from cell A1 to cell D1.