1. Manual ways to merge cells and use shortcuts

Before you automate, you need to know how merging works by hand in Google Sheets. Here are the most useful manual methods.

‍

Method 1: Merge via the toolbar

1. Open your sheet and select the cells to combine (they must be adjacent).
2. On the top toolbar, click the Merge cells icon (two arrows pointing into one box).
3. Choose one of:
   • Merge all – one big cell from the entire selection.
   • Merge horizontally – each row becomes one merged cell.
   • Merge vertically – each column becomes one merged cell.
4. To unmerge, select the merged cell and click the same icon → Unmerge.

This is ideal when you’re designing a dashboard header or a one-off report layout.

‍

Method 2: Merge from the Format menu

1. Select the target range.
2. Go to Format → Merge cells.
3. Choose Merge all, Merge horizontally, or Merge vertically.
4. To undo, repeat Format → Merge cells → Unmerge.

Use this when you prefer menus (for example, when training team members who aren’t shortcut-heavy users).

‍

Method 3: Keyboard shortcuts (Windows)

Google’s official shortcut list: https://support.google.com/docs/answer/181110

1. Select the cells you want to merge.
2. Press:
   • Alt + O, M, A (then Enter) to Merge all.
   • Alt + O, M, U to Unmerge.
3. If you want broader navigation speed:
   • Use Ctrl+Space to select a column, Shift+Space to select a row.
   • Then apply the merge shortcut.

Shortcuts are perfect when you’re constantly reformatting KPI tables and want to stay on the keyboard.

‍

Method 4: Keyboard shortcuts (Mac)

1. Select the target range.
2. Press:
   • Control + Option + O, M, Enter to Merge all.
   • Control + Option + O, M, U to Unmerge.
3. Combine with Command+Shift+Arrow keys to expand your selection quickly.

‍

Method 5: Merge-like results with formulas

Sometimes you want combined content, not merged cells. In that case, use formulas so your data stays analyzable.

1. Suppose first names are in A2 and last names in B2.
2. In C2, type: =A2 & " " & B2 and press Enter.
3. Fill down the column.

You now have a single “Name” column without losing sort/filter flexibility.

‍

2. No-code automation methods

If you repeatedly format similar Sheets (weekly marketing reports, client dashboards, sales leaderboards), no-code tools can help apply merge patterns faster.

‍

Method 6: Use Apps Script templates (semi no‑code)

Google Apps Script lives inside Sheets and lets you record layout logic.

1. In your Sheet, go to Extensions → Apps Script.
2. Create a script that:
   • Selects known ranges (e.g., header rows).
   • Calls range.merge() or range.unmerge() on them.
3. Save and add a custom menu item like “Format → Apply dashboard layout”.
4. Your team clicks one menu item to reapply all merges.

Docs: https://developers.google.com/apps-script/guides/sheets

‍

Method 7: Use a template-plus-duplicate workflow

This is the simplest “automation”: build one master template with all merges.

1. Create a master dashboard Sheet with perfectly merged headers and sections.
2. When you need a new client or campaign report:
   • Right-click the master tab → Duplicate.
   • Or copy the entire file via File → Make a copy.
3. Fill in data or connect it to imports; layout stays consistent.

Zero code, but huge time savings for agencies managing many lookalike reports.

‍

Method 8: Triggered reshaping with Apps Script

Go one step further: have Apps Script respond to changes.

1. In Apps Script, set up an onEdit(e) or time-driven trigger.
2. When new data lands (for example, a CSV import into a raw tab), your script:
   • Copies it into a formatted tab.
   • Applies merges/unmerges to specific header rows.
3. Your Google Sheets “presentation layer” always stays neat without manual cleanup.

‍

3. At-scale automation with AI agents (Simular)

Manual shortcuts are powerful for one sheet. But a business owner, sales leader, or agency operator rarely has one sheet – they have dozens or hundreds. That’s where a Simular AI computer agent turns merge shortcuts into a background process.

‍

Method 9: Simular Pro as your spreadsheet layout operator

Simular Pro (https://www.simular.ai/simular-pro) is a computer-use agent that can control your desktop, browser, and cloud tools like a human.

A Simular agent can:

• Open Google Sheets in your browser.
• Navigate tabs, select ranges with keyboard shortcuts.
• Press Alt+O, M, A or Control+Option+O sequences to apply merges.
• Duplicate templates, standardize formatting, and unmerge before exporting.

‍

Pros:

• Works across all your Sheets, workspaces, and even other apps (CRM, email, dashboards).
• Every action is transparent and inspectable, so you see exactly how it merges cells.
• Production-grade: handles workflows with thousands of steps.

‍

Cons:

• Requires a short setup and onboarding of the agent.
• Best suited once you have repeatable patterns (e.g., a standard weekly report layout).

‍

Method 10: Webhook-triggered formatting runs

Simular integrates via webhooks, so you can kick off a formatting run automatically.

Example workflow for an agency:

1. Your data pipeline (or a tool like Zapier/Make) finishes pushing fresh metrics into a Google Sheet.
2. It calls a webhook that triggers a Simular Pro agent.
3. The agent:
   • Opens the new Sheet.
   • Applies merges to specific header rows using shortcuts.
   • Adjusts column widths, applies borders, and saves.
4. Your client gets a polished sheet without anyone touching a mouse.

‍

Pros:

• Truly hands-off presentation formatting.
• Scales elegantly from 5 to 500 client sheets.

‍

Cons:

• Requires clear naming conventions and folder structures so the agent knows which files to touch.

‍

Method 11: Multi-app reporting orchestration

Because Simular agents can use multiple apps, you can orchestrate an end‑to‑end reporting story:

1. Agent pulls a CSV from your analytics tool.
2. Uploads/imports it into Google Sheets.
3. Applies merges with keyboard shortcuts according to your brand layout.
4. Exports to PDF and emails it to your sales team.

Instead of teaching every team member obscure merge shortcuts, you teach one AI agent once. From then on, merging is just “part of the show” whenever reports run.

To understand how Simular builds such reliable computer-use agents, explore: https://www.simular.ai/about

By combining manual mastery of Google Sheets merge shortcuts with no-code scripts and Simular’s autonomous agents, you move from "I’ll clean this later" to a world where your dashboards are always client-ready before you even open them.

Heading 1

Heading 2

Heading 3

Heading 4

Heading 5

Heading 6

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.

Block quote

Ordered list

1. Item 1
2. Item 2
3. Item 3

Unordered list

• Item A
• Item B
• Item C

Text link

Bold text

Emphasis

^Superscript

_Subscript