No—Smartsheet does not let you merge cells in a sheet. There is no merge command that combines adjacent cells into one larger cell, but you can often get the same practical result with a parent row, a helper column, a report, or a dashboard text widget, depending on what you are trying to show.
Why Smartsheet does not merge cells
Smartsheet sheets are designed to track work in a consistent grid: each row represents an item, and each column represents a field about that item. Keeping the cells separate helps the platform sort, filter, report on, assign, and automate work based on individual values. Merging cells across rows or columns would make it harder to tell which record a value belongs to and could interfere with those structured-data uses.
That is why Smartsheet’s sheet formatting options do not include a control equivalent to Excel’s Merge & Center. You can adjust text alignment, apply formatting, and wrap text, but those actions do not combine cell boundaries. The limitation applies to the sheet itself; changing the view or making a report does not turn its cells into merged cells.
This matters most when you are moving a spreadsheet from Excel. A workbook may use merged cells for section titles, decorative spacing, or forms. In Smartsheet, it is usually better to separate those presentation choices from the underlying rows and columns that store the work.
What “merge cells” would mean for your data
Merging is not just a visual change. In spreadsheet programs that support it, a merged area occupies the space of multiple cells, and only one value can normally be retained in the merged range. If the cells contain different information, merging can require deciding which value to keep and where the other values should go. Smartsheet avoids that ambiguity by keeping each cell distinct.
So if your goal is to make a heading span several columns, you cannot do that literally inside a Smartsheet sheet. If your goal is to combine two pieces of text into one displayed value, you can put the combined result in a separate column. If you want a visual section label, a parent row or a dashboard widget may fit better. The right alternative depends on whether you need a data value, a sheet structure, or a presentation element.
Use a parent row for section headings
For a task list or project plan, a parent row is often the closest replacement for a merged heading. Add a row with the section name, then indent the related tasks beneath it to create a parent-child hierarchy. For example, a row called “Website launch” can sit above child rows such as “Draft copy,” “Review designs,” and “Publish pages.” The parent row organizes the work without combining cells.
To make this structure useful:
- Give the parent row a clear name that describes the group of work.
- Indent the rows that belong under it, rather than adding the heading as a value in several columns.
- Use row formatting to distinguish the parent from its child rows, while keeping the column meanings consistent.
- Consider whether the parent should hold summary information, such as an owner or status, or simply serve as a label.
Hierarchy is useful when people need to expand or collapse sections and when the work items themselves need to remain trackable. It is not a perfect visual substitute for a heading stretched across the sheet: the parent row still has separate cells. It is, however, a more functional way to group related records.
Use a helper column to combine values
If you want a single cell to show information that currently sits in multiple columns, create a dedicated output column rather than trying to merge the source cells. For example, a contact sheet might store first and last names separately for sorting, but also include a “Full name” column for display. This keeps the original data available and creates one value for the combined presentation.
In a Smartsheet sheet with columns named First Name and Last Name, a row formula can combine the values in those columns:
=[First Name]@row + " " + [Last Name]@row
The formula displays a full name in the helper column; it does not join the cells or alter their layout. Keeping source fields separate is often valuable: teams can sort by last name, use individual fields in a report, or update one part of a name without retyping the other. If blank values or unusual spacing matter, check the output on representative rows before relying on it in a shared report.
For a one-off label, you can also type the combined text into a single cell. Avoid copying the same heading across several columns just to make it appear to span them: repeated text can create confusing sort and filter results, and it can become inconsistent when someone edits only one copy.
Use reports to control what people see
A report can present selected columns and rows without changing the source sheet. This is useful when a sheet needs many fields for tracking, but a particular audience only needs a simpler view. For example, a project tracker might retain owners, dates, dependencies, and internal notes, while a stakeholder report shows only task names, status, and target dates.
Reports are not merged-cell layouts either. Their value is that they let you choose and arrange the information being displayed, rather than adding decorative structure to the data sheet. If readers are asking for a heading above a group of items, you can organize the source rows with hierarchy or include a clear identifying field in the report. If they need a polished overview rather than a working grid, a dashboard may be more suitable.
Use a dashboard widget for presentation text
When the requirement is visual—such as a title, explanatory note, or section label on an overview—consider a Smartsheet dashboard. A dashboard’s Text widget is intended for explanatory or descriptive text, and you can position it alongside other widgets to create a composed page. For example, a dashboard could have a heading above a metric widget and a report widget, avoiding the need to make a sheet cell stretch across columns.
A dashboard is a separate presentation surface, not a modified sheet. It is best for summaries, instructions, and information people need to scan. It is not a replacement for a row-by-row data table when users must edit individual records. Keep the source sheet organized for reliable tracking, then use the dashboard to present the information in a more designed layout.
What to do with an imported Excel sheet
If an Excel workbook contains merged cells, plan to review its layout after bringing the data into Smartsheet. A title or note that appears across several Excel columns may not translate into an equivalent merged area. Before importing, consider whether that content belongs in a single column, in a separate title or notes area, or in a dashboard instead of among the records.
For a data table, a clean import usually has one header row and one record per row, with a value in the appropriate column for each field. Avoid using merged cells in the source table as a substitute for blank repeated values or as a way to group records. If several rows belong to one project, represent that relationship through a project field, a parent row, or another explicit structure. This makes the information easier to filter and reuse later.
If the workbook is primarily a designed form or printable page, the sheet grid may not be the right destination for every part of its layout. Keep the underlying data in Smartsheet where it benefits from tracking and collaboration, and recreate titles or explanatory sections in a dashboard or another presentation format as needed.
Common workarounds that cause problems
Some visual tricks look like a quick fix but make a sheet harder to maintain. Repeating a section heading in every cell across a row can make sorting awkward, while inserting blank rows between records can disrupt reports, filters, and automation that expect a consistent set of records. Neither workaround actually merges cells, and both can introduce clutter.
Before choosing a workaround, ask what the audience needs to do with the information:
- If people must sort, filter, assign, or update the items, keep the information in clear columns and use hierarchy for grouping.
- If people need one combined text value, use a helper column and preserve the original fields.
- If people need a short explanation or title, place it in a suitable descriptive field or a dashboard Text widget.
- If people only need a simplified view, build a report that shows the relevant rows and columns.
Also remember that formatting does not change the data model. Centering text, wrapping it, or applying a fill color may improve readability, but it cannot make a cell cover neighboring cells. Choosing a workaround based on the actual task avoids spending time trying to reproduce a feature the sheet does not provide.
Frequently Asked Questions
Can you merge cells in Smartsheet Grid View?
No. Grid View displays sheet data in a grid, but it does not provide a command to merge adjacent cells. Use a parent row, helper column, report, or dashboard element according to your goal.
Can I merge cells in Smartsheet like I can in Excel?
No. Smartsheet does not offer Excel’s merge-cell behavior in a sheet. If you are importing an Excel file, plan to restructure headings and decorative layout elements rather than expecting them to function as merged cells.
Can I center a heading across several Smartsheet columns?
You can format text alignment in a cell, but you cannot center one cell’s text across neighboring columns by merging them. Put the heading in one appropriate cell, use a parent row for a section, or use a dashboard Text widget for a broader visual title.
How do I combine two columns into one cell in Smartsheet?
Create a separate output column and combine the values there, for example with a row formula. This produces one displayed value while leaving the original columns intact; it does not merge the cells themselves.
Can a report or dashboard merge cells from a sheet?
No. Reports and dashboards offer different ways to select and present information, not a way to merge the source sheet’s cells. Use a report for a focused data view and a dashboard for presentation text and summaries.
Related
- Outlook Email Address Examples and How to Choose One
- Outlook Calendar: How to Find and Remove Duplicates
- MS Word Data Table: How to Create, Format, and Use It
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Schedule an Email in Outlook Desktop: Step-by-StepTo schedule an email in Outlook desktop, compose your message and choose a future send time: in new…
- Google Sheets QUERY: How to Write and Use the FunctionTo write a query in Google Sheets, enter the QUERY function in an empty cell, give it a…
- How to Unhide Rows in Excel With a Keyboard ShortcutTo unhide rows in Excel for Microsoft 365 on Windows, select the row headers immediately above and below…
- Can You Password Protect a Sheet in Excel? Here’s HowYes. In Excel for Microsoft 365 on Windows, go to Review > Protect Sheet, choose which actions users…
- How to Keep Track of Your Budget in Excel: Step by StepTo keep track of a budget in Excel, record each transaction in a dated log, assign it a…
- How to Undo Block Sender in Outlook and Unblock EmailsTo undo Block Sender in Outlook, remove the address or domain from your blocked senders list: in Outlook…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.