Vertical Cell Merge In Google Spreadsheets

Google starting today extended the merge functionality in Spreadsheets to let you create vertical merges across several rows of data."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 […]

Google starting today extended the merge functionality in Spreadsheets to let you create vertical merges across several rows of data.

"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," stated Jakov Krolo, Software Engineer Intern.

Krolo said "Using vertical merges, you can assign headers to sets of rows. Simply select the set of cells you'd like to merge, then click on the down arrow next to the merge icon, and select Merge vertically."

"In the NFL spreadsheet, you'll see that some of the team names don't fit on one line in the width of the cells of Column C."

"To improve the formatting, select the cells across all the rows of teams in the AFC (rows 2-17) and 2 columns (C and D) and click Merge horizontally. You'll have 16 merged cells that span 2 columns for better formatting."

"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!," explained Krolo.

To undo a merge action, select a merged cell and click Unmerge in the drop-down menu.