Microsoft Office Tutorials and References
In Depth Information
• Right-click row heading 24 and
then click Insert on the shortcut
menu to insert a new row in the
• Click cell A24 in the new row and
then enter Revenue for Bonus
as the row title (Figure 3–16).
row title Revenue
for Bonus entered
in new row
What would happen if cells in
the shifted rows are included in
If the rows that are shifted down
include cell references in formulas
located in the worksheet, Excel
automatically adjusts the cell
references in the formulas to
their new locations. Thus, in Step 2,
if a formula in the worksheet
references a cell in row 21 before
the insert, then the cell reference
in the formula is adjusted to row 22
after the insert.
original row 24
1. On Home tab on Ribbon,
click Insert, click Insert
2. Press CTRL + SHIFT + PLUS SIGN ,
click Entire Row, click OK
You insert columns into a worksheet in the same way you insert rows. To insert
columns, select one or more columns immediately to the right of where you want Excel
to insert the new column or columns. Select the number of columns you want to insert.
Next, click the Insert tab on the Ribbon and then click Insert Sheet Rows in the Insert
gallery or click Insert on the shortcut menu. The Insert command on the shortcut menu
requires that you select an entire column (or columns) to insert a column (or columns).
Following the insertion of a column, Excel displays the Insert Options button, which
allows you to modify the insertion in a fashion similar to that discussed earlier when
You can move and insert
a selected cell or range
between existing cells by
holding down the SHIFT
key while you drag the
selection to the gridline
where you want to insert.
You also can copy and
insert by holding down
the CTRL + SHIFT keys while
you drag the selection to
the desired gridline.
The Insert command on the shortcut menu or the Cells command on the Insert gallery
of the Insert button on the Ribbon allows you to insert a single cell or a range of cells. You
should be aware that if you shift a single cell or a range of cells, however, it no longer may
be lined up with its associated cells. To ensure that the values in the worksheet do not get
out of order, it is recommended that you insert only entire rows or entire columns. When
you insert a single cell or a range of cells, Excel displays the Insert Options button so that
you can change the format of the inserted cell, using options similar to those for inserting
rows and columns.
The Insert Options
When you insert
columns or rows, Excel
only displays the Insert
Options button if formats
are assigned to the
leftmost column or top
row of the selection.