How to merge names in Google Sheets
Select the cells, then Format → Merge cells (or the toolbar Merge icon). Choose Merge all, horizontally, or vertically. Only the top-left value is kept. Avoid merging inside data tables you still sort or filter.
Steps
-
1
Select a contiguous range.
-
2
Format → Merge cells (or toolbar Merge).
-
3
Pick Merge all / horizontal / vertical.
-
4
Unmerge from the same menu if needed.
Better Sheets on YouTube
Watch matching videos from youtube.com/bettersheets.
Terms and formulas behind this
Want the full definition or how a formula works? Start here.
Merge cells
Merge cells combines a rectangular selection into one display cell. Only the top-left cell value survives; others are...
Open →Unmerge cells
Unmerge splits a merged block back into individual cells. Only the top-left cell keeps the displayed value; other cel...
Open →sorting data in Sheets
Sorting reorders rows by one or more columns. The Data > Sort range menu sorts selection in place. The SORT function ...
Open →SORT
SORT reorders rows from an input range and spills the result elsewhere. Source data stays put, unlike Data > Sort ran...
Open →filters in Google Sheets
Filtering hides rows that do not match criteria without deleting data. The filter toolbar on a header row is the fast...
Open →FILTER
FILTER returns only the rows from a range that meet one or more conditions. Conditions are boolean arrays the same he...
Open →cell formatting
Cell formatting controls how values display without necessarily changing the stored value underneath. Currency, perce...
Open →FILTER()
Google Sheets FILTER() function guide
Open →SORT()
Google Sheets SORT() function guide
Open →Related questions
Can i merge cells in Google Sheets
Select the cells, then Format → Merge cells (or the toolbar Merge icon). Choose Merge all, horizontally, or vertically. Only the top-left value is kept. Avoid merging inside data tables you still sort or filter.
Get the answer →How to merge 2 cells in Google Sheets
Select the cells, then Format → Merge cells (or the toolbar Merge icon). Choose Merge all, horizontally, or vertically. Only the top-left value is kept. Avoid merging inside data tables you still sort or filter.
Get the answer →Can you merge cells in Google Sheets
Select the cells, then Format → Merge cells (or the toolbar Merge icon). Choose Merge all, horizontally, or vertically. Only the top-left value is kept. Avoid merging inside data tables you still sort or filter.
Get the answer →How do i merge cells in Google Sheets
Select the cells, then Format → Merge cells (or the toolbar Merge icon). Choose Merge all, horizontally, or vertically. Only the top-left value is kept. Avoid merging inside data tables you still sort or filter.
Get the answer →Google Sheets how to merge cells
Select the cells, then Format → Merge cells (or the toolbar Merge icon). Choose Merge all, horizontally, or vertically. Only the top-left value is kept. Avoid merging inside data tables you still sort or filter.
Get the answer →Need more than a quick answer?
600+ walkthrough videos, unlimited generators, and every template. From $9/month. Practical lessons. Zero fluff.
Need one fix
Watch a free tutorial for the step-by-step version of any answer.
Learning Sheets for real
Unlock the full library, generators, and templates with membership.