Microsoft Office Tutorials and References
In Depth Information
You can insert multiple nonadjacent cells when you use the Insert command, but only
when inserting blank cells. Inserting nonadjacent cut or copied cells is not allowed.
Inserting copied or cut cells
Often, you need to copy or move existing data to the middle of another area of existing
data, moving other data out of the way in the process. You can do this the hard way by
inserting just the right amount of space in the destination area and then copying or cutting
cells and pasting them to the new location. However, it’s much easier to click Home, Insert,
Insert Copied Cells or Insert Cut Cells because this handles all these actions for you. These
commands appear on the Insert menu (or on the shortcut menu) only when you copy or
cut some cells. Sometimes it’s obvious what needs to happen. For example, if you cut an
entire row, you’ll surely want to insert the entire row somewhere else. In these cases, Excel
employs some common-sense rules and executes the action without hesitation. If Excel
needs more information about how to adjust the worksheet, it opens the Insert Paste
dialog box shown in Figure 8-11.
Figure 8-11 When you insert after copying or cutting cells, the Insert Paste dialog box appears.
For example, you can use cutting and inserting to add rows for more data in Figure 8-11 by
copying the rows containing 2013 data and editing the contents, thereby saving yourself
some unnecessary typing. To do so, select cells A6:F9 and press Ctrl+C to copy the range.
Then click Home, Insert, Insert Copied Cells to display the Insert Paste dialog box. Then