Programs: Microsoft Excel: Lesson 4


Lesson 4:  In this lesson, we will learn how to add and delete rows, columns, and entire worksheets.
Lesson 4: Objectives:
  • Adding Rows and Columns
  • Deleting Rows and Columns
  • Adding and Deleting Entire Worksheets
Lesson 4: Adding and Deleting in Microsoft Excel
Objective # 1- Adding Rows and Columns How can we add a row or a column?

To Add Rows or Columns:

Go to Insert

Click on either Row or Column

Careful: One should be very careful to place the inserted row or column in the actual row or column that you want to put it into.
Objective # 2- Deleting Rows and Columns How to Delete Rows and Columns

To delete rows or columns:

Right click the mouse button

Click on Delete

Click on the Entire Row or Entire Column

 
Objective # 3 - Adding an Entire Worksheet How to add an entire worksheet
This picture shows the process of inserting an entire new worksheet.  The process entails clicking on Insert and then clicking Worksheet.

 

 

Objective # 4 - Deleting an Entire Worksheet How to delete an entire worksheet

This picture shows the process of deleting an entire worksheet.  The user should click on Edit and go down to Delete Sheet.

 

 

 

 

Lesson Review

In this lesson, we covered the following:
  •  How to add columns and rows through "Insert"
  • How to delete columns and rows through "Delete"
  •  How to add and delete entire worksheets through "Edit" or "Delete"

Back to Lesson 3

Continue to Lesson 5

Back to Lessons 


Programs: Microsoft Excel: Lesson 4