In this post, I will show you in 1 min How to Merge Cells In Google Sheets.
In some scenarios, we have to merge cells in google sheets and combine these together to make one cell. These could be either merging cells in rows or columns or both.
Merge cells in Google Sheets is a good way to keep our google sheets organized and understandable.
1. Open a Google Sheets in a browser.
2. Select two or more cells that you want to merge.
3. Click “Format” in the menu bar.
4. In the drop-down menu, click “Merge,” and then click the kind of cell merge you want – Merge Horizontally, Merge Vertically, or Merge All. Depending on the cells you selected, you may not have all these options.
google-sheets merge cells shortcut Another way to merge options is through the toolbar on google sheets. When we click the ‘Merge cells’ icon, it will merge the cells. And if we click on the drop-down icon it will show other options as merging horizontally or vertically
Note: When we merge cells that already have some content in the cell, the final merge cell will only retain the content of the top-left most cell. The rest of the content will be lost.
If we no longer want our cells to be merged, we can unmerge them easily.
You can also merge cells in google sheets using google apps script programmatically. If you want to know the power of Google apps script you can read this.
We can avoid losing data in the process, but it requires getting a Google Sheets add-on. If you’re interested, keep reading this article.