- [Instructor] To delete data from a cell,
all you need to do is place the cursor inside that cell
and hit the Delete key.
It's going a blank it out.
In fact,
you can click and drag with your mouse to select more data.
You can select and delete entire columns and rows
and drag the mouse and change anywhere
that you can see this highlighted text.
You can hit the Delete key
and it's going to delete everything.
Now, this is not to be confused with swapping cells
and deleting entire columns and rows
and worrying about those gaps in the middle.
We're going to learn how to take care of all of that
when we talk about columns and rows.
Right now, I'm just making sure that you understand
how to delete data from cells.
Now, you can also copy data from cells.
The easiest way to do this is to use keyboard shortcuts.
I'm going to start by copying everything.
Maybe you just want another copy to work with.
So I'll click and drag to select all my text,
and I'm going to hit Control or Command if you're on a Mac,
C to copy.
And then I'll place my cursor below
where I want to paste the data and hit Control or Command + V.
Now I have an entirely new copy of all that data.
You'll notice in this column
if I come up here to the formula bar, this is a formula.
Now, we haven't done that yet, so don't worry.
But what it does is it takes the contents of the column A,
that is the first name,
and the contents of column B, the last name,
and combines them to form one name.
But it copied everything.
I'm going to undo this.
Something else that you can do is drag data.
Sometimes it's just easier and faster.
I'll select all my text,
and if I slowly move my cursor
to the right edge of the selected text,
you'll see the moment it changes to a crosshair.
Now all I need to do is slide the data around.
I can put it wherever I want it.
Maybe I just want to move it down a few rows,
I can let go and it's going to move everything.
I'll do that one more time.
I can move it back to where it was.
There is one situation I need to tell you about.
Remember this formula,
when we copied everything, it kept everything intact.
So if I copy this first and last name field
along with my formula column and paste it somewhere else,
it's going to keep everything intact.
We've seen that.
But if I copy only this name column,
the one with a formula,
and paste it somewhere else, watch what happens.
Everything's blank.
That is because sometimes your data
is going to be considered absolute,
and sometimes the formulas are going to be relative.
That is sometimes they're going to be locked in
to where they are in that sheet,
and sometimes they're going to move around.
In cases like these,
we can paste the values of the end results of the formula.
That is, I don't care about the formula,
I just need Cally Reynolds' name to be in this cell.
Maybe I just need to print something off quickly
to show a manager or a quick report.
In that case, I can paste these as values.
I'll select my data again by clicking and dragging.
I'll copy it by hitting Command + C.
And I'll come over to the column.
But this time, instead of using keyboard shortcuts to paste,
I'll use the Home ribbon tab to do my copying and pasting.
In fact, here's the icons right here.
And if I hover my mouse over them, I can see where they are.
I'm going to click the down arrow next to paste.
Here I can see this paste values area.
And in fact, if I hover my mouse over it,
I can see a preview as to what's going to happen.
As you can see in column G,
if I hover my mouse over that paste values button,
I can see the names are going to be correctly populated.
If I hover my mouse over the regular paste button,
everything gets blank.
So that's how I know that's going to happen already.
I want to stick with paste values.
This is the results I want so I'll select it.
And here I can see,
especially in the formula bar, it's not a formula anymore,
it's just a value.
It pasted the values that were the result of the formula.
So remember,
this isn't going to be good for every situation,
especially if it's a number crunching situation
in which you need to know what that formula was
to know how you arrived at that figure.
But in this case, I just needed a list of names.
Remember, I was just going to print it out
or email it to my manager
and it fit my needs just fine.
So that's when pasting values is a great solution.
It won't be good all the time, but in this case it was.
So that is how you can delete cells and move them around
and copy and paste them.