MS Excel 2007 - Lesson 10: Modify columns, rows and cells

When you open a new blank workbook in Excel 2007, cells, columns, and rows are set to default sizes. You can change the size of each cell, column and row, as well as insert new columns, rows and cells if needed. In this lesson, you will learn different methods to modify column width and row height, as well as how to insert new columns, rows and cells.

Modify column width

1. Position the cursor on the column row in the column heading and a double arrow will appear.

MS Excel 2007 - Lesson 10: Modify columns, rows and cells Picture 1

1. Modify column width
2. Left click, then drag the cursor to the right to increase the column width or left to reduce the column width.
3. Release the mouse.

OR

1. Left click on the column header of the column you want to modify. The entire column will appear highlighted.

MS Excel 2007 - Lesson 10: Modify columns, rows and cells Picture 2

1. Click the Format command in the Cells group on the Home tab . A menu will appear.

MS Excel 2007 - Lesson 10: Modify columns, rows and cells Picture 3

1. Select Column Width to enter a specific column size.
2. Select AutoFit Column Width to adjust the column so that its width fits all text in it.

If you see a pound sign (#######) in a cell, it means that the column is not wide enough to display the content contained therein. At that time, you just need to increase the column width to display the cell contents.

Modify row height

1. Position the cursor on the row you want to modify and a double arrow will appear.

MS Excel 2007 - Lesson 10: Modify columns, rows and cells Picture 4

1. Left click, then drag the cursor up to reduce the row height or down to increase row height.
2. Release the mouse.

OR

1. Click the Format command in the Cells group on the Home tab . A menu will appear.

MS Excel 2007 - Lesson 10: Modify columns, rows and cells Picture 5

1. Select Row Height to enter a specific row size.
2. Select the AutoFit Row Height to adjust the row width to fit the entire text contained in it.

Insert rows

1. Select the item below where you want the new item to appear.
2. Click the Insert command in the Cells group on the Home tab . New item will appear.

MS Excel 2007 - Lesson 10: Modify columns, rows and cells Picture 6

New items always appear above the selected row.

Make sure you select the entire row below where you want the new item to appear, not just the cell. If you only select the box and then click Insert, only a new cell will appear.

Insert column

1. Select the column to the right where you want the column to appear.
2. Click the Insert command in the Cells group on the Home tab . A new column will appear.

New columns always appear on the left of the selected column. For example, if you want to insert columns between September and October, select the October column , then click the Insert command .

MS Excel 2007 - Lesson 10: Modify columns, rows and cells Picture 7

Make sure you select the entire column to the right where you want the new column to appear, not just one cell. If you select only one cell and then click Insert, only a new cell will appear.

Delete rows and columns

1. Select the row or column you want to delete.
2. Click the Delete command in the Cells group on the Home tab .

Practice!

1. Use the workbook Budget or any Excel workbook you have to complete this practice.
2. Open a workbook.
3. Insert a column.
4. Insert a row.
5. Delete a column.
6. Change the width of the column with AutoAdjust.
7. Change the height of a row.
8. Close and save the file.

>> Next lesson: MS Excel 2007 - Lesson 11: Format the text