MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2019: A Great April Fool’s Day Trick


December 5, 2019 - by Bill Jelen

A Great April Fool’s Day Trick Photo credit: Ferdinand Stöhr at Unsplash.com.

Do you want a harmless prank to pull on a co-worker? When he leaves his desk to grab a cup of coffee, add the fifth icon to his Quick Access Toolbar: Speak Cells on Enter. Click the icon once, and the computer will say, “Cells will now be spoken on Enter.”

Once you’ve turned on Speak Cells on Enter, right-click the icon in the Quick Access Toolbar and choose Remove from Quick Access Toolbar to hide any sign that you were there.

continue reading »

More Reading


Excel Provide Feedback with Sound. Photo Credit: Denisse Leon at Unsplash.com

Excel 2019: Provide Feedback with Sound »

December 4, 2019 - by Bill Jelen


Excel now provides confirmation with gentle sounds when you do many tasks.

Avoid Whiplash with Speak Cells. Photo Credit: Chris Leipelt at Unsplash.com

Excel 2019: Avoid Whiplash with Speak Cells »

December 2, 2019 - 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.

read more articles »


Supercharge your career with training from MrExcel

Featured Products


Excel JavaScript UDFs Straight to the Point

Excel JavaScript UDFs Straight to the Point »


JavaScript custom functions - UDFs can be used like any other native functions or UDFs in Excel. This book shows the process of creating JavaScript UDFs in Excel Developer Preview for Office Insider program subscribers.

Excel Custom Functions Straight to the Point

Excel Custom Functions Straight to the Point »


Excel Custom Functions can be used like any other native functions or user defined functions in Excel. This book shows the process of creating Excel Custom Functions.

Microsoft Excel 2019 Pivot Table Data Crunching

Microsoft Excel 2019 Pivot Table Data Crunching »


Use Excel 2019 pivot tables and pivot charts to produce powerful, dynamic reports in minutes instead of hours, to take control of your data and your business. Even if you’ve never created a pivot table before, this book will help you leverage all their remarkable flexibility and analytical power–including valuable improvements in Excel 2019 and Excel in Office 365.

Excel Data Cleansing Straight To The Point

Excel Data Cleansing Straight To The Point »


This Straight to the Point guide provides an introduction to data cleansing, which also goes by names such as data munging and data wrangling. Whatever the name, it basically means doing what needs to be done to make data useful and trustworthy.

MrExcel LX – The Holy Grail of Excel Tips

MrExcel LX – The Holy Grail of Excel Tips »


A book for people who use Excel 40+ hours per week. Illustrated in full color.

Supercharge Excel When You Learn to Write DAX For Power Pivot

Supercharge Excel When You Learn to Write DAX For Power Pivot »


Hands-on book to learn and master the DAX language!

see more products »