Microsoft Office Tutorials and References
In Depth Information
Inserting and Deleting Cells in a Worksheet
BTW
Cutting
When you cut a cell or range of
cells using the Cut command
on a shortcut menu or Cut
button (HOME tab | Clipboard
group), Excel copies the cells to
the office Clipboard; it does not
remove the cells from the source
area until you paste the cells in
the destination area by either
tapping or clicking the Paste
button (HOME tab | Clipboard
group) or pressing the ENTER key.
When you complete the paste,
Excel clears the cell’s or range of
cell’s entries and their formats
from the source area.
Using Cut and Paste to Move Cells
Another way to move cells is to select them, tap or click the Cut button (HOME
tab | Clipboard group) (Figure 3 – 12 on page EX 141) to remove them from the
worksheet and copy them to the office Clipboard, select the destination area, and then tap
or click the Paste button (HOME tab | Clipboard group) or press the key. You also
can use the Cut command on the shortcut menu, instead of the Cut button on the ribbon.
Inserting and Deleting Cells in a Worksheet
At any time while the worksheet is on the screen, you can insert cells to enter new
data or delete cells to remove unwanted data. You can insert or delete individual cells;
a range of cells, rows, or columns; or entire worksheets.
1 ENTER HEADINGS & DATA | 2 ENTER FORMULAS & FUNCTIONS | 3 CREATE SPARKLINE CHARTS
4 FORMAT WORKSHEET | 5 CREATE COLUMN CHART | 6 CHANGE VIEWS | 7 ASK WHAT - IF QUESTIONS
To Insert a Row
Why? According to the sketch of the worksheet in Figure 3 – 3a on page EX 133, two rows must be inserted in the
What-If Assumptions table, one above Bonus for the Margin assumption and another between Bonus and Commission for
the Sales Revenue for Bonus assumption. The following steps insert the new rows into the worksheet.
1
If you are using a touch screen,
tap row heading 20, the row
below where you want to insert
a row, twice, to display a shortcut
menu.
shortcut menu
Insert command
If you are using a mouse,
rightclick row heading 20, the row
below where you want to insert
a row, to display the shortcut
menu and the mini toolbar
(Figure 3 – 14).
mini toolbar
row heading 20
Figure 3 – 14
2
Tap or click Insert on the shortcut
menu to insert a new row in the
worksheet by shifting the selected
row and all rows below it down
one row.
Select cell A20 in the new row
and then type Sales Revenue
for Bonus to enter a new row
title (Figure 3 – 15).
row title, Sales
Revenue for Bonus,
entered in new row
Excel inserts new row
original row
20 shifted
down one row
What is the resulting format of
the new row?
The cells in the new row inherit
the formats of the cells in the
row above them. You can change
this behavior by tapping or clicking the Insert Options button that appears immediately below the inserted row.
Following the insertion of a row, the Insert Options button allows you to select from the following options: (1)
‘Format Same As Above’, (2) ‘Format Same As Below’, and (3) Clear Formatting. The ‘Format Same as Above’ option
is the default. The Insert Options button remains active until you begin the next Excel operation. Excel does not
display the Insert Options button if the initial row does not contain any formatted data.
Figure 3 – 15
 
Search JabSto ::




Custom Search