Merging and Unmerging Cells in Spreadsheet Blocks
Merge cells to combine data or create headers, and unmerge them when you need to restore the original cell structure in your Spreadsheet Block.
Merging and unmerging cells
Learn how to merge and unmerge cells in your spreadsheet.
Use these techniques to create clear titles or combine related data into a single cell.
Steps to merge and unmerge cells
Identify cells to merge
Locate the area where you want to combine cells, such as a spreadsheet title that needs to be fully visible across multiple columns.Highlight the cell range
Click and drag to highlight the specific cells you want to merge (e.g., A1:E1).Apply the Merge action
In the toolbar, click the Merge button to combine the selected cells into one. The selected range will now appear as a single, unified cell.Select merged cell to unmerge
To reverse the action, click on the highlighted merged cell that contains your content.Unmerge the cells
Click the same Merge button in the toolbar again to unmerge the selection. The single cell will be split back into its original individual cells.Review the layout
Verify that the cells have returned to their original grid structure or remain merged as intended for your presentation.
FAQs
What does merging cells mean in the context of Spreadsheet Blocks?
Merging cells combines two or more adjacent cells into a single larger cell inside a QuoteCloud Spreadsheet Block. This is typically used to create clean titles or section headers and to visually group related data so your table layout is easier to read within your sales quotes and proposals.
How do I merge cells in a Spreadsheet Block?
Select the adjacent cells you want to combine, then choose the Spreadsheet Block’s Merge command from the toolbar or the cell context menu. The selected area will join into one region that behaves as a single, larger cell for display and formatting.
How does unmerging work?
Unmerging reverses a merge by splitting a merged region back into the original individual cells. After unmerging, each cell can hold its own separate value again, restoring the original structure for data entry, calculations, exports, and integrations.
Can I format a merged cell as a single unit?
Yes. When cells are merged they act as a single region for formatting—alignment, font styles, borders, shading, and other formatting options apply across the combined space so headers and labels stay visually consistent in your quote or proposal documents.
Do merged cells affect calculations, exports, or integrations?
Merged cells are primarily a visual/layout feature. For calculations, exports, or integrations you may prefer to unmerge so each cell contains its own value and the data remains atomic. Depending on the export format or integration (for example when syncing with accounting tools), merged regions may be preserved, converted, or require unmerging for correct data mapping.
Which spreadsheet features pair well with merged cells?
Features such as text wrapping, borders, cell shading, and alignment work well with merged cells. Text wrapping keeps long labels readable inside a merged header, while borders and shading visually separate title areas and grouped sections.
What are best practices for using merged cells in sales quoting and proposal software?
Use merged cells to create clear section headers and to improve visual hierarchy in your sales quoting software or sales proposal software documents. Avoid over-merging data cells that need calculations or exports—keep numeric and transactional data in individual cells. Test how your merged layout exports or integrates with other systems (for example accounting or CRM tools) before finalising templates.
Can I merge cells horizontally and vertically, and are there keyboard shortcuts?
You can merge adjacent cells horizontally or vertically to form a single region. Use the Spreadsheet Block toolbar or the cell context menu to merge or unmerge. Keyboard shortcut availability may vary by platform and block settings—check the block’s help or context menu for any supported shortcuts.