Hotjar is disabled
Hero image

How to merge and split cells in Google Sheets

1 min read

Summary

Merging and splitting cells in spreadsheets allows you to consolidate data across multiple cells into one, improving the layout and making the information easier to read. This feature is particularly useful for creating headers or organizing content in a visually appealing and structured way.

In this article, we will show you how to merge and split cells in Google Sheets. Merging cells can be helpful to format your data and make it more presentable. However, keep in mind that despite improving the aesthetics of your spreadsheet, merging cells will make it trickier to copy, paste, and move data and prevent you from sorting and filtering it.

To merge cells, select more than one cell and click the "Merge cells" icon. If you click the dropdown arrow instead of the merge button, you’ll see options to merge vertically and horizontally.

Post image
More Google Workspace tips from Kanbanchi How to add dropdown lists in Google Sheets

When selecting more than one column and row simultaneously, merging vertically will only combine the cells within the same column, and merging horizontally will only merge the cells in the same row. To unmerge cells, select a cell that has been merged and uncheck the Merge button.

Post image

Want to try the power of Kanbanchi and Google Workspace?

Start your free trial

Watch how to merge and split cells in Google Sheets

Privacy Preference Center

Consent Management

The website uses cookies

Privacy Policy

Required
You read and agreed to our Privacy Policy.

Cookie Policy

Required
You read and agreed to our Cookie Policy.

Necessary

These cookies are necessary for Our Sites to function and cannot be switched off. They are usually only set in response to actions made by you which amount to a request for services, such as setting your privacy preferences, logging in or filling in forms. You can set your browser to block or alert you about these cookies, but some parts of Our Sites will not then work. These cookies do not store any personally identifiable information.

Cookies Used

Required
kanbanchi_website_cookie, gdpr[privacy_bar], gdpr[allowed_cookies], gdpr[consent_types], wp_lang, wordpress_*, wordpress_sec_*, wp_consent_*, wp_consent_type, wordpress_test_cookie, pll_language, pum-*, _pk_id.3.1e00, _pk_ses.3.1e00, __cfduid, cf_use_ob, _gat, _gid, _ga, _ga_*, _gaexp, _dc_gtm_*, _dc_gtm_UA-XXXXX-XX, _ga_XXXXXXXXXX, _GRECAPTCHA, __utma, __utmc, __utmz, __TAG_ASSISTANT, _gat_gtag_UA_*, amp_fb0efa, amp_*, amp_*.organization.domain, AMP_MKTG_*, amp_9ff40c, amp_e5a2c9, amp_e3e918, amp_6d2283, amp_dd1a7b, amplitude_*, access_token_production, driftt_aid, org_login_production, deviceId, userId, optOut, sessionId, lastEventTime, eventId, identifyId, sequenceNumber, CookieControl, _ga, _gid, _mkto_trk, __utmzz, __utmzzses, _ga, _gid, _mkto_trk, __utmzz, __utmzzses, ti, ch, ver, mid, evt, p, r, ec, ea, ev, el, gv, gc, fpc, CcsNtv, CcsWeb, Ccs, AADSSOTILES, ESTSUSERLIST, cltm, brcap, threxp, ifm, rrc, rn, tl, lt, lg, sc, sh, sw, pi, sid, msclkid, _uetsid, _uetvid, _uetmsclkid, CLID, clrc, _clck, _clsk, CkTst, MSPTC, MUID

cloudflare.com

Opt Out
__cfduid, cf_use_ob

google.com

Opt Out
_gat, _gid, _ga, _gaexp, __utma, __utmc, __utmz, __TAG_ASSISTANT, _gat_gtag_UA_*, _ga_*, _dc_gtm_*, _dc_gtm_UA-XXXXX-XX, _ga_XXXXXXXXXX, _GRECAPTCHA

amplitude.com

Opt Out
amp_fb0efa, amp_*, amp_*.organization.domain, AMP_MKTG_*, amp_9ff40c, amp_e5a2c9,amp_e3e918, amp_6d2283, amp_dd1a7b, amplitude_*, AMP_MKTG_*, access_token_production, driftt_aid, org_login_production, deviceId, userId, optOut, sessionId, lastEventTime, eventId, identifyId, sequenceNumber, CookieControl, _ga, _gid, _mkto_trk, __utmzz, __utmzzses

microsoft.com

Opt Out
ti, ch, ver, mid, evt, p, r, ec, ea, ev, el, gv, gc, fpc, CcsNtv, CcsWeb, Ccs, AADSSOTILES, ESTSUSERLIST, cltm, brcap, threxp, ifm, rrc, rn, tl, lt, lg, sc, sh, sw, pi, sid, msclkid, _uetsid, _uetvid, _uetmsclkid, CLID, clrc, _clck, _clsk, CkTst, MSPTC, MUID

Functionality

Functionality Cookies enable Us to provide enhanced functionality and personalisation. They may be set by Us or by third party providers whose services We have added to Our Sites. If you do not allow these cookies then some or all of these services may not function properly.

Cookies Used

APISID, __Secure-1, __Secure-2, __Secure-3, __Secure-1PAPISID, __Secure-2PAPISID, __Secure-3PAPISID, __Secure-1PSID, __Secure-2PSID, __Secure-3PSID, HSID, LOGIN_INFO, PREF, SAPISID, SID, SSID, VISITOR_INF, 1_LIVE, YSC, APISID, __Secure-1, __Secure-2, __Secure-3, __Secure-1PAPISID, __Secure-2PAPISID, __Secure-3PAPISID, __Secure-1PSID, __Secure-2PSID, __Secure-3PSID, HSID, SAPISID, SIDCC, PSIDCC, SOCS, NID, 1P_JAR, SID, SSID, DV, OGPC, AEC, __Secure-YEC, __Secure-BUCKET

