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!

About the Author