Skip to content
Back to template gallery
Google Sheets
Google Sheets

How to merge and center in google sheets

This Scribe guide helps you merge and center rows in Google Sheets

Professional Hacks
6 steps 2 min Community template
1

Navigate to your google sheets.

Navigate to your google sheets.

2

Click cell A1

Click on cell A1, containing the text "Name", in the upper-left corner of the spreadsheet grid.

docs.google.com/spreadsheets
Click cell A1
3

Click the Merge cells button

Click the Merge cells button in the top toolbar to combine the selected cells.

docs.google.com/spreadsheets
Click the Merge cells button
4

Click the More button

Click the three vertical dots in the top toolbar to reveal additional formatting options.

docs.google.com/spreadsheets
Click the More button
5

Click the Horizontal align button

Click the Horizontal align button in the top toolbar to open the alignment options.

docs.google.com/spreadsheets
Click the Horizontal align button
6

Click the Center alignment option

Click the Center alignment option in the dropdown menu to center the text within the merged cell.

docs.google.com/spreadsheets
Click the Center alignment option

Make this walkthrough your own

Duplicate this template, swap in your own screens, and share it with your team. Free to start — no credit card.