Merge cells
The Google Sheets Merge Cells tool simplifies data management by allowing users to combine multiple adjacent cells into a single cell. This functionality enhances spreadsheet organization and readability, making it ideal for reporting and data presentation.
Features
- Merge a specified range of cells into one unified cell.
- Supports merging all cells, only columns, or only rows within the selected range.
- Seamlessly integrates with Google Sheets via API for automated workflows.
- Easy selection of drive, spreadsheet, and worksheet to target the merge operation.
- Comprehensive documentation available for implementation and customization.
Benefits
- Improves spreadsheet clarity by reducing clutter and consolidating data.
- Saves time by automating the cell merging process in bulk.
- Enhances the visual structure of reports and dashboards.
- Facilitates better data presentation for collaborative work environments.
- Reduces manual errors compared to hand-merging cells in spreadsheets.
Description
Merge a range of cells into a single cell. See the documentation
Parameters
5 parameters
| Name | Type | Description |
|---|---|---|
| drive | string | Defaults to You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-merge-cells, propName: drive. |
| sheetIdrequired | string | Select a spreadsheet or provide a spreadsheet ID You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-merge-cells, propName: sheetId. |
| worksheetIdrequired | integer | Select a worksheet or provide a worksheet ID You can use the "retrieve_options" tool using these parameters to get the values. key: google_sheets-merge-cells, propName: worksheetId. |
| rangerequired | string | The range of cells to apply validation (e.g., |
| mergeTyperequired | enum | The type of merge to perform |