Unmerge cells - How to unmerge cells in microsoft excel worksheet 2020.

unmerge cells in excel

Unmerge cells

Posted on 30-03-2020 , by: admin , in Uncategorized , 0 Comments

Unmerge cells

Problem
I need to unmerge cells in excel worksheet.

Question
1. How I can unmerge cells in excel?

Solution(step by step)
Unmerge cells in Excel.

1. Select the cells from excel which you want to unmerge.
2. Click on down arrow of Merge & Center button in alignment group of home tab.

3. Click on Unmerge Cells.

4. Selected Cells will be unmerge.

Leave a comment Cancel comment

@media only screen and (max-width: 480px), only screen and (max-device-width: 780px){.latest-post-selection{display:unset !important;}.latest-post-selection article{width:100% !important;}#footer .wrapper{padding:0 0 0 0px !important;}footer #footer-top #footer-social{padding:0 20px 0 0;}}body #main{margin-top:5px;}.latest-post-selection article{margin-top:10px;margin-left:10px;}::-webkit-scrollbar{width:5px;}::-webkit-scrollbar-track{box-shadow:inset 0 0 5px grey;border-radius:10px;}::-webkit-scrollbar-thumb{background:#00a523;border-radius:10px;}.wrapper{padding:0 0 0 15px;}.latest-post-selection article{margin-top:10px;width:1607%;}.latest-post-selection{display:flex;}@media only screen and (max-width: 480px), only screen and (max-device-width: 780px){.menu-excel-main-container{height:100%;width:330px;position:unset;overflow-y:scroll;}}@media (min-width: 1025px) and (max-width: 3280px){.menu-excel-main-container{height:100%;width:275px;position:fixed;overflow-y:scroll;}}#footer-social h3{color:#207245;}.latest-post-selection article .read-more{padding:8px;float:right;background:#207245;border-radius:4px;color:white;}.latest-post-selection a{color:#207245;}.latest-post-selection article{margin-top:10px;}.breadcrumb-container{margin-top:8px;}.breadcrumb-container ul li a span{position:relative;bottom:8px;}@media (min-width: 1025px) and (max-width: 3280px){#header-navigation:hover{position:unset;width:110%;margin-top:108px;}#header-navigation{position:fixed;width:250px;margin-top:90px;}#main{top:108px;}.exhead-top{width:1155px;position:fixed;background:white;padding-top:10px;padding-bottom:11px;border-bottom:solid 3px green;display:flex;z-index:1;}}nav#site-navigation ul.nav-menu > li > a{font-size:14px !important;}.menu-item-type-post_type a{padding:2px 2px 2px 30px !important;}nav#site-navigation ul.nav-menu > li > a{padding:3px 3px 3px 30px !important;}.copy-the-code-button{background:#00a523 !important;padding:10px 20px !important;cursor:pointer !important;color:#fff !important;font-size:14px !important;font-weight:700 !important;border-radius:2px !important;text-transform:capitalize !important;border:none !important;margin-bottom:3px;}.copy-the-code-button:hover{background:#007233 !important;}.entry-header h2 a{font-weight:700;position:absolute;}.entry-header{display:none;}@media only screen and (max-width: 480px), only screen and (max-device-width: 780px){#buttonmobo .elementor-top-column:nth-child(2){position:absolute;width:50%;left:50%;}}@media only screen and (max-width: 480px), only screen and (max-device-width: 780px){.navbar{display:none !important;}}@media only screen and (max-width: 480px), only screen and (max-device-width: 780px){.logo{margin-left:98px !important;}}.navbar-light .navbar-nav .nav-link{color:#207245;font-size:17px;}.bg-light{background-color:#207245 !important;width:75%;margin-left:50px;border-radius:5px;}#navbarNav ul li,ol li{line-height:32px;margin-right:2px;background:gainsboro;border:solid green;border-radius:5px;margin-left:0px;padding:1px 15px;}#navbarNav ul li:hover{background:#00a523;}.navbar-light .navbar-nav .nav-link:hover{color:white;}table,th,td{border:1px solid rgba(158,158,158,.59);}#comments{display:none;}@media (min-width: 481px) and (max-width: 1024px) and (orientation: landscape){.elementor-container .elementor-row .has_ae_slider:first-child .elementor-column-wrap .elementor-widget-wrap .elementor-button-warning .elementor-widget-container{position:absolute;top:20px;}}#masthead img{margin-left:40px;margin-top:5px;}@media (min-width: 1025px) and (max-width: 1980px){#masthead .header #header-logo{display:none;}}#masthead .header #header-logo img{visibility:hidden;}#masthead .header #header-logo .icon_cart_wrap{visibility:hidden;}#masthead .header #header-logo .mobile-search-icon .header a{margin-top:9px;margin-right:15px;}.entry-meta{display:none;}.header-top{display:none;}nav#site-navigation ul.nav-menu li a:hover,nav#site-navigation ul.nav-menu li a:focus{background:#8bc34a;color:#fff;}#main #primary #content article .entry-header{margin-top:15px;}nav#site-navigation ul.nav-menu li#menu-item-13783 a,nav#site-navigation ul.nav-menu li#menu-item-13793 a,nav#site-navigation ul.nav-menu li#menu-item-13788 a{background:#207245;color:white;}nav#site-navigation ul.nav-menu li#menu-item-13904 a,nav#site-navigation ul.nav-menu li#menu-item-14003 a,nav#site-navigation ul.nav-menu li#menu-item-14004 a,nav#site-navigation ul.nav-menu li#menu-item-14005 a,nav#site-navigation ul.nav-menu li#menu-item-14006 a,nav#site-navigation ul.nav-menu li#menu-item-14007 a,nav#site-navigation ul.nav-menu li#menu-item-14008 a,nav#site-navigation ul.nav-menu li#menu-item-14009 a,nav#site-navigation ul.nav-menu li#menu-item-14010 a,nav#site-navigation ul.nav-menu li#menu-item-14800 a,nav#site-navigation ul.nav-menu li#menu-item-14782 a{background:#00a523;color:white;}nav#site-navigation ul.nav-menu li.current-menu-item > a,nav#site-navigation ul.nav-menu li.current-menu-ancestor > a,nav#site-navigation ul.nav-menu li.current-menu-parent > a,nav#site-navigation ul.nav-menu li.current_page_parent > a,nav#site-navigation ul.nav-menu li.current_page_ancestor > a{background:#8bc34a;color:#fff;border-bottom:2px solid #4c7f11;}footer #footer-top #footer-social{background:#207245 !important;}footer #footer-bottom #back_to_top{top:80%;}.menu-excel-main-container ul{margin-bottom:140px !important;}