Copying & Pasting Cells in Microsoft Excel

"Hi, I’m Gary with Expert Village; let’s see how we can move data around on our worksheet. We have here a small little table and we can see, I’m going to show you how the, how to actually cut, copy and paste information in our spreadsheet to different areas in our spreadsheet. So let’s say we want to go ahead and click on a column, let’s say for the year 2001, so we go ahead and select it again by just holding down the left mouse key and just dragging, scrolling down so now we have this column selected. We go ahead and either go up top and click on edit and copy or from the keyboard we just hit “control C” and now we just go and click on another area of the worksheet. Let’s say that we go down here and we only have to click on one cell and that one cell is going to be the first cell of our selection and everything else that follows is going to be pasted in so go ahead and click one. Select one cell and again we can go up top and click “paste” or we can go ahead and from the keyboard hit “control V” but either way we see that the information goes into the other section of our worksheet and it is a very easy way to take data and move it around. Let’s say that we needed to add in another year or let’s say that we needed to add in a whole other table for a different school let’s say and we wanted to do a comparison, whatever it is, whatever reason we needed this information we can go ahead and move it down. Now keep in mind that here we did not have any formulas, this was just straight data of numbers entered into the, into the table but if we did have a formula here. Let’s say that we had an addition formula or subtraction formula, whatever it is, that formula would also be copied how here so the corresponding cell that had the formula up top, let’s say that is was the fourth cell over here in that, in the selection, the fourth cell over here would also have that same formula."