{"id":12013,"date":"2021-02-28T18:25:19","date_gmt":"2021-02-28T18:25:19","guid":{"rendered":"https:\/\/www.gworkspacetips.com\/?p=12013"},"modified":"2022-04-07T09:10:03","modified_gmt":"2022-04-07T09:10:03","slug":"how-to-merge-cells-in-google-sheets","status":"publish","type":"post","link":"https:\/\/www.gworkspacetips.com\/how-to-merge-cells-in-google-sheets\/","title":{"rendered":"How to merge cells in Google Sheets"},"content":{"rendered":"\n<p>Like most other spreadsheet apps, you can merge cells in Google Sheets as well. By merging two or more cells, you can create one larger cell to show as a single entity.<\/p>\n\n\n\n<p>Users have different reasons to merge cells. The good thing is you can merge cells both vertically and horizontally in Google Sheets. Features such as this one help you to store and keep your data organised.<\/p>\n\n\n\n<p>Merging cells in Google Sheets is quite easy, provided you know the right steps. There is more than one way of doing it. You can either take the long route or use the merge option given in the toolbar.<\/p>\n\n\n\n<p>If you are using <a href=\"https:\/\/www.gworkspacetips.com\/tips\/sheets\/\" class=\"rank-math-link\">Google Sheets<\/a> for the first time and need help with the steps, you are at the right place. In this post, we will tell you how to merge cells in Google Sheets. The steps are straightforward and easy to follow.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Steps to merge cells in Google Sheets<\/h2>\n\n\n\n<ol><li>Go to <a class=\"rank-math-link\" href=\"https:\/\/docs.google.com\/spreadsheets\/\" target=\"_blank\" rel=\"noopener\">Google Sheets<\/a>:<\/li><li>Now, select the cells you want to merge:<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"828\" height=\"569\" src=\"https:\/\/www.gworkspacetips.com\/wp-content\/uploads\/2021\/02\/image-35-828x569.png\" alt=\"How to merge cells in Google Sheets\" class=\"wp-image-12017\" srcset=\"https:\/\/www.gworkspacetips.com\/wp-content\/uploads\/2021\/02\/image-35.png 828w, https:\/\/www.gworkspacetips.com\/wp-content\/uploads\/2021\/02\/image-35-768x527.png 768w\" sizes=\"(max-width: 828px) 100vw, 828px\" \/><\/figure>\n\n\n\n<ol start=\"3\"><li>Now, go to Format &gt; Merge cell and you will find three options: merge all, merge horizontally and merge vertically.<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"483\" height=\"590\" src=\"https:\/\/www.gworkspacetips.com\/wp-content\/uploads\/2021\/02\/image-34-483x590.png\" alt=\"How to merge cells in Google Sheets\" class=\"wp-image-12016\"\/><\/figure>\n\n\n\n<ol start=\"4\"><li>Then, click on the way you want to merge the cells and your cells will merge:<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"726\" height=\"417\" src=\"https:\/\/www.gworkspacetips.com\/wp-content\/uploads\/2021\/02\/image-33-726x417.png\" alt=\"merge cells in Google Sheets\" class=\"wp-image-12015\"\/><\/figure>\n\n\n\n<ol start=\"5\"><li>Alternatively, you can use the toolbar to conveniently merge the cells. As usual, select the cells and click on the Merge option on the toolbar:<\/li><\/ol>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" loading=\"lazy\" width=\"589\" height=\"372\" src=\"https:\/\/www.gworkspacetips.com\/wp-content\/uploads\/2021\/02\/image-32-589x372.png\" alt=\"merge cells in Google Sheets\" class=\"wp-image-12014\"\/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Like most other spreadsheet apps, you can merge cells in Google Sheets as well. By merging two or more cells, you can create one larger&hellip;<\/p>\n<p> <a class=\"more-link\" href=\"https:\/\/www.gworkspacetips.com\/how-to-merge-cells-in-google-sheets\/\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":12974,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[43,30],"tags":[],"_links":{"self":[{"href":"https:\/\/www.gworkspacetips.com\/wp-json\/wp\/v2\/posts\/12013"}],"collection":[{"href":"https:\/\/www.gworkspacetips.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gworkspacetips.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gworkspacetips.com\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gworkspacetips.com\/wp-json\/wp\/v2\/comments?post=12013"}],"version-history":[{"count":0,"href":"https:\/\/www.gworkspacetips.com\/wp-json\/wp\/v2\/posts\/12013\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.gworkspacetips.com\/wp-json\/wp\/v2\/media\/12974"}],"wp:attachment":[{"href":"https:\/\/www.gworkspacetips.com\/wp-json\/wp\/v2\/media?parent=12013"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gworkspacetips.com\/wp-json\/wp\/v2\/categories?post=12013"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gworkspacetips.com\/wp-json\/wp\/v2\/tags?post=12013"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}