Skip to main content

New Google Docs feature: Merging spreadsheet cells vertically

Those of you that crunch numbers using Google Docs: The company has just added a cool new feature to the spreadsheets editor – merging cells vertically. In addition to the existing horizontal merging functionality, this new feature allows for some pretty complex layouts. Just drag the set of cells, hit the down arrow next to the merge icon and select Merge vertically. You can also assign headers to sets of rows. Why would anyone want to merge cells vertically? Google offers an example:

In the spirit of the NFL season, let’s say you want to host a football tournament for your friends. To make it easier for them to cast their votes on the winning team, you organize the NFL teams by conference and division in a Google spreadsheet. After applying vertical merges to all of the conference and division headers and horizontal merges across the team names in each conference, you’re ready to share with your friends for the tournament!

FTC: We use income earning auto affiliate links. More.

You’re reading 9to5Google — experts who break news about Google and its surrounding ecosystem, day after day. Be sure to check out our homepage for all the latest news, and follow 9to5Google on Twitter, Facebook, and LinkedIn to stay in the loop. Don’t know where to start? Check out our exclusive stories, reviews, how-tos, and subscribe to our YouTube channel