Copyright (c) Newday Com. Ltd. All rights reserved-2001-2008
 

                                  

By the end of this lesson, learners should be able to:

  • Insert rows and columns
  • Delete rows and columns

Inserting a row

You can insert a row in a spreadsheet anywhere you need it. Excel moves the existing rows down to make room for the new one.

To Insert a Row:
  • Click anywhere in the row below where you want to insert the new row.
  • Choose Insert Rows from the menu bar.

    Insert and Rows Menu Selections
  • A new row is inserted above the cell(s) you originally selected.

OR

  • Click anywhere in the row below where you want to insert the new row.
  • Right-click and choose Insert from the shortcut menu.

    Insert Option on Shortcut Menu
  • The Insert dialog box opens.

    Insert Dialog Box
  • Choose the Entire Row radio button.
  • Click the OK button.
  • A new row is inserted above the cell(s) you originally selected.

    New Row Inserted into Spreadsheet

Select multiple rows before choosing Insert to add rows quickly. Excel inserts the same number of new rows that you originally selected.

Inserting a column

In Excel, you can insert a column anywhere you need it. Excel moves the existing columns to make room for the new one.

To Insert a Column:
  • Click anywhere in the column where you want to insert a new column.
  • Choose Insert Columns from the menu bar.

    Insert and Columns Menu Selections
  • A new column is inserted to the left of the existing column.

OR

  • Click anywhere in the column where you want to insert a new column.
  • Right-click and choose Insert from the shortcut menu.

    Insert Selection on Shortcut Menu
  • The Insert dialog box opens.

    Insert Dialog Box
  • Click the Entire Column radio button in the Insert dialog box.
  • Click the OK button.
  • A new column is inserted to the left of the existing column.

    Column Inserted into a Spreadsheet

You can also select multiple columns before choosing Insert to add columns quickly. Excel inserts the same number of new columns that you originally selected.

Deleting columns and rows

Columns and rows are deleted in much the same manner as inserting columns and rows.

To Delete a Row and All Information in It:
  • Select a cell in the row to be deleted.
  • Choose Edit Delete from the menu bar.
  • Click the Entire Row radio button in the Delete dialog box.

    Delete Dialog Box
  • Click the OK button.
To Delete a Column and All Information in it:
  • Select a cell in the column to be deleted.
  • Choose Edit Delete from the menu bar.
  • Click the Entire Column radio button in the Delete dialog box.

    Delete Dialog Box
  • Click the OK button.

Challenge!

  • Open your Monthly Budget file.
  • Delete the blank Column B.

    After you delete the blank Column B it may look like this:

     

    Delete Column B

     

  • Save and close the document.

NOTICE BOARD 1
 Student should make sure to login to class discussion board to view the neccessary information about his or her progress.
 Don,t forget to log out when you are about to leave the class

NOTICE BOARD 2
Students Should not forget to send his or her registration password and User name to newday.com@gmail.com
For future refrence.
NOTICE BOARD 3
Student should make sure to subscribe to newsletter of this site for useful information.
MORE ADVANCE COURSE
 Microsoft Access
 Peachtree Account
 Adobe Photoshop
 Programming
ENGINNERING COURSE
 Café Management
 Repair and Maintenance
 Electronic Basic
 Networking
 

=> Do you also want a homepage for free? Then click here! <=