As a member, you'll also get unlimited access to over 75,000 lessons in math, English, science, history, and more. Plus, get practice tests, quizzes, and personalized coaching to help you succeed.
Try it risk-freeAlready registered? Log in here for access
Karen has a Bachelors in Communications. She has 25 years of experience in Information Systems, Adult Learning and Virtual Training.
When working with an Excel worksheet, it's not uncommon to find yourself needing to add or remove a cell or range of cells. You may forget to add something, need to reorganize the spreadsheet or decide to remove certain data in the worksheet. Insert means to add a cell or range of cells. Delete means to remove a cell or range of cells. This lesson will guide you through the steps to inserting or deleting cells when working on Excel spreadsheets.
As with most software programs, there is more than one way to complete the task of inserting and deleting cells in Excel. The Insert and Delete commands can be found in two places: you can find them under the Home menu in the ribbon or with a right-click of your mouse. Let's take a look at an example using the ribbon commands.
Imagine you have a teenager in high school. This is Amanda's freshman year, and she has decided she wants to play hockey. The coach sent you an email detailing the costs for Amanda to play. You decided to put together a spreadsheet with equipment, ice-time and fees showing the cost associated with each item. You have highlighted your costs in red, the school's in black. At the bottom, you have a total for the entire list.
 |
Now you want to add a cell above the total and add a sub-total for the items in red, or the cost to you as the parent. Let's review the steps:
Let's choose to Shift Cells Down. This will add the cell for the sub-total directly above the total for all costs.
To remove a cell or range of cells, you would use the Delete command in the ribbon and the steps would be similar. From the Home menu in the ribbon, open the Delete cells dialogue box and choose one of the following:
Inserting and deleting a cell or range of cells can also be accomplished by using the right-click method. Not everyone is as comfortable working with their mouse, but I find these steps quicker. If you right-click where you want the cell or cells to be inserted, a drop-down menu with several menu options will appear. Notice you have both Insert and Delete among the options. These work the same as the ribbon commands.
Let's go back to our example spreadsheet with the list of hockey equipment and costs. Assume we need another sub-total, but this time for the school's cost. We will then have three totals: all costs, parents' cost and the school's cost. Here are the steps to using a right-click with your mouse:
Whether you use the ribbon commands or the right-click method, the options are the same. It depends on your preference and comfort level.
This lesson explained two ways to use the Insert and Delete commands in Excel. To add or remove a cell, you can go to the Home menu, look in the Cells grouping of commands and click on Insert to add or Delete to remove. You can also use the right-click method. Right-click where you want to add or remove a cell, and the drop-down menu includes the Insert and Delete commands. Mouse or ribbon commands, it's up to you!
Highlight the steps necessary for inserting and deleting in Excel using either the Cells grouping of commands or the right-click method after watching this video lesson.
To unlock this lesson you must be a Study.com Member.
Create your account
Already a member? Log In
BackAlready registered? Log in here for access
Did you know… We have over 200 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.
To learn more, visit our Earning Credit Page
Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.
Back To Course
Intro to Excel: Essential Training & Tutorials15 chapters | 70 lessons
{{courseNav.course.topics.length}} chapters | {{courseNav.course.mDynamicIntFields.lessonCount}} lessons | {{course.flashcardSetCount}} flashcard set{{course.flashcardSetCoun > 1 ? 's' : ''}}
Next Lesson
| 30 day money back guarantee | |||
|
Starting
Original Price |
/yr | /mo | |
| Just Just | /day | ||
| Discount For months |
- % - | / | |
| Referral Credit | - | ||
|
Price after trial Starting Price starting today |
/ | ||
| Referral Credit |
- | ||
| Price starting today | / | ||
| Just Just | Just Just | /day | |
| Save % off monthly plan | /mo | ||
| Just | /mo | ||
| Price | /yr | ||
Your Cart is Empty. Please Choose a Product.
Watch 5 minute video clips, get step by step explanations, take practice quizzes and tests to master any topic.
Study.com has a library of 450,000 question and answers for covering your toughest textbook problems
I love the way expert tutors clearly explains the answers to my homework questions. Keep up the good work!
- Maritess, College StudentStudy.com video lessons have helped over 30 million students.
"I learned more in 10 minutes than 1 month of chemistry classes"
- Ashlee P.
"I learned more in 10 minutes than 1 month of chemistry classes"
- Ashlee P.
"I aced the CLEP exam and earned 3 college credits!"
- Clair S.
Over 65 million users have prepared for {{displayNameByProductKey[registrationData.product || testPrepCocoon]}} and other exams on Study.com
"The videos have changed the way I teach! The videos on Study.com accomplish in 5 minutes what would take me an entire class."
- Chris F.
Over 65 million users have prepared for {{displayNameByProductKey[registrationData.product || testPrepCocoon]}} and other exams on Study.com
Over 65 million users have prepared for {{displayNameByProductKey[registrationData.product || testPrepCocoon]}} and other exams on Study.com
