- [Instructor] You can delete a column or row
by clicking the number or letter
to select the entire row,
and then either hitting
the Delete key on the Home ribbon tab
or right-clicking and choosing Delete.
The row disappears.
I'll hit Ctrl Z to undo that.
You can also select multiple rows
by clicking and dragging with your mouse,
and doing it the same way.
By the way, I don't want to hit the delete key on my keyboard
because all that's going to do
is delete the contents of the cell.
It's still going to leave these big gaps.
If I want to delete the actual rows
and have no gaps,
I need to right-click and choose Delete,
or use that Delete button on the Home ribbon tab.
So again, I selected multiple rows,
right-clicked and deleted,
and they're both gone.
There is a gotcha, however,
if I select this entire row,
and right-click and hit Delete,
look what happened,
it also deleted this data over here.
Sometimes there's more data here,
and we got lucky this time
because I could see it.
You just never know.
I could have to scroll all the way to the right
to see some excess data
that's not connected to my original data source.
You can get around this
by only selecting the amount of contents
that you actually want to delete,
and you can even do that with multiple rows.
Now, when I right-click and select Delete,
I get a new menu option.
It's asking me what do I want to do?
Before, we were deleting the entire row,
but this time, we want to ship the cells up.
If I say OK,
it only shifted these cells up,
it left this entire table here on the right-hand side
completely intact.
You can do the same thing with a column.
To delete a column,
click the column letter,
right-click and choose Delete.
And again, if I hit the delete key on my keyboard,
it's just going to leave me with a blank column,
and that's not what we want.
So as you can see,
sometimes you need to be careful.
I chose that column on purpose
because this column
relied on that other column for a formula,
and now I messed it up
and the formula doesn't work.
so I'll undo that.
If I delete this one,
no problem.
Now, maybe I don't want to see this phone number,
or I don't want somebody else
to be able to see everybody else's phone numbers,
I can hide this column.
I'll right-click and choose Hide,
just like we could with worksheet tabs.
It's not gone,
it's not deleted,
it's just hidden.
Now, it's very hard to see,
but I do have a visual cue
that there's a hidden column in here,
because there's now two lines
in between columns B and column D.
If I want to get that column back,
I can put my mouse
right in between those two columns
and double-click.
It's going to bring that column back.
If I have multiple hidden columns,
I'll right-click this one,
and choose Hide.
And maybe I want to hide their address also.
I'll also right-click this one and choose Hide.
They certainly don't have to be next to each other.
If I want to bring back all of them,
I can select everything
by clicking right in the top-leftmost column
of the spreadsheet.
From here, all I have to do
is double-click between any column
and it's going to bring them all back.