Excel: Deleting and Inserting Columns and Rows

1. Excel: Deleting and Inserting Columns and Rows Computer Information Technology Section 6-8 • Some text and examples used with permission from: • http://www.jegsworks.com • Note: We are not endorsing or promoting religious doctrine, but simply taking advantage of this website for educational purposes.

2. Excel: Deleting a row or column • Select the row or column by clicking on the row or column header. Click the row heading to select the row Click the column heading to select the column

3. Excel: Deleting a row or column • Once the row or column is selected either choose Delete from the Cells group on the Home tab • Or right click and select Delete

4. Excel: Inserting a column • Select column to the right of where you want the new column to appear • Click Insert Sheet Columns in the Cells group on the Home tab If you want to insert a column between Columns C and D, click the column heading for Column D

5. Excel: Inserting a column • The result is a blank column

6. Excel: Inserting a row • Select row below where you want the new row to appear • Click Insert Sheet Rows in the Cells group on the Home tab If you want to insert a row between row 6 and 7, click the row heading for row 7

7. Excel: Inserting multiple rows or columns • To insert multiple rows or columns simply highlight the number of rows or columns and choose Insert.

8. Rest of Today • Do Homework 6-8 from the Hancock website • If you finish do at least 15 minutes of Mavis Beacon