Small changes in the layout of your worksheet can give you big improvements in readability. Insert and delete rows, columns, and cells to organize your worksheet.
Insert a column
Select the letter at the top of a column to select the column.
Select Home > Insert > Insert Sheet Columns
Or, right-click the top of the column, and then select Insert.
Note: Excels inserts a new column to the left.
Delete a column
Select the column.
Select Home > Delete > Delete Sheet Columns.
Or, right-click the top of the column, and then select Delete.
Insert a row
Select the row number to select a row.
Select Home > Insert > Insert Sheet Rows.
Or, right-click the selected row, and then select Insert.
Note: A new row is inserted above the selected row.
Delete a row
Select the row.
SelectHome > Delete > Delete Sheet Rows.
Or, right-click the selected row, and then select Delete.
Insert a cell
Select a cell or a cell range.
Right-click the selected cells, and then select Insert.
In the Insert box, select an option:
Shift cells right – shifts cells right to make space for the new cell(s).
Shift cells down – shifts cells down to make space for the new cell(s).
Entire row – inserts a new row.
Entire column – inserts a new column.
In this worksheet, this is a projection for the year 2016.
And we see some numbers here.
We might want to experiment with these and have another copy of this same layout with formulas down below.
Using the slider bar in the lower right-hand corner, I'm gonna zoom back a little bit, we've got other data off to the right that we'll get to. I'd like to copy this data down to Row 17.
Now, a familiar technique for a lot of people is to Copy this data and then Paste it.
And there's certainly nothing wrong with that.
And there are any number of different ways to do this.
We've got buttons here on the Home Tab.
Some people are familiar with Ctrl+C to copy.
Ctrl+V to paste, you can certainly do that. But you can also drag data.
And often that's gonna be the fastest. I simply want to copy this data down in Row 17.
Now, if I wanted to move it, based on the layout we're seeing that's probably not likely, but I can, after selecting the data, simply drag any edge. Drag it down here. I've moved the data.
I didn't really wanna do that though so I'll press Ctrl+Z. But that's very easy to do.
And often, it's gonna be the fastest way unless you're moving the data, for example, hundreds of rows or columns downward or rightward.
If we like to make a copy of this, we do almost the same thing but we hold down the CTRL key.
You don't have to hold it down immediately, but as you're holding it down, eventually, you'll see a tiny little plus that accompanies the arrow as you drag this.
Drag it down to here. Be sure to let go of the mouse first.
We've made a copy of it. And the formulas up here, as I Zoom back a little bit. Again.
The formulas up here for example, that deal with Rows 4 and 5, are automatically copied down here so that they're dealing with data in Rows 19 and 20.
So, we don't worry about our formulas as we do this.
We've made a copy of it. And maybe we're experimenting with some different numbers here in our projections.
That could be one of the reasons for copying the data.
In Excel, you can Insert, in other words Move and Insert at the same time.
Now, if you don't know the shortcut, what you can do here is right-click Row 10, add a new row, Move the data up then get rid of the empty row and Sum.
Might take a little bit of time. Now, what we're about to do, we could do for an entire row.
However, there's data off to the right. We don't want to disturb that.
So, we'll simply highlight these Cells right here.
And if we'd like to Move them upward, all we've got to do is to drag the top edge here with the Shift key held down. Drag it up to there. Let go of the mouse first. We've moved the data.
All of our formulas get readjusted properly where necessary. Everything is working just fine.
And we can do this with column data as well. Either Entire Columns or just Cells.
We've decided, for whatever reason, it's gonna make sense to put the department to the left of the building.
So, we click the Column for Department. The entire column this time.
We will be dragging the left edge with the Shift key held down.
Drag it leftward to here.
Let go of the mouse.
And we've done that.
Learning doesn't stop here. Discover more expert led tutorials at LinkedIn Learning. Start your free trial today, at linkedin.com/learning.
Learn from recognized industry experts, and get the business, tech, and creative skills that are most in demand.
Get unlimited access to over 4,000 video courses.
Receive personal recommendations based on your LinkedIn profile.
Stream courses from your computer or mobile device.
Take courses for every level – beginner to advanced.
Practice while you learn with quizzes, exercise files, and coding windows.
Choose a plan for yourself or your entire team.