youtube.com

Opt Out
APISID, __Secure-1, __Secure-2, __Secure-3, __Secure-1PAPISID, __Secure-2PAPISID, __Secure-3PAPISID, __Secure-1PSID, __Secure-2PSID, __Secure-3PSID, HSID, LOGIN_INFO, PREF, SAPISID, SID, SSID, VISITOR_INF, 1_LIVE, YSC

google.com

Opt Out
APISID, __Secure-1, __Secure-2, __Secure-3, __Secure-1PAPISID, __Secure-2PAPISID, __Secure-3PAPISID, __Secure-1PSID, __Secure-2PSID, __Secure-3PSID, HSID, SAPISID, SIDCC, PSIDCC, SOCS, NID, 1P_JAR, SID, SSID, DV, OGPC, AEC, __Secure-YEC, __Secure-BUCKET

Targeting

These cookies may be set through Our Sites by our advertising partners. They may be used by those companies to build a profile of your interests and show you relevant adverts on other sites. They do not store directly personal information, but are based on uniquely identifying your browser and internet device. If you do not allow these cookies, you will experience less targeted advertising.

Cookies Used

IDE, _hjClosedSurveyInvites, _hjDonePolls, _hjMinimizedPolls, _hjShownFeedbackMessage, _hjRecordingLastActivity, _hjTLDTest, _hjUserAttributesHash, _hjCachedUserAttributes, _hjLocalStorageTest, _hjIncludedInPageviewSample, _hjIncludedInSessionSample, _hjAbsoluteSessionInProgress, _hjid, cb, fr, usida, datr, wd, _fbp, tfw_exp, metrics_token, personalization_id, guest_id, guest_id_ads, guest_id_marketing, muc_ads, external_referer, _twitter_sess, ct0, lang, eu_cn, syndication_guest_id, m-b, m-b_lax, m-b_strict, m-css_v, m-early_v, m-s, m-sa, m-tgvs, m-tz, m-uid, bcookie, bscookie, JSESSIONID, lang, lidc, sdsc, li_gc, li_mc, UID, UserMatchHistory, AnalyticsSyncHistory, lms_ads, lms_analytics, li_fat_id, li_sugr, li_giant, oribi_cookie_test, oribili_user_guid , ln_or, ar_debug, _guid, BizographicsOptOut, BizoCustomSegments, BizoData, BizoID, BizoUserMatchHistory

doubleclick.com

Opt Out
IDE

hotjar.com

Opt Out
_hjClosedSurveyInvites, _hjDonePolls, _hjMinimizedPolls, _hjShownFeedbackMessage, _hjRecordingLastActivity, _hjTLDTest, _hjUserAttributesHash, _hjCachedUserAttributes, _hjLocalStorageTest, _hjIncludedInPageviewSample, _hjIncludedInSessionSample, _hjAbsoluteSessionInProgress, _hjid

facebook.com

Opt Out
cb, fr, usida, datr, wd, _fbp

twitter.com

Opt Out
tfw_exp, metrics_token, personalization_id, guest_id, guest_id_ads, guest_id_marketing, muc_ads, external_referer, _twitter_sess, ct0, lang, eu_cn, syndication_guest_id

quora.com

Opt Out
m-b, m-b_lax, m-b_strict, m-css_v, m-early_v, m-s, m-sa, m-tgvs, m-tz, m-uid

linkedin.com

Opt Out
bcookie, bscookie, JSESSIONID, lang, lidc, sdsc, li_gc, li_mc, UID, UserMatchHistory, AnalyticsSyncHistory, lms_ads, lms_analytics, li_fat_id, li_sugr, li_giant, oribi_cookie_test, oribili_user_guid , ln_or, ar_debug, _guid, BizographicsOptOut, BizoCustomSegments, BizoData, BizoID, BizoUserMatchHistory

Performance

Performance cookies allow Us to count visits and traffic sources so We can measure and improve the performance of Our Sites. They help Us to know which pages or features are the most and least popular and see how visitors move around Our Sites. If you do not allow these cookies We will not know when you have visited Our Sites, and will not be able to monitor their performance.

Cookies Used

_hssc, _hssrc, _hstc, hubspotuk, messagesUtk, _conv_v, _tt_enable_cookie, _hjSessionUser_*, csrf.app, __cf_bm, IR_PI, __hs_opt_out, _ttp, _cio, .customer.io, ajs_anonymous_id, _ga_*, _ga

hubspot.com

Opt Out
_hssc, _hssrc, _hstc, hubspotuk, messagesUtk, _conv_v, _tt_enable_cookie, _hjSessionUser_*, csrf.app, __cf_bm, IR_PI, __hs_opt_out, _ttp

customer.io

Opt Out
_cio, .customer.io, ajs_anonymous_id, _ga_*, _ga

Array ( [pll_language] => en_GB ) User agreed with cookies:
User does not agree gdprprivacy_bar cookies
User does not agree pll_language cookies
User does not agree wp_lang cookies
User does not agree LOGIN_INFO cookies
User does not agree APISID cookies
User does not agree _hjid cookies
User does not agree metrics_token cookies
User does not agree _ga cookies
User does not agree _hjAbsoluteSessionInProgress cookies
User does not agree _fbp cookies
User does not agree personalization_id cookies
User does not agree _hssc cookies