From the course: Excel 2016 Essential Training

Unlock the full course today

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

Inserting and deleting rows and columns

Inserting and deleting rows and columns

From the course: Excel 2016 Essential Training

Start my 1-month free trial

Inserting and deleting rows and columns

“

- There many different situations when you're working with Excel where you need to change the layout of a worksheet. Maybe you want to put it in a new column or a new row or in some cases, delete a column or a row. You can do that relatively easy and quickly. You can also at different times simply add cells, push data down. You can delete cells. We can do this across rows or across columns. In this particular worksheet called Insert-Delete. It's in our file called 05 - Layout. Maybe we've decided that we need to keep track of people by their status. In other words, maybe some of these people are part time, and we don't see that in the list here. And we want a new column to the left of Column D. Now if you didn't know how to insert a new column, you might begin by clicking the column, but then what? On the Home tab, there's a choice called Insert, and that's certainly helpful. We could Insert Sheet Sheet Columns. We could click that. And nothing wrong with that, and I'm certainly not…

Contents