eLearning Excel Introduction

eLearning Home

Excel Introduction

1. Unit 1: Getting Started
2. Unit 2: Entering and editing data
3. Unit 3: Modifying a Worksheet
   1. Moving and copying data
   2. Moving and copying formulas
   3. Inserting ranges
   4. Deleting ranges
   5. Unit 3 Practice Activity
4. Unit 4: Using Functions
5. Unit 5: Formatting Worksheets
6. Unit 6: Printing
7. Unit 7: Creating Charts

Deleting ranges

To delete rows or columns:

• Use Edit-Delete... or right-click in a column or row and select Delete from the menu, then select Row or Column
• Right-click on a row or column header and select Delete from the menu

Using the Edit menu Using the Edit menu:

Click in a row or column and right-click:

Select the row or column header and right-click:

Handy hint:

Delete multiple rows or columns by selecting more than one row or column header, rightclicking and selecting Delete from the menu.

Try it!

On Sheet 1 of Sales report.xls, delete Pam's information (row 6) from the spreadsheet, then use Undo to bring it back.

Insert three rows above the Totals row (row 8) at the bottom of the spreadsheet. These rows will display the data related to the three salespeople on Sheet 3 of Sales report.xls.

Move the data for the three salespeople on Sheet 3 into the appropriate positions in the three newly created rows in Sheet 1.

Use the Fill handle to copy down the formulas in columns D, G, and J.

Calculate the 'eligible for commission' Total for each salespeople in column K.

Use the Fill handle to copy down the formula in column L.

Save the changes made to Sales report.xls.