Microsoft Office Tutorials and References
In Depth Information
Inserting and Deleting Cells in a Worksheet
• If you are using a touch screen,
tap row heading 19, the row
below where you want to
insert a row, twice, to display a
• If you are using a mouse,
rightclick row heading 19, the row
below where you want to insert a
row, to display the shortcut menu
and the mini toolbar.
• Tap or click Insert on the context
menu or shortcut menu to insert a
new row in the worksheet.
• Tap or click the Insert Options
button below row 19 and tap or
click ‘Format Same As Below’ on the menu.
• Select cell A19 in the new row and then type Margin to enter a new row title
(Figure 3 – 16).
row title, Margin,
entered in new row
Excel inserts new row
down one row
Figure 3 – 16
For a complete list of the Q&As
found in many of the step-by-
step sequences in this topic,
visit the Q&A resource on
the Student Companion Site
located on www.cengagebrain
.com. For detailed instructions
about accessing available
resources, visit www.cengage
contact your instructor for
information about accessing
the required les.
What would happen if cells in the shifted rows were included in formulas?
If the rows that shift down included cell references in formulas located in the
worksheet, Excel automatically would adjust the cell references in the formulas to their
new locations. Thus, in Step 2, if a formula in the worksheet referenced a cell in row 19
before the insert, then Excel would adjust the cell reference in the formula to row 20
after the insert.
1. Tap or click Insert Cells arrow (HOME tab | Cells group), tap or click
‘Insert Sheet Rows’
2. Press CTRL + SHIFT + PLUS SIGN , tap or click Entire row (Insert dialog box),
tap or click OK button
If you want to insert multiple
rows, you have two choices.
You can insert a single row by
using the Insert command on
the shortcut menu and then
repeatedly press the F 4 key
to continue inserting rows.
Alternatively, you can select any
number of existing rows to choose
the number of rows that you
want to insert. For instance, if you
want to insert ve rows, select ve
existing rows in the worksheet,
press and hold or right-click the
selected rows, and then tap or
click Insert on the shortcut menu.
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, tap or click the Insert arrow (HOME tab | Cells group), and then tap or click
‘Insert Sheet Columns’ in the Insert list; or press and hold or right-click the selected
column(s) and then tap 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 inserting rows.
Inserting Single Cells or a Range of Cells
You can use the Insert command on the shortcut menu or the Insert Cells command
on the Insert menu — produced by tapping or clicking the Insert button (HOME tab |
Cells group) — 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 lines up with its associated cells.
To ensure that the values in the worksheet do not get out of order, spreadsheet experts
recommend 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.
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 the selected cell or range.
You also can copy and insert by
holding down the CTRL + SHIFT keys
while you drag the selection to the