MS Excel 2007 - Lesson 5: Edit Worksheet: Insert Excel 2007 Row

Understanding Insert Excel 2007 row requires more than a headline. The overview below breaks down the key facts, changes, and user impact.

Below TipsMake. Com will guide each operation specifically for you to work on Excel 2007.

Insert Cells, Insert Rows / Rows, and Columns in Excel 2007

� Place the cursor on the LINE below where you want to insert a new LINE, or place the cursor on the left column where you want to insert a new column. � Click the Insert button on the Cells group of the Home tab

� Click the appropriate option to insert Cell (cell), Row (LINE) or Column (column)

MS Excel 2007 - Lesson 5: Edit Worksheet: Insert Excel 2007 Row � Insert Cells, Insert Rows / Rows, and Columns in Excel 2007

Delete Cells, Delete Rows / Lines and Delete Excel 2007 Columns

To delete cells, rows and columns:

� Place the cursor in the cell, row or column you want to delete

� Click the Delete button on the Cells group of the Home tab

� Click the appropriate option to delete: Cell, Row, or Column

MS Excel 2007 - Lesson 5: Edit Worksheet: Insert Excel 2007 Row � Delete Cells, Delete Rows / Lines and Delete Excel 2007

Find and Replace Data in Excel 2007

To find data or find and replace data:

� Click the Find & Select button on the Editing group of the Home tab, or press the Excel shortcut key combination + F

� Select Find or Replace

MS Excel 2007 - Lesson 5: Edit Worksheet: Insert Excel 2007 Row � Find and Replace Data in Excel 2007 (3)

� The Find and Replace dialog box appears, enter the Word you want to find in the Find What section (if you choose Find in the previous step) or enter the Word you want to find in the Find What section and the replacement Word in the Replace with section (if you select Replace at step on).

� Click the Options button to find more options

MS Excel 2007 - Lesson 5: Edit Worksheet: Insert Excel 2007 Row � Find and Replace Data in Excel 2007 (4)