Inserts a blank cell or range of cells or pastes cells from the Clipboard into a sheet. Shifts the selected cells to accommodate the new ones. The size and shape of the inserted range are the same as those of the current selection.
Syntax
INSERT(shift_num)
INSERT?(shift_num)
Shift_num is a number from 1 to 4 specifying which way to shift the cells. If an entire row or column is selected, shift_num is ignored. If shift_num is omitted, Microsoft Excel shifts cells in the logical direction based on the selection.
| Shift_num | Direction |
| 1 | Shift cells right |
| 2 | Shift cells down |
| 3 | Shift entire row |
| 4 | Shift entire column |
Remarks
If you have just cut or copied information to the Clipboard, INSERT performs both an insert and a paste operation. First, Microsoft Excel inserts new blank cells into the sheet; then, Microsoft Excel pastes information from the Clipboard into the newly inserted cells. If you have used the INSERT function in macros written for Microsoft Excel version 2.2 or earlier, make sure you consider this feature when you use your old macros with later versions of Microsoft Excel.
Related Functions
COPY Copies and pastes data or objects
CUT Cuts or moves data or objects
EDIT.DELETE Removes cells from a sheet
PASTE Pastes cut or copied data
Return to index