# SpreadsheetMergeCells

Merges a rectangular block of two or more Excel spreadsheet object cells.

## Method Signature

```
SpreadsheetMergeCells(spreadsheetObj=[any], startRow=[any], startColumn=[any], endRow=[any], endColumn=[any])
```

### Arguments

| Argument         | Type      | Required | Description                           | Default |
| ---------------- | --------- | -------- | ------------------------------------- | ------- |
| `spreadsheetObj` | `ANY`     | `true`   | The spreadsheet object.               |         |
| `startRow`       | `NUMERIC` | `true`   | The starting row number (1-based).    |         |
| `startColumn`    | `NUMERIC` | `true`   | The starting column number (1-based). |         |
| `endRow`         | `NUMERIC` | `true`   | The ending row number (1-based).      |         |
| `endColumn`      | `NUMERIC` | `true`   | The ending column number (1-based).   |         |

## Examples

Merge cells for titles:

```js
// Merge cells A1:D1 for title
var spreadsheet = SpreadsheetNew();
SpreadsheetAddRow( spreadsheet, [ "Report Title", "", "", "" ] );

SpreadsheetMergeCells( spreadsheet, 1, 1, 1, 4 );
SpreadsheetFormatCell( spreadsheet, 1, 1, { bold = true, alignment = "center" } );
```

## Related

* [SpreadsheetFormatCell()](https://boxlang.ortusbooks.com/boxlang-framework/boxlang-plus/modules/bx-spreadsheet/reference/built-in-functions/spreadsheetformatcell) - Format cell
* [SpreadsheetFormatCellRange()](https://boxlang.ortusbooks.com/boxlang-framework/boxlang-plus/modules/bx-spreadsheet/reference/built-in-functions/spreadsheetformatcellrange) - Format range
* [Formatting Guide](https://boxlang.ortusbooks.com/boxlang-framework/boxlang-plus/modules/bx-spreadsheet/formatting) - Cell styling