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,a:visited{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;}.main-navigation .main-nav ul ul li a{font-size:14px;}h1{font-weight:600;}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,.top-bar a:visited{color:#fff;}.top-bar a:hover{color:#303030;}.site-header{background-color:#fff;color:#3a3a3a;}.site-header a,.site-header a:visited{color:#3a3a3a;}.main-title a,.main-title a:hover,.main-title a:visited{color:#222;}.site-description{color:#757575;}.main-navigation,.main-navigation ul ul{background-color:#222;}.main-navigation .main-nav ul li a,.menu-toggle{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{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{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,.entry-meta a:visited{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,.site-info a:visited{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.button:visited,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;}.generate-back-to-top,.generate-back-to-top:visited{background-color:rgba(0,0,0,.4);color:#fff;}.generate-back-to-top:hover,.generate-back-to-top:focus{background-color:rgba(0,0,0,.6);color:#fff;}.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;}@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;}.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;}}@font-face{font-family:"GeneratePress";src:url("https://v1.nitrocdn.com/zciqOWZgDznkuqFpvIJsLUeyHlJtlHxe/assets/static/source/rev-e2759db/wp-content/themes/generatepress/fonts/generatepress.eot");src:url("https://v1.nitrocdn.com/zciqOWZgDznkuqFpvIJsLUeyHlJtlHxe/assets/static/source/rev-e2759db/wp-content/themes/generatepress/fonts/generatepress.eot#iefix") format("embedded-opentype"),url("https://v1.nitrocdn.com/zciqOWZgDznkuqFpvIJsLUeyHlJtlHxe/assets/static/source/rev-e2759db/wp-content/themes/generatepress/fonts/generatepress.woff2") format("woff2"),url("https://v1.nitrocdn.com/zciqOWZgDznkuqFpvIJsLUeyHlJtlHxe/assets/static/source/rev-e2759db/wp-content/themes/generatepress/fonts/generatepress.woff") format("woff"),url("https://v1.nitrocdn.com/zciqOWZgDznkuqFpvIJsLUeyHlJtlHxe/assets/static/source/rev-e2759db/wp-content/themes/generatepress/fonts/generatepress.ttf") format("truetype"),url("https://v1.nitrocdn.com/zciqOWZgDznkuqFpvIJsLUeyHlJtlHxe/assets/static/source/rev-e2759db/wp-content/themes/generatepress/fonts/generatepress.svg#GeneratePress") format("svg");font-weight:normal;font-style:normal;font-display:swap;}.main-navigation .slideout-toggle a:before,.slide-opened .slideout-overlay .slideout-exit:before{font-family:GeneratePress;}.slideout-navigation .dropdown-menu-toggle:before{content:"" !important;}.slideout-navigation .sfHover > a .dropdown-menu-toggle:before{content:"" !important;}.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;}

Excel AUTOFIT: Make Rows/Columns Fit the Text Automatically

How to Rename a Sheet in Excel (4 Easy Ways + Shortcut)

How to Print Excel Sheet on One Page (Fit to One Page)

How to Capitalize First Letter of a Text String in Excel (using Formula & VBA)

#REF! Error in Excel – How to Fix the Reference Error!

How to Insert / Delete Comments in Excel (including Shortcuts)

How to Group Worksheets in Excel (Step-by-Step)

How to Calculate Average Annual Growth Rate (AAGR) in Excel

How to SUM values between two dates (using SUMIFS formula)