Microsoft Office Tutorials and References
In Depth Information
You can use AutoSum to calculate other summary values, such as the average, mini-
mum, maximum, and total number of items in a cell range. You will learn more about
using AutoSum to summarize values in Tutorial 2.
Working with Rows and Columns
Sandra has received a new order that she wants you to add to her worksheet. She wants to
insert the new order right after Jerry Dawson’s order, but wants to make sure the row con-
taining the total values is still the last row. To do this, you need to insert a new row into
the worksheet between row 9 and row 10.
Inserting a Row or Column
You can insert rows and columns in a worksheet, or you can insert individual cells within
a row or column. When you insert rows, Excel shifts the existing rows down. When you
insert columns, Excel shifts the existing columns to the right. If you insert cells within a
row, Excel shifts the existing cells down; if you insert cells within a column, Excel shifts
the existing cells to the right. Figure 1-27 illustrates what happens when you insert a row,
a column, and cells within a row and within a column.
Inserting new rows and columns
original layout of cells
inserting a new row 4
inserting new cells in row 4
inserting a new column D
inserting new cells in column D
You can use the Insert menu to insert cells, rows, and columns. You can also use the
right-click method to display a shortcut menu that provides the Insert command, which
opens the Insert dialog box.