How to Merge Cells in Google Sheets
How to Merge Cells in Google Sheets
Working file - https://docs.google.com/spreadsheets/...
Today, we're diving into a super handy feature in Google Sheets—merging cells. Merging cells can help you make your spreadsheets look clean and organized. Let’s get started!
For this video we’re going to use the example of a lookup table that tells you the area of a square based on its height and width. Here is how we'd use the Merge Cells feature in google sheets to format the table.
There is a working file in the description below if you’d like to follow along.
Let’s start by formatting the Height header. Select the cells that you would like to merge, in this case D2 to H2. You can do this by clicking cell D2 and holding the left mouse button while you move the cursor to cell H2. The other way to do this is to select cell D2 and then hold the shift key while using the right arrow key to move the selection to H2.
Once you have the cells selected you can click the Merge Cells button on the menu bar which looks like two arrows pointing towards each other. You can also merge the cells by going to "Format" and then "Merge cells” and then "Merge All.
Now, let's do the same thing to format the width header. Select cells B4 to B8 and then merge them using the Merge Cells button.
Finally, let’s merge the “Area of a square” title cells by selecting A1 to C3 and then clicking the merge cells button.
To make everything easier to read we can center the text by using the Horizontal Align Center button and the Vertical AlignMiddle button.
If you want to perform multiple merges at once, you can select a large group of cells and then using the "Format" menu go to "Merge cells."
You’ll see a few options here: "Merge all," "Merge vertically," "Merge horizontally," and "Unmerge."
Merge all combines all selected cells into one single cell.
Merge vertically merges cells down the selected columns.
Merge horizontally merges cells across the selected rows.
Unmerge splits the merged cell back into individual cells.
For example, if you choose "Merge all," it will create one large merged cell with you selection.
If you choose "Merge horizontally," only the cells in the same row will merge.
While if you choose "Merge vertically," only the cells in the same column will merge.
And there you have it! Merging cells in Google Sheets can really help in organizing your data and making your sheets look more polished.
If you found this video helpful, don’t forget to give it a thumbs up and subscribe for more tips and tricks on Google Sheets. And if you have any questions or need help with other Google Sheets features, drop a comment below—I’d love to help out!
Thanks for watching, and see you in the next video!