Excel Blog - Latest Excel tips, tutorials, and videos.

div#ez-toc-container p.ez-toc-title{font-size:100%;}div#ez-toc-container p.ez-toc-title{font-weight:700;}div#ez-toc-container ul li{font-size:95%;}div#ez-toc-container{width:75%;}body{background-color:#fff;color:#3a3a3a;}a{color:#1e73be;}a:hover,a:focus,a:active{color:#000;}body .grid-container{max-width:1100px;}.wp-block-group__inner-container{max-width:1100px;margin-left:auto;margin-right:auto;}body,button,input,select,textarea{font-family:"Lato",sans-serif;}body{line-height:1.8;}.entry-content > [class*="wp-block-"]:not(:last-child){margin-bottom:1.5em;}.main-title{font-family:"Lato",sans-serif;font-size:45px;}.main-navigation .main-nav ul ul li a{font-size:14px;}.sidebar .widget,.footer-widgets .widget{font-size:17px;}h1{font-weight:600;font-size:40px;}h2{font-weight:600;font-size:36px;line-height:1.4em;}h3{font-weight:600;font-size:30px;line-height:1.4em;}h4{font-weight:600;font-size:26px;line-height:1.4em;}h5{font-weight:600;font-size:22px;line-height:1.4em;}@media (max-width:768px){.main-title{font-size:30px;}h1{font-size:30px;}h2{font-size:25px;}}.top-bar{background-color:#636363;color:#fff;}.top-bar a{color:#fff;}.top-bar a:hover{color:#303030;}.site-header{background-color:#fff;color:#3a3a3a;}.site-header a{color:#3a3a3a;}.main-title a,.main-title a:hover{color:#222;}.site-description{color:#757575;}.main-navigation,.main-navigation ul ul{background-color:#222;}.main-navigation .main-nav ul li a,.menu-toggle,.main-navigation .menu-bar-items{color:#fff;}.main-navigation .main-nav ul li:hover > a,.main-navigation .main-nav ul li:focus > a,.main-navigation .main-nav ul li.sfHover > a,.main-navigation .menu-bar-item:hover > a,.main-navigation .menu-bar-item.sfHover > a{color:#fff;background-color:#3f3f3f;}button.menu-toggle:hover,button.menu-toggle:focus,.main-navigation .mobile-bar-items a,.main-navigation .mobile-bar-items a:hover,.main-navigation .mobile-bar-items a:focus{color:#fff;}.main-navigation .main-nav ul li[class*="current-menu-"] > a{color:#fff;background-color:#3f3f3f;}.main-navigation .main-nav ul li[class*="current-menu-"] > a:hover,.main-navigation .main-nav ul li[class*="current-menu-"].sfHover > a{color:#fff;background-color:#3f3f3f;}.navigation-search input[type="search"],.navigation-search input[type="search"]:active,.navigation-search input[type="search"]:focus,.main-navigation .main-nav ul li.search-item.active > a,.main-navigation .menu-bar-items .search-item.active > a{color:#fff;background-color:#3f3f3f;}.main-navigation ul ul{background-color:#3f3f3f;}.main-navigation .main-nav ul ul li a{color:#fff;}.main-navigation .main-nav ul ul li:hover > a,.main-navigation .main-nav ul ul li:focus > a,.main-navigation .main-nav ul ul li.sfHover > a{color:#fff;background-color:#4f4f4f;}.main-navigation .main-nav ul ul li[class*="current-menu-"] > a{color:#fff;background-color:#4f4f4f;}.main-navigation .main-nav ul ul li[class*="current-menu-"] > a:hover,.main-navigation .main-nav ul ul li[class*="current-menu-"].sfHover > a{color:#fff;background-color:#4f4f4f;}.separate-containers .inside-article,.separate-containers .comments-area,.separate-containers .page-header,.one-container .container,.separate-containers .paging-navigation,.inside-page-header{background-color:#fff;}.entry-meta{color:#595959;}.entry-meta a{color:#595959;}.entry-meta a:hover{color:#1e73be;}.sidebar .widget{background-color:#fff;}.sidebar .widget .widget-title{color:#000;}.footer-widgets{background-color:#fff;}.footer-widgets .widget-title{color:#000;}.site-info{color:#fff;background-color:#222;}.site-info a{color:#fff;}.site-info a:hover{color:#606060;}.footer-bar .widget_nav_menu .current-menu-item a{color:#606060;}input[type="text"],input[type="email"],input[type="url"],input[type="password"],input[type="search"],input[type="tel"],input[type="number"],textarea,select{color:#666;background-color:#fafafa;border-color:#ccc;}input[type="text"]:focus,input[type="email"]:focus,input[type="url"]:focus,input[type="password"]:focus,input[type="search"]:focus,input[type="tel"]:focus,input[type="number"]:focus,textarea:focus,select:focus{color:#666;background-color:#fff;border-color:#bfbfbf;}button,html input[type="button"],input[type="reset"],input[type="submit"],a.button,a.wp-block-button__link:not(.has-background){color:#fff;background-color:#666;}button:hover,html input[type="button"]:hover,input[type="reset"]:hover,input[type="submit"]:hover,a.button:hover,button:focus,html input[type="button"]:focus,input[type="reset"]:focus,input[type="submit"]:focus,a.button:focus,a.wp-block-button__link:not(.has-background):active,a.wp-block-button__link:not(.has-background):focus,a.wp-block-button__link:not(.has-background):hover{color:#fff;background-color:#3f3f3f;}a.generate-back-to-top{background-color:rgba(0,0,0,.4);color:#fff;}a.generate-back-to-top:hover,a.generate-back-to-top:focus{background-color:rgba(0,0,0,.6);color:#fff;}@media (max-width: 768px){.main-navigation .menu-bar-item:hover > a,.main-navigation .menu-bar-item.sfHover > a{background:none;color:#fff;}}.inside-top-bar{padding:10px;}.inside-header{padding:40px;}.entry-content .alignwide,body:not(.no-sidebar) .entry-content .alignfull{margin-left:-40px;width:calc(100% + 80px);max-width:calc(100% + 80px);}.rtl .menu-item-has-children .dropdown-menu-toggle{padding-left:20px;}.rtl .main-navigation .main-nav ul li.menu-item-has-children > a{padding-right:20px;}.site-info{padding:20px;}@media (max-width:768px){.separate-containers .inside-article,.separate-containers .comments-area,.separate-containers .page-header,.separate-containers .paging-navigation,.one-container .site-content,.inside-page-header,.wp-block-group__inner-container{padding:30px;}.site-info{padding-right:10px;padding-left:10px;}.entry-content .alignwide,body:not(.no-sidebar) .entry-content .alignfull{margin-left:-30px;width:calc(100% + 60px);max-width:calc(100% + 60px);}}.one-container .sidebar .widget{padding:0px;}@media (max-width: 768px){.main-navigation .menu-toggle,.main-navigation .mobile-bar-items,.sidebar-nav-mobile:not(#sticky-placeholder){display:block;}.main-navigation ul,.gen-sidebar-nav{display:none;}[class*="nav-float-"] .site-header .inside-header > *{float:none;clear:both;}}.ez-toc-title-container{padding-bottom:12px;padding-top:12px;}div#ez-toc-container ul li{line-height:200%;}#ez-toc-container a:visited{color:#444;}#ez-toc-container{margin-top:1em;}li{margin-bottom:20px;margin-top:20px;}.cbyellow,.cbred,.cbgreen,.cbblue{margin:0 0 25px;overflow:hidden;padding:20px;color:#424242;}.cbgreen{background-color:#d9edc2;border-left:5px solid #b2ce96;}.cbred{background-color:#f9dbdb;border-left:5px solid #e9b3b3;}.cbyellow{background-color:#fef5c4;border-left:5px solid #fadf98;}.cbblue{background-color:#e7f2ff;border-left:5px solid #afcde3;}.elementor img{border:2px solid #d5d5d5;margin-bottom:20px;margin-top:20px;}pre{line-height:1.8;}p{margin-top:1.5em;}pre{white-space:pre-wrap;}

How to Combine Duplicate Rows and Sum the Values in Excel

How to Lock Row Height & Column Width in Excel (Easy Trick)

How to Find Range in Excel (Easy Formulas)

How to Hide Formulas in Excel (and Only Display the Value)

How to Change Row Height in Excel (5 Easy Ways)

7 Easy Ways to Select Multiple Cells in Excel

How to Remove Leading Zeros in Excel (5 Easy Ways)

How to Indent in Excel (3 Easy Ways + Keyboard Shortcut)

How to Unmerge Cells in Excel (3 Easy Ways + Shortcut)