Skip to main content

UnMerge

Splits the selected merged cell range into the single cells.

Syntax​

expression.UnMerge();

expression - A variable that represents an ApiRange class.

Parameters​

This method doesn't have any parameters.

Returns​

boolean

Example​

Split a previously merged cell range back into individual cells in a spreadsheet.

// How do I separate merged cells into single cells in a spreadsheet?

// Undo a cell merge so each address in the range becomes its own independent cell in a spreadsheet.

let worksheet = Api.GetActiveSheet();
worksheet.GetRange("A3:E8").Merge(true);
worksheet.GetRange("A5:E5").UnMerge();