Excel Formula

Latest Posts

How to Find Duplicate in Excel?

How to Find Duplicate in Excel?

Find and remove duplicate in excel| To find duplicates in Excel, use the Conditional Formatting feature. Select the range of data, then g...

How to Insert a Calendar in Excel

How to Insert a Calendar in Excel

Inserting a calendar into Excel can help manage dates, deadlines, and events more efficiently. Whether you’re looking for a drop-down calend...

How to Insert Headers and Footers in Excel

How to Insert Headers and Footers in Excel

Headers and footers are helpful for organizing your Excel worksheets, especially when printing them. They allow you to insert additional inf...

Insert Row in Excel Shortcut Key

Insert Row in Excel Shortcut Key

In Excel, inserting a row is a common task that can be accomplished quickly using a shortcut key. The shortcut key for inserting a row in Ex...

Excel: How to protect cells?

Excel: How to protect cells?

Locking cells in Excel helps prevent accidental changes or edits, ensuring data integrity. Whether you want to protect specific cells, allow...

How to protect only certain cells in excel

How to protect only certain cells in excel

When working with sensitive data in Excel, there might be times when you want to prevent changes to specific cells while keeping the rest of...

How to Protect a Cell in Excel

How to Protect a Cell in Excel

Protecting cells in Excel is essential when you want to prevent unwanted changes to certain parts of your worksheet while allowing other sec...

Show more

Showing

No More Posts

