How to Merge Cells in Google Sheets (2026)

Merging cells in Google Sheets combines multiple adjacent cells into one, useful for section headers, table titles, and formatted reports. Sheets offers three merge types: Merge all, Merge horizontally, and Merge vertically. This 2026 tutorial covers each option, keyboard shortcuts, best practices, and how to unmerge cells cleanly.

How to merge cells (step-by-step)

1. Select the cells you want to merge (drag or Ctrl+click).
2. Go to Format > Merge cells from the menu.
3. Choose one of the three merge types:
   • Merge all: all selected cells become one.
   • Merge horizontally: cells in each row are merged into one row-wide cell.
   • Merge vertically: cells in each column are merged into one column-tall cell.
4. Alternatively: click the Merge cells button in the toolbar (looks like two arrows pointing to a box).

Keyboard shortcut for merging cells

Google Sheets does not have a built-in keyboard shortcut for merging cells. To create one:

1. Go to Extensions > Macros > Record macro.
2. Select cells, click Merge cells (any variant).
3. Stop recording, name it “Merge Cells”, assign a shortcut like Ctrl+Alt+Shift+1.

Merge horizontally example

Before (rows 1-3, cols A-C):
| Q1  |    |    |
| Q2  |    |    |
| Q3  |    |    |

Steps:
1. Select A1:C3
2. Format > Merge cells > Merge horizontally

After:
| Q1 (merged A1:C1) |
| Q2 (merged A2:C2) |
| Q3 (merged A3:C3) |

Merge vertically example

Before (rows 1-3, cols A-C):
| Region |    |    |
| West   |    |    |
| East   |    |    |

Steps:
1. Select A1:A3
2. Format > Merge cells > Merge vertically

After:
| Region (merged A1:A3) | (empty) | (empty) |
|                        | (empty) | (empty) |
|                        | (empty) | (empty) |

How to unmerge cells

1. Click the merged cell.
2. Go to Format > Merge cells > Unmerge.
3. Or click the Merge cells button in the toolbar (it toggles).

After unmerging, only the top-left cell retains the value. Other unmerged cells become empty.

Center text after merging

Merged cells default to left-align. To center a title:

1. Select the merged cell.
2. Click the horizontal align button in the toolbar.
3. Choose Center.
4. For vertical center: click vertical align button > Middle.

When NOT to merge cells

• Data tables: merged cells break sorting, filtering, and pivot tables.
• Above tables you’ll pivot: pivot tables cannot use merged data ranges. Use “Center across selection” or leave unmerged.
• Above formula ranges: SUM, COUNT can misread merged cells.
• Copy-paste destinations: pasting into merged cells often creates layout chaos.

Alternative: “Center across selection” via manual formatting

Google Sheets does not have a formal Center Across Selection option like Excel. The workaround: leave cells unmerged, put the text in the leftmost cell, right-align or center-align to the visual span. This preserves sortability while looking merged.

Merging cells in reports (best practices)

• Merge for section headers (Q1 Sales, Regional Summary).
• Merge for two-line report titles at top of the sheet.
• Do NOT merge across data rows in tables you plan to sort.
• Use borders and background colors instead of merging for visual grouping.
• Freeze the top row for headers instead of merging across dozens of columns.

Common merge cell errors

• “Merge cells is disabled”: sheet is protected or view-only. Check permissions.
• Data lost after merging: only the top-left cell’s value is kept. Copy other values first if needed.
• Sort not working: sort ignores merged rows. Unmerge first.
• Cannot select non-adjacent cells to merge: merge only works on rectangular contiguous ranges.

Common Google Sheets mistakes to avoid

Even experienced users hit the same pitfalls with Sheets formulas and shared spreadsheets. Being aware of these traps saves hours of debugging and rework.

• Not checking sharing permissions before sending. A file shared with “Anyone with the link” behaves differently from “Restricted.” Always verify who can access before you share externally.
• Working on a shared file without version history awareness. Google Workspace keeps version history, but collaborators can overwrite your work. Use File > Version history > See version history to review changes.
• Ignoring the auto-save indicator. The “All changes saved in Drive” indicator confirms your work is persisted. If it says “Saving…” for too long, your connection may be unstable.
• Forgetting to check on mobile. Some formatting and features render differently on the Google Workspace mobile apps. Test on your phone before sending important content.
• Not using keyboard shortcuts. Google Workspace has extensive shortcuts (press Ctrl+/ or Cmd+/ to see them all). Learning the top 5-10 shortcuts saves significant time.

Power-user tips for Google Sheets

Once the basics are solid, these techniques let you work faster and with more control.

• Use templates as starting points. Google Workspace includes free templates for common documents. Access via File > New > From template gallery. Customize once, reuse forever.
• Master search operators inside Drive. Search operators like type:document, owner:me, and before:2025-01-01 narrow results dramatically. Combine multiple operators for precise filters.
• Use offline mode when your connection is unreliable. Enable offline access in Drive settings so you can keep working during network outages. Changes sync automatically when you reconnect.
• Set up Google Workspace apps on desktop. Drive for Desktop syncs files to your local machine and integrates with File Explorer or Finder. Works better than the web interface for large files.
• Bookmark important documents. Star files in Drive to see them at the top of your Home view. Great for daily reference documents.

Real-world workflow examples

Concrete scenarios where these features solve everyday problems:

For students and BSIT capstone teams: Use shared Google Docs for capstone documentation, with real-time collaboration replacing back-and-forth email attachments. Version history preserves an audit trail of who wrote what.

For freelancers and consultants: Combine Google Drive folders (per client) with shared permissions for smooth handoffs. Clients can view or comment without needing separate accounts.

For small teams: A shared Drive folder plus a linked Google Sheet as project tracker gives structured collaboration without paying for enterprise tools.

Best practices summary

The pattern that works across nearly every Google Workspace use case:

• Start simple, add complexity when needed. A basic Doc or Sheet solves 90 percent of cases. Only add scripts, add-ons, or complex formulas when the simple version breaks.
• Version history is your safety net. Every serious edit should be reversible via File > Version history.
• Share thoughtfully. Restricted sharing beats Anyone-with-link for anything sensitive. Add specific emails for tighter control.
• Mobile-check before sending. A quick preview on your phone catches layout issues that never show up on desktop.
• Learn keyboard shortcuts. The top 10 shortcuts save 30 minutes a week if you use Workspace daily.

Adrian Mercurio

Full-Stack Developer at PIES IT Solution

Specializes in building complete capstone projects with full documentation. Strong background in PHP/MySQL development and database design.

Expertise: PHP  ·  Laravel  ·  Database Design  ·  Capstone Projects  ·  C#  ·  C  · View all posts by Adrian Mercurio →