MS EXCEL 2016(Copy, Move Cell Range)

HELLO EVERYONE!

Let's Move on in our Excel Tutorial, In this Tutorial we will learn how to copy and move range of Excel to other location.

So Let's Start!

Starting With copying range-

To copy a range, select the first cell in your range. You will see the cell become active with a black box around it.

Now as you can see we have selected the cell C1.

And hold down the shift key and click on the last cell in the range, in our example we have clicked on the cell C9.

You will see the entire range will be highlighted.

Now to copy the cells, press CTRL+C. You will see a dotted border appear around the range of cells indicating that the cells are in the clipboard and ready to be pasted to another location in your spreadsheet.

Now you will need to select your destination. To do this, select the starting cell where you would like to paste the range. In this example, we have selected cell G1.

To Paste the range of cells press CTRL+V.

Now you can see the pasted range in the new location in your spreadsheet. In our example, G1:G9 now contains a copy of the data and formatting from the range B1:B9.

Now!

Moving The Cell Range-

To move a range, select the first cell in your range. You will see the cell become active with a green box around it. In our example, we've selected cell C1.

Now, hold down the shift key and click the last cell in the range. In our example we clicked on C9.

Now from the keyboard type CTRL+X ,To let the EXCEL know that you want to move the selected range to somewhere else. You will see a dotted border appear around the range of cells indicating that the cells are ready to be moved to another location in your spreadsheet.

Next, select your desired destination to paste the range. In our Example we have selected F1.

See!

Now you should see the range move to the new location in your spreadsheet. In this example, F1:F9 now contains the original data and formatting from the range C1:C9.


So, guys I guess I have demonstrated all the necessary topics of MS EXCEL 2016 in brief.
If You have any query plz let me know, I will try to answer them.

And this was our last topic for Excel.

So try them out personally and let me know!

Stay Updated!