Page 73 - PlusGPT_V2.1_C7_Flipbook
P. 73
Copying/Moving Data
Just similar to Word 2016, data can be copied/moved in Excel 2016 also from one cell to another. Let
us perform these operations.
Cut, Copy and Paste Data
We can use the Cut, Copy, and Paste commands in Microsoft Excel to move or copy entire cell content.
When we use the Cut command, the content is moved to the new place and removed from its original
place. In case of the Copy command, content is copied at the new place and also exist at its original
place. The Paste command is used to paste the copied/cut data.
When you move or copy a cell, Excel moves or copies the entire cell contents and cell formatting.
Step 1: Select the cells that you want to move or copy.
Step 2: Click on Cut/Copy command in Clipboard group on Home tab to move/copy the content of
the selected cell.
To move cells, click Cut.
To copy cells, click Copy.
Step 3: Click on the cell where you would like to paste the information.
Step 4: Click on Paste command in the Clipboard group on Home tab to paste.
Copying content of a Cell Pasting content in a cell
Tech Hint
Similar to MS Word, Excel 2016 also allows us to use shortcut keys to copy, cut and
paste the content of the cells. The shortcut keys are:
To Copy: Ctrl + C To Cut: Ctrl + X To Paste: Ctrl + V
Using Undo and Redo Features
Similar to MS Word, Excel 2016 also allows to use the
Undo and Redo commands. The Undo command is
used to reverse the previous action that you have
performed in the worksheet. With the help of this
command, you can reverse more than one actions.
Introduction to Excel 2016 71

