Excel 2024: Circle Invalid Data Automatically


February 10, 2025 - by

Excel 2024: Circle Invalid Data Automatically

You have some numbers in a worksheet. Those cells should be between 60 and 90 inclusive.

Select the range of data. On the Data tab, open Data Validation. Allow a Whole Number. Choose Between and 60 and 90. Click OK.

continue reading »

More Reading


Excel 2024: Temporarily Make Formula Bar Font Size Larger

Excel 2024: Temporarily Make Formula Bar Font Size Larger »

February 5, 2025 - by Bill Jelen


Say you have a Zoom or Teams call and you temporarily need to make the font size in the formula bar larger.

Excel 2024: Avoid Whiplash with Speak Cells

Excel 2024: Avoid Whiplash with Speak Cells »

January 30, 2025 - by Bill Jelen


One of the painful parts about keying in data is that you have to proofread the numbers. So, you are looking at the sheet of paper, then the screen, then the paper, then the screen. You will end up with a sore neck. Wouldn't it be nice if you had someone to read you the screen so you can keep your eye on the paper? It's built in to Excel.

Excel 2024: Word for Excellers

Excel 2024: Word for Excellers »

January 27, 2025 - by Bill Jelen


While Excel fans sometimes tease that Word and PowerPoint are freeware apps that come with Excel, there are times when Microsoft Word offers a feature that Excel does not. In those cases, it makes sense to copy your data from Excel, paste to Word, do the command, then copy back to Excel.

read more articles »

Featured Products


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.


Financial Modelling for Project Finance

December 2024

If you have a beginner’s grasp in accounting, finance and Excel, you might be tempted to explore the quantitative, decision-centric world of Project Finance, ring-fencing funding for profitable projects. This book seeks to demystify the area and show how the basic principles of financial modelling.


MrExcel 2022 Boosting Excel

April 2022

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


Microsoft 365 Excel: The Only App That Matters

June 2022

Excel Worksheet, Power Query, Power Pivot, Power BI. Calculations, Analytics, Modeling, Data Analysis and Dashboard Reporting for the New Era of Dynamic Data Driven Decision Making & Insight!


see more products »