Excel 2024: Protect All Formula Cells


October 21, 2024 - by

Excel 2024: Protect All Formula Cells

The use of worksheet protection in Excel is a little strange. Using the steps below, you can quickly protect just the formula cells in your worksheet.

It seems unusual, but all 16 billion cells on a worksheet start out with their Locked property set to True. You need to unlock all of the cells first:

continue reading »

More Reading


Excel 2024: Split Text into Words Using TEXTSPLIT

Excel 2024: Split Text into Words Using TEXTSPLIT »

October 18, 2024 - by Bill Jelen


Many people had been asking for TEXTSPLIT. It was one of the most popular requests on the Excel UserVoice site. I often used a three-line User-Defined Function from Excel MVP Brad Yundt to create a function to split text into words.

Excel 2024: Text Before or After a Specific Delimiter

Excel 2024: Text Before or After a Specific Delimiter »

October 15, 2024 - by Bill Jelen


The new TEXTBEFORE and TEXTAFTER functions debuted on March 16, 2022 for Microsoft 365 Insiders. These functions isolate the text before or after a specific delimiter.

Excel 2024: Find Largest Value That Meets One or More Criteria

Excel 2024: Find Largest Value That Meets One or More Criteria »

October 11, 2024 - by Bill Jelen


One of the new Office 365 functions added in February 2016 is the MAXIFS function. This function, which is similar to SUMIFS, finds the largest value that meets one or more criteria: You can either hard-code the criterion as in row 7 below or point to cells as in row 9. A similar MINIFS function finds the smallest value that meets one or more criteria.

read more articles »

Featured Products


The Transformative Magic of Power Query M Code in Excel and Power BI

August 2024

A beginner’s guide to mastering the art of data metamorphosis to get just the data structure needed to create insightful data analysis solution


Guerrilla Data Analysis Using Microsoft Excel - 3rd Edition

May 2022

Two of the leading Excel channels on YouTube join forces to combat bad data. This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These are tips honed by Bill Jelen, "MrExcel," and Oz do Soleil during their careers run as financial analysts.


MrExcel 2024 Igniting Excel

February 2024

This is the 7th edition of MrExcel XL. Updates for 2024 include: Remove Filter Items Using Search Box, The Consolas Font Makes it Easy to Tell Zero from the Letter O, Display Online Pictures In a Cell Using a Formula, Place Pictures In Cell From Local Computer, Using Artificial Intelligence with Copilot for Excel, and more...


MrExcel 2022 Boosting Excel

April 2022

The 6th Edition of MrExcel XL, updated with new functions released for Microsoft 365.


see more products »