[et_pb_section fb_built=”1″ admin_label=”section” _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content” da_is_popup=”off” da_exit_intent=”off” da_has_close=”on” da_alt_close=”off” da_dark_close=”off” da_not_modal=”on” da_is_singular=”off” da_with_loader=”off” da_has_shadow=”on” da_disable_devices=”off|off|off”][et_pb_row admin_label=”row” _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}” theme_builder_area=”post_content”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||” theme_builder_area=”post_content”][et_pb_text _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Learning how to merge cells in Google Sheets can significantly enhance your spreadsheets, but do it cautiously because merged cells may break formulas and filters! This guide is designed to walk you through everything you need to know to both merge and unmerge cells. It also shows how to find merged cells and how to combine the text of several cells without merging them.<\/p>\n
Whether you want to improve readability, organize data, or highlight information, merging cells in Google Sheets is a fundamental skill, and knowing when to use it is even more important.<\/p>\n
[\/et_pb_text][et_pb_text module_id=”why” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n
Merging cells in Google Sheets can enhance the readability and appearance of your spreadsheets. It is not a matter of style but rather all about functionality.<\/p>\n
Be aware that when you merge a cell only the top-leftmost value will stay on it, and you will not be able to filter values on that cell, and even might break some formulas, so never merge cells on a spreadsheet that you are still analysing, or inputting data.<\/p>\n
Here are some common uses of cell merging<\/b>:<\/p>\n Merging cells is a good feature to make your spreadsheets easier to read and understand, it can be appealing to use it everywhere, but you need to know the risks.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/04\/how-to-merge-cells_1.webp” alt=”How to merge cells in Google Sheets \u2014 merged header and category cells above a merged block of important information” title_text=”Merged header and category cells above a merged block of important information” align=”center” _builder_version=”4.24.1″ _module_preset=”default” width=”100%” custom_margin=”30px||30px||true|false” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”precautions” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Merging cells comes with its own set of challenges. There are a few things to consider to ensure the integrity of your spreadsheet:<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/04\/how-to-merge-cells_2.webp” alt=”Merge cells in Google Sheets \u2014 Heads up warning that merging keeps only the top-leftmost value” title_text=”Heads up warning that merging keeps only the top-leftmost value” align=”center” _builder_version=”4.24.1″ _module_preset=”default” width=”100%” custom_margin=”30px||30px||true|false” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”merge” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Merging cells in Google Sheets is super simple. Here’s how to merge cells, covering the different types of merges you might need: horizontally, vertically, and all directions.<\/p>\n That\u2019s it! Now you know how to merge cells in Google Sheets.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2024\/04\/how-to-merge-cells_3.webp” alt=”How to merge cells in Google Sheets \u2014 A1:C6 selected and the Merge cells button in the toolbar” title_text=”A1:C6 selected and the Merge cells button in the toolbar” align=”center” _builder_version=”4.24.1″ _module_preset=”default” width=”100%” custom_margin=”30px||30px||true|false” border_radii=”on|12px|12px|12px|12px” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”merge-all-merge-vertically-or-merge-hori” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You can also merge cells from the Format menu. First, select the cells you want to merge.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/merge-cells-google-sheets-select-range.webp” alt=”Merge cells in Google Sheets \u2014 range A1:C7 selected before merging” title_text=”Range A1:C7 selected before merging” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Once the cells are selected, go to Format > Merge cells.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/merge-cells-google-sheets-format-menu.webp” alt=”Merge cells in Google Sheets \u2014 Format menu open on Merge cells and its options” title_text=”Format menu open on Merge cells and its options” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n As you can see, there are three different ways to merge. Let\u2019s see how each one works.<\/p>\n For things to keep in mind when merging cells, check out these Precautions when merging cellls<\/a>.<\/p>\n If you want to merge your selection of cells into one giant cell, select “Merge all”.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/merge-all-google-sheets-menu.webp” alt=”Merge all in Google Sheets \u2014 Merge all highlighted in the Merge cells menu” title_text=”Merge all highlighted in the Merge cells menu” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You can see that you now have just one cell, but its dimensions are those of the range of cells: \u2018A1:C7\u2019.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/merge-all-google-sheets-result.webp” alt=”Merge all in Google Sheets \u2014 A1:C7 turned into one large cell” title_text=”A1:C7 turned into one large cell” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n When you merge cells vertically, you merge the rows within each column of your selection. Let\u2019s see what happens if you choose to \u201cMerge vertically\u201d on the same selection of cells as before.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/merge-vertically-google-sheets-menu.webp” alt=”Merge vertically in Google Sheets \u2014 Merge vertically highlighted in the Format menu” title_text=”Merge vertically highlighted in the Format menu” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You now have one merged cell per column, and the height of the merged cell equals the number of rows in your original selection.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/merge-vertically-google-sheets-result.webp” alt=”Merge vertically in Google Sheets \u2014 one merged cell per column, C1:C7 selected” title_text=”One merged cell per column, C1:C7 selected” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n In some cases, you may want to merge cells horizontally so that the columns in your selection are merged per row. Let\u2019s see what happens when you choose \u201cMerge horizontally\u201d.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/merge-horizontally-google-sheets-menu.webp” alt=”Merge horizontally in Google Sheets \u2014 Merge horizontally highlighted in the Format menu” title_text=”Merge horizontally highlighted in the Format menu” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You now have seven merged cells, each three columns wide.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/merge-horizontally-google-sheets-result.webp” alt=”Merge horizontally in Google Sheets \u2014 seven merged rows, each three columns wide” title_text=”Seven merged rows, each three columns wide” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text module_id=”unmerge” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Unmerging cells in Google Sheets is just as simple as merging them:<\/p>\n When unmerged, the content from the merged cell stays in the upper-leftmost cell, leaving the others empty. You\u2019ll need to manually distribute any content as needed.<\/p>\n [\/et_pb_text][et_pb_text module_id=”google” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n While Google Sheets doesn’t have a direct keyboard shortcut to merge cells, you can still do it without lifting your hands off the keyboard.<\/p>\n Here’s a quick method to merge cells:<\/p>\n While not technically a shortcut this will help if you think reaching for the mouse is a waste of time.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-find-merged-cells-in-google-sheet” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Google Sheets doesn\u2019t have a built-in function for finding merged cells, so it isn\u2019t always easy to track them down. If it\u2019s a small spreadsheet, they should be easy to spot through visual inspection, as merged cells will be wider or taller than normal cells. However, if it\u2019s a large spreadsheet, this can be very time-consuming.<\/p>\n Usually, if you\u2019re looking for merged cells, it\u2019s because you want to remove them to avoid unexpected problems when you analyze or manipulate the data. If you\u2019re not interested in keeping any existing formats, you can clear the formatting for each sheet or tab, which will also unmerge any merged cells.<\/p>\n Go to the sheet or tab where you want to remove merged cells. Click on the top-left corner to select all cells, as shown below.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/find-merged-cells-google-sheets-select-all.webp” alt=”Find merged cells in Google Sheets \u2014 whole sheet selected from the top-left corner” title_text=”Whole sheet selected from the top-left corner” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Go to Format > Clear formatting.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/find-merged-cells-google-sheets-clear-formatting.webp” alt=”Find merged cells in Google Sheets \u2014 Clear formatting at the bottom of the Format menu” title_text=”Clear formatting at the bottom of the Format menu” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n As you can see, the cells have been unmerged.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/find-merged-cells-google-sheets-unmerged.webp” alt=”Find merged cells in Google Sheets \u2014 2022 and 2021 headers back in single cells” title_text=”2022 and 2021 headers back in single cells” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Clearing the formatting also resets fonts, colors, borders, and number formats. To set them up again, see how to format cells in Google Sheets<\/a>.<\/p>\n [\/et_pb_text][et_pb_text module_id=”how-to-combine-cells-in-google-sheets-wi” _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n To combine the contents of different cells without merging them, you can use the CONCATENATE function<\/a>, the "&" operator, or the JOIN function.<\/p>\n For example, say you have a list of first names and last names, and you want to combine them to get the full name in one cell.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/combine-cells-google-sheets-names-table.webp” alt=”Combine cells in Google Sheets \u2014 first_name and last_name columns with an empty fullname column” title_text=”First_name and last_name columns with an empty fullname column” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Merging won\u2019t work, as you\u2019ll only keep the top-left data \u2013 in this case, the first name.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/combine-cells-google-sheets-merge-warning.webp” alt=”Combine cells in Google Sheets \u2014 Heads up warning when merging the first and last name cells” title_text=”Heads up warning when merging the first and last name cells” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n In an empty cell, type the equal sign, followed by the CONCATENATE function.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/combine-cells-google-sheets-concatenate.webp” alt=”Combine cells in Google Sheets \u2014 =CONCATENATE( typed in cell C2″ title_text=”=CONCATENATE( typed in cell C2″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Select the cells with the contents you want to combine.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/combine-cells-google-sheets-concatenate-range.webp” alt=”Combine cells in Google Sheets \u2014 =CONCATENATE(A2:B2) with both name cells selected” title_text=”=CONCATENATE(A2:B2) with both name cells selected” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n As you can see, the contents have been combined but without any delimiters.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/combine-cells-google-sheets-concatenate-result.webp” alt=”Combine cells in Google Sheets \u2014 BrierAshmore in C2, combined with no space” title_text=”BrierAshmore in C2, combined with no space” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n If you want to include a space or a symbol between the contents of each cell, you should use the "&" operator or the JOIN function.<\/p>\n To combine the text from two cells using the "&" operator, type the equal sign and select the first cell you want to combine.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/combine-cells-google-sheets-ampersand-first-cell.webp” alt=”Combine cells with the ampersand in Google Sheets \u2014 =A2 typed in cell C2″ title_text=”=A2 typed in cell C2″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Add the "&", then add the delimiter you want to use between quotation marks.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/combine-cells-google-sheets-ampersand-delimiter.webp” alt=”Combine cells with the ampersand in Google Sheets \u2014 a space in quotation marks added after A2″ title_text=”A space in quotation marks added after A2″ align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Finally, add another "&" and the second cell, then press \u2018Enter\u2019.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/combine-cells-google-sheets-ampersand-second-cell.webp” alt=”Combine cells with the ampersand in Google Sheets \u2014 second ampersand and cell B2 added” title_text=”Second ampersand and cell B2 added” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n You can then grab the fill handle and drag it down to copy the formula.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/combine-cells-google-sheets-ampersand-fill-down.webp” alt=”Combine cells with the ampersand in Google Sheets \u2014 full names in C2:C10 after dragging the fill handle” title_text=”Full names in C2:C10 after dragging the fill handle” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The JOIN function allows you to specify a delimiter in addition to combining the text from the cells.<\/p>\n Type the equal sign, then the JOIN function.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/combine-cells-google-sheets-join.webp” alt=”Combine cells with JOIN in Google Sheets \u2014 =JOIN( typed in C2 with its syntax hint” title_text=”=JOIN( typed in C2 with its syntax hint” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Add your chosen delimiter between quotation marks, then a comma.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/combine-cells-google-sheets-join-delimiter.webp” alt=”Combine cells with JOIN in Google Sheets \u2014 space delimiter in quotation marks, then a comma” title_text=”Space delimiter in quotation marks, then a comma” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Finally, add the cells with the contents you want to combine and press \u2018Enter\u2019.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/combine-cells-google-sheets-join-range.webp” alt=”Combine cells with JOIN in Google Sheets \u2014 space delimiter and range A2:B2 in the formula” title_text=”Space delimiter and range A2:B2 in the formula” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n As you can see, the combined contents are separated by a space. Grab the fill handle and drag it down to copy the formula.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/combine-cells-google-sheets-join-result.webp” alt=”Combine cells with JOIN in Google Sheets \u2014 Brier Ashmore in C2 with a space between the names” title_text=”Brier Ashmore in C2 with a space between the names” align=”center” _builder_version=”4.22.2″ _module_preset=”default” width=”100%” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.22.2″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n To do the reverse and break the text in one cell into several cells, use the SPLIT function<\/a>.<\/p>\n [\/et_pb_text][et_pb_text module_id=”alternative” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n Okay, by now you should know how to merge a cell, and most important when to not merge a cell, but what are the alternatives?<\/p>\n But wait! You can do even more with Sheetgo, an AI-powered data automation platform. It can build dashboards and PDF reports from your spreadsheets and keep them up to date automatically.<\/p>\n Learn here how to generate a PDF report<\/a> based on all the actual data in your spreadsheet, and even send it by Gmail automatically.<\/p>\n And if you want an intuitive and interactive Dashboard that is responsive and will work on any device, look no further, Sheetgo can help you too, Read this article to learn more about it.<\/a><\/p>\n [\/et_pb_text][et_pb_text module_id=”conclusion” _builder_version=”4.24.1″ _module_preset=”default” global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n That\u2019s it for this guide on how to merge cells in Google Sheets. You\u2019ve learned how this feature, while simple, has the power to drastically improve the organization and presentation of your data, or break all the work you\u2019ve done.<\/p>\n So before you merge cells, weigh the risks: data loss, broken formulas, and sorting and filtering that stop working.<\/p>\n With the steps and precautions outlined in this guide, you\u2019re now equipped to enhance your Google Sheets. This should be a great benefit for yourself and for everyone else who works with your spreadsheets.<\/p>\n And if you want to do even more without risking data loss, Sheetgo’s AI-powered automation can keep your reports current and run your workflows for you.<\/p>\n\n
Precautions when merging cells<\/h2>\n
\n
How to merge cells in Google Sheets<\/h2>\n
\n
Merge all, merge vertically, or merge horizontally<\/h2>\n
Merge all<\/h3>\n
Merge vertically<\/h3>\n
Merge horizontally<\/h3>\n
How to unmerge cells in Google Sheets<\/h2>\n
\n
Google Sheets merge cells shortcut<\/h2>\n
\n
How to find merged cells in Google Sheets<\/h2>\n
How to combine cells in Google Sheets without merging<\/h2>\n
Combine text using CONCATENATE<\/h3>\n
Combine text using "&"<\/h3>\n
Combine text using JOIN<\/h3>\n
Better alternatives to merge cells in Google Sheets<\/h2>\n
\n
Merge away!<\/h2>\n