Excel.ChangeDirectionState interface
Represents the direction that existing or remaining cells in a worksheet will shift when cells are inserted into or deleted from a worksheet.
Remarks
Properties
delete |
Represents the direction (such as up or to the left) that the remaining cells will shift when a cell or cells are deleted. Note: |
insert |
Represents the direction (such as down or to the right) that the existing cells will shift when a new cell or cells are inserted. Note: |
Property Details
deleteShiftDirection
Represents the direction (such as up or to the left) that the remaining cells will shift when a cell or cells are deleted. Note: insertShiftDirection
and deleteShiftDirection
are exclusive and both enums can't have a value at the same time. If one has a value, then the other will return undefined
.
deleteShiftDirection: Excel.DeleteShiftDirection | "Up" | "Left";
Property Value
Excel.DeleteShiftDirection | "Up" | "Left"
Remarks
insertShiftDirection
Represents the direction (such as down or to the right) that the existing cells will shift when a new cell or cells are inserted. Note: insertShiftDirection
and deleteShiftDirection
are exclusive and both enums can't have a value at the same time. If one has a value, then the other will return undefined
.
insertShiftDirection: Excel.InsertShiftDirection | "Down" | "Right";
Property Value
Excel.InsertShiftDirection | "Down" | "Right"
Remarks
Office Add-ins