- [Instructor] You can edit text or values
in a cell directly.
To start editing values,
just put your cursor right in a cell.
From here, you can start typing
and it's going to overwrite what's already in there.
Hit the Enter key and the value's been changed.
While the cell is selected,
you'll also notice up here in what's called the formula bar,
you can see what's in that cell.
I can click right from here.
And when I see the blinking cursor,
I can also edit that value right in the formula bar.
The last way I might want to edit a cell
is to double click inside the cell.
For example, let's take a look at this word receiver,
which I've spelled wrong.
I can double click right inside the cell.
There's the blinking cursor,
and I can make my change and hit the Enter key.
Let's move all of these years up by one.
Even though there's already data in here,
I can still come in and start typing
and hit the Tab key
and continue to type as if they were empty.
So now that we've made some changes,
that's how you edit a cell.
But Excel also comes
with something really neat called autofill.
This is a quick way to do data entry.
Autofill allows you to quickly populate the same value
in multiple cells in a row or a column,
and it can even do series
such as counting every other number,
counting by 5s, dates, et cetera.
Let's take a look.
I'll start by putting in some text.
I'll just pick a word.
How about apples?
Maybe I'm hungry.
If I hold my cursor
at the very bottom right hand side of the cell,
the icon changes to a plus sign.
With that crosshair icon,
I can click and drag
and it's going to fill that word for as far as I drag.
This works vertically and it also works horizontally.
I can drag it out as far as I want to.
So it works for text,
but it also works for numbers.
I'll put in a series
and click and drag,
and there it is.
This time, I'm going to put in a 1 followed by a 2.
To do a series,
you need to highlight both cells.
On the bottom cell,
click the crosshair and repeat the process.
It's going to start counting down,
and you'll notice it even copied the formatting,
every other cell is bold faced.
You can do it by every other number or counting by 5s.
As long as you've selected both cells,
it's worth playing around to see if Excel
can figure out what you're trying to do in that series.
It can even do dates.
I'm going to delete the values in these cells
by clicking and dragging
and hitting the Delete key on my keyboard.
I'm going to type Jan.
Now, if I spread these out,
it's going to fill in these months.
And I don't have to use the abbreviations either.
I can type the whole word, such as January or February.
Something really great
is that I can even do a series combined with other words.
I'm going to delete this
and I'm also going to delete the title that says Units Sold.
Let's say we want to go back to the same year that we had,
except this time,
I'm going to say the year and the word Units Sold after.
For example, 2019 Units Sold.
I'll make the text a little bit smaller
so that we can see it,
and I'll stretch this out
and it's going to fill in the entire series.
I'll come up here and angle this clockwise.
Now we can see it a little more clearly,
but it kept the pattern
and the text that followed it.
This is a really cool feature.
So you can edit text
and you can also have Excel use autofills
to do your work for you.