Insert, delete, hide, and unhide columns and rows

- [Instructor] On the home tab in the ribbon,…there are any number of different choices…off to the right for inserting cells, rows, columns,…even sheets and a similar set for delete…and also a set of choices related to format.…Many many times you don't have to use these…buttons at all, there are faster methods…usually involving either keystroke shortcuts…or using the right mouse button.…In this worksheet called HR List, it's the first…sheet in our chapter eight file,…I want to create a new column to the left of column F.…

I'll simply right click column F and insert.…Notice you don't see three dots behind this…that means there's nothing else to do.…Insert automatically means a column if we've…right clicked on a column letter…and there we see the new column.…As it turns out, I don't need that so I'll come back…a few minutes later perhaps, right click,…I don't need that, delete.…Now there could be times, maybe there's data…off to the right in this worksheet,…there is, if I forget about this, if I right click…row four because I want to put in some new data here,…