Microsoft Office Tutorials and References
In Depth Information
Inserting and Deleting Cells in a Worksheet
Using Cut and Paste to Move Cells
Another way to move cells is to select them, click the Cut button (Home tab |
Clipboard group) (Figure 3 – 12 on page EX 151) to remove them from the worksheet and
copy them to the Ofi ce Clipboard, select the destination area, and then click the Paste
button (Home tab | Clipboard group) or press the enter key. You also can use the Cut
command on the shortcut menu, instead of the Cut button.
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 Ofi ce
Clipboard, but does not
remove the cells from the
source area until you paste
the cells in the destination
area by either 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.
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, columns; or entire worksheets.
To Insert a Row
According to the sketch of the worksheet in Figure 3 – 3a on page EX 142, two rows must be inserted in the
What-If Assumptions table, one between Commission and Marketing for the Margin assumption and another
between Research and Development and Support, General, and Administrative for the Sales Revenue for Bonus
assumption. The following steps insert the new rows into the worksheet.
1
Right-click row
heading 4, 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 4
shortcut menu
Insert command
Figure 3 –14
 
Search JabSto ::




Custom Search