From the course: Excel 2013 Essential Training
Join today to access over 22,500 courses taught by industry experts or purchase this course individually.
Inserting and deleting rows and columns - Microsoft Excel Tutorial
From the course: Excel 2013 Essential Training
Inserting and deleting rows and columns
We're reviewing the worksheet called Insert-Delete within the file 05-Layout, and we need to add a new column, a Phone Number column between Columns C and D. When you insert columns in Excel, select the column to the right of where the new column is going to appear. Now, using the standard menu techniques we can go on the Home tab to the Cells Group and choose Insert and simply Insert Sheet Columns; and we automatically get a new column to the left. All the other data gets pushed to the right. And so I'll put in our Phone Number heading here and then eventually we'll fill in the details. We can also insert rows in a similar way. It's often going to be handier to use the right mouse button. Suppose we also need to add a Social Security column, we could right-click Column D and simply choose Insert. Notice that it doesn't say Columns but by implication that's what it means because we've right-clicked on a column-- Insert, and there's a new column--and eventually maybe we'll put in a…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.