Note

Access to this page requires authorization. You can try signing in or .

Access to this page requires authorization. You can try .

Excel.InsertShiftDirection enum

Package:
excel

Determines the direction in which existing cells will be shifted to accommodate what is being inserted.

Remarks

API set: ExcelApi 1.1

Used by

Examples

// Link to full sample: https://raw.githubusercontent.com/OfficeDev/office-js-snippets/prod/samples/excel/42-range/insert-delete-clear-range.yaml

await Excel.run(async (context) => {
 const sheet = context.workbook.worksheets.getItem("Sample");
 const range = sheet.getRange("B4:E4");

 range.insert(Excel.InsertShiftDirection.down);
 
 await context.sync();
});

Fields

down = "Down"
right = "Right"

Feedback

Was this page helpful?