window['__wavt'] = 'AOuZoY5UaKMFIj74JXtkV05cs-_sp0P9UA:1733191112243';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d6571197898080719811','//www.excel-formula.com/','6571197898080719811'); _WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '6571197898080719811', 'title': 'Excel Formula ', 'url': 'https://www.excel-formula.com/', 'canonicalUrl': 'https://www.excel-formula.com/', 'homepageUrl': 'https://www.excel-formula.com/', 'searchUrl': 'https://www.excel-formula.com/search', 'canonicalHomepageUrl': 'https://www.excel-formula.com/', 'blogspotFaviconUrl': 'https://www.excel-formula.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': '', 'encoding': 'UTF-8', 'locale': 'en', 'localeUnderscoreDelimited': 'en', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Excel Formula - Atom\x22 href\x3d\x22https://www.excel-formula.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22Excel Formula - RSS\x22 href\x3d\x22https://www.excel-formula.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Excel Formula - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/6571197898080719811/posts/default\x22 /\x3e\n', 'meTag': '\x3clink rel\x3d\x22me\x22 href\x3d\x22https://www.blogger.com/profile/00632895841370585127\x22 /\x3e\n', 'adsenseClientId': 'ca-pub-4646798504000105', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': true, 'adsenseAutoAds': true, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/0399bd29ab1434ad', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Get link', 'key': 'link', 'shareMessage': 'Get link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Share to Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'X', 'key': 'twitter', 'shareMessage': 'Share to X', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Share to Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27en\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': false, 'jumpLinkMessage': 'Read more', 'pageType': 'index', 'pageName': '', 'pageTitle': 'Excel Formula ', 'metaDescription': 'Excel Formula is your go-to site to learn and master Excel for free with easy guides and tips for all skill levels.'}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Link copied to clipboard!', 'ok': 'Ok', 'postLink': 'Post Link'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Custom', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': 'Excel Formula ', 'description': 'Excel Formula is your go-to site to learn and master Excel for free with easy guides and tips for all skill levels.', 'url': 'https://www.excel-formula.com/', 'type': 'feed', 'isSingleItem': false, 'isMultipleItems': true, 'isError': false, 'isPage': false, 'isPost': false, 'isHomepage': true, 'isArchive': false, 'isLabelSearch': false}}, {'name': 'widgets', 'data': [{'title': 'Excel Formula (Header)', 'type': 'Header', 'sectionId': 'logo', 'id': 'Header1'}, {'title': 'Pages', 'type': 'PageList', 'sectionId': 'pages', 'id': 'PageList1'}, {'title': 'Social Media icons', 'type': 'LinkList', 'sectionId': 'topsocialL', 'id': 'LinkList3'}, {'title': 'Main Menu', 'type': 'LinkList', 'sectionId': 'menu', 'id': 'LinkList001'}, {'title': 'search ...', 'type': 'BlogSearch', 'sectionId': 'searchform', 'id': 'BlogSearch2'}, {'title': 'table of contents feature', 'type': 'HTML', 'sectionId': 'AddOns', 'id': 'HTML1'}, {'title': 'contact form', 'type': 'ContactForm', 'sectionId': 'AddOns', 'id': 'ContactForm200'}, {'title': 'Blog Posts', 'type': 'Blog', 'sectionId': 'Tempnec', 'id': 'Blog1', 'posts': [{'id': '3228625590129259517', 'title': 'How to Find Duplicate in Excel?', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiOkLjRd04ZhTVdRvWy5ngJW-sqMk8oY8UWYWdSxVymQVfgq7YVYL-_ZEjag4o0qvS1Vw0CrbhsBswdsrHO8tdMCGQFd5H2K3ta20Q46vysC8wDYDcLgbCzBJrGrDXbTG_FZOnhXspcLcwu_CyWGBtYdk-NPfVbPzbT_URsouLsxdYb5d5E_QASDQD-Z-HF/w640-h362/how-to-find-duplicate-in-excel.webp', 'showInlineAds': false}, {'id': '5580606121535032329', 'title': 'How to Insert a Calendar in Excel', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgaC0rScoIZBdA0TykNdRhMQ1FDtysSPZE3Cg47kkZiwCiKlz_tHNUFKlSgGo2CxXuaBFbMxdHVbh9vgm-0yCtfddxkHEHnQxIyBa1C2yTCKfUL29RTyj-ZcnH9Jcnb2ukbzGAoVz8S1BnTF1iHSs2E2d0HQozMssf6mZF5HKrNQDRk5pYBW5v0ofHakRle/w640-h360/how-to-insert-a-calendar-in-excel.webp', 'showInlineAds': false}, {'id': '4159951143012790634', 'title': 'How to Insert Headers and Footers in Excel', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiEjZzUs2TTgd3ZfjgX_loaYwmkcVt1dTaKFiCPCgHk2Iqf3opWsjkfGDq6ljnaX47l3y-OiygdwPmIHvK56pLgVkTKerH4O07H4Esy4oJhS3NKTqVWO8ixMcTsoHQQoXSLhrQ-0c4XIzgs69QsBNF2HwEZpRfX1TTlwvZVlmxEWhfd-HKuDYZ6E2d0krPz/w640-h360/how-to-insert-headers-and-footers-in-excel.webp', 'showInlineAds': false}, {'id': '4317970457712986528', 'title': 'Insert Row in Excel Shortcut Key', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgA5MPFf42ciHsqv_fdK8jFqjnkazFy12IvoXo4bEjp5T1mfbOB23exSrdp9K7A4YDKkih0WyTqCxz4qYKM5aPQr_eotTdfgGLxGNJWIfjapPJ2f9OgIDjMRzD2t62ZIv7F2NiY4DT0xkzBvyKoNn-oG5m7km7dZowZ45PNQ8IuWX9anmn-y7YJA_kn51jT/w640-h360/insert-row-in-excel-shortcut-key.webp', 'showInlineAds': false}, {'id': '3964375002840130680', 'title': 'Excel: How to protect cells?', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhAWNw-Akk_OAZkbbEa3Y_ts7f5nREgUoZRDlk0PGKQj8MAWfyT_ViRvUTvnf5YhJD6MrsPf-Vy5dlAElUL_2rrUawYE2lGT6eIbhUk1SsY933jQ2cLH0w4_nWXSefzdqgo-UPfX1MExRtnkhgfRDIWJThBGEso9MlJrHYyzUZ-UfJxRxX05jQakFh-C_42/w640-h360/excel-how-to-protect-cells.webp', 'showInlineAds': false}, {'id': '3067475874555434323', 'title': 'How to protect only certain cells in excel', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjQxhgGQkNr4XayWp0GHXYrMCRPb7tRTJDZdi9zhJYJAeVXiLc6bg__WZ8Fgj8e_jQq5BdFctPTqEvBVTRmXEz0m533urpF5-8F4PCmja7jK7CVXO5KzZ8JrBfFVhMYgttSrvzyP0r6VHe_8NC4OCABpWQAtsHpJ4m6Ovs0AIsFNuGO_o15LaQyY2CKf04u/w640-h360/how-to-protect-only-certain-cells-in-excel.webp', 'showInlineAds': false}, {'id': '952918591763884819', 'title': 'How to Protect a Cell in Excel', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg7sHD-SY07Obv2Bn06YwU1-4i26xbogPlK90yRmm6do9llrQNKCQLF00jIlwZCUlUZWUeETGYfhmhH_JrojgwWBNMlzphzWHfpgxyDPULVDfd2oiOO5-kU0gKszu0yHwRETwcq5tiW6EH8YdbCeUqbPWgrowMzxpzlxHLtfEjJq1PBP2woa0YqCDbUUwlq/w640-h360/how-to-protect-a-cell-in-excel.webp', 'showInlineAds': false}], 'headerByline': {'regionName': 'header1', 'items': [{'name': 'share', 'label': ''}, {'name': 'author', 'label': 'Written by:'}, {'name': 'timestamp', 'label': '-'}]}, 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'comments', 'label': 'comments'}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': ''}]}], 'allBylineItems': [{'name': 'share', 'label': ''}, {'name': 'author', 'label': 'Written by:'}, {'name': 'timestamp', 'label': '-'}, {'name': 'comments', 'label': 'comments'}, {'name': 'labels', 'label': ''}]}, {'title': 'Featured Post', 'type': 'FeaturedPost', 'sectionId': 'sidepar', 'id': 'FeaturedPost1', 'postId': '3228625590129259517'}, {'title': 'social media icons', 'type': 'LinkList', 'sectionId': 'sidepar', 'id': 'LinkList4'}, {'title': '', 'type': 'PopularPosts', 'sectionId': 'sidepar', 'id': 'PopularPosts1', 'posts': [{'title': 'How to protect only certain cells in excel', 'id': 3067475874555434323}, {'title': 'How to Insert a Calendar in Excel', 'id': 5580606121535032329}, {'title': 'How to Find Duplicate in Excel?', 'id': 3228625590129259517}, {'title': 'How to Insert Headers and Footers in Excel', 'id': 4159951143012790634}, {'title': 'Insert Row in Excel Shortcut Key', 'id': 4317970457712986528}, {'title': 'Excel: How to protect cells?', 'id': 3964375002840130680}, {'title': 'How to Protect a Cell in Excel', 'id': 952918591763884819}, {'title': 'How to Automatically Apply and Update Formulas in Excel?', 'id': 7500195495322890619}, {'title': 'How to Apply the Same Formula to an Entire Column in Excel?', 'id': 3252630612995831484}, {'title': 'How to Auto Update Formulas in Excel When New Rows are Inserted?', 'id': 8775323811157573571}]}]}]); _WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header1', 'logo', document.getElementById('Header1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_PageListView', new _WidgetInfo('PageList1', 'pages', document.getElementById('PageList1'), {'title': 'Pages', 'links': [{'isCurrentPage': false, 'href': 'https://www.excel-formula.com/', 'id': '0', 'title': 'Home Page'}], 'mobile': false, 'showPlaceholder': true, 'hasCurrentPage': false}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList3', 'topsocialL', document.getElementById('LinkList3'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList001', 'menu', document.getElementById('LinkList001'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_BlogSearchView', new _WidgetInfo('BlogSearch2', 'searchform', document.getElementById('BlogSearch2'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML1', 'AddOns', document.getElementById('HTML1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_ContactFormView', new _WidgetInfo('ContactForm200', 'AddOns', document.getElementById('ContactForm200'), {'contactFormMessageSendingMsg': 'Sending...', 'contactFormMessageSentMsg': 'Your message has been sent.', 'contactFormMessageNotSentMsg': 'Message could not be sent. Please try again later.', 'contactFormInvalidEmailMsg': 'A valid email address is required.', 'contactFormEmptyMessageMsg': 'Message field cannot be empty.', 'title': 'contact form', 'blogId': '6571197898080719811', 'contactFormNameMsg': 'Name', 'contactFormEmailMsg': 'Email', 'contactFormMessageMsg': 'Message', 'contactFormSendMsg': 'Send', 'contactFormToken': 'AOuZoY69p8L44Xt1UyTSMY4h4-omwtSzyQ:1733191112243', 'submitUrl': 'https://www.blogger.com/contact-form.do'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'Tempnec', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/1552201831-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/1964470060-lightbox_bundle.css'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_FeaturedPostView', new _WidgetInfo('FeaturedPost1', 'sidepar', document.getElementById('FeaturedPost1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList4', 'sidepar', document.getElementById('LinkList4'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts1', 'sidepar', document.getElementById('PopularPosts1'), {}, 'displayModeFull'));