From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Insert and delete columns, rows, and cells

Insert and delete columns, rows, and cells

From the course: Cert Prep: Excel Associate - Microsoft Office Specialist for Office 2019

Start my 1-month free trial

Insert and delete columns, rows, and cells

“

- [Instructor] When we're developing our worksheets in our workbooks, a lot of times, we need to insert, or delete columns, rows, and cells. After watching this video, you'll know how to insert columns, delete rows, and how you can insert or delete cells within your data. Let's jump right into our Insert Delete workbook. On our Products table, I would like to insert two columns, just to the right of Product. Now there's a couple of ways that I can do that. I can simply select Column C and D, because I want to insert two columns, I'll select two columns and that's the number that will be inserted. Right-click on the selection and go to Insert and see how quickly those were inserted? Now we also can select a column, and on my Home ribbon, click on Insert, and I can insert sheet columns, and in it goes. Now what if I want to delete a column? I've added one too many here, so this is a great chance for me to show you how easy it is to remove it. With Column E selected, I'll right-click and…

Contents