MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel Tips

Calculate Workdays for 5, 6, and 7 Day Workweeks

Calculate Workdays for 5, 6, and 7 Day Workweeks »

January 22, 2021

Calculate how many workdays fall between two dates. Excel’s NETWORKDAYS function does this if you happen to work the five days between Monday and Friday inclusive. This topic will show you how to perform the calculation for a company that works 5, 6, or 7 days a week.

Find the First Non-blank Value in a Row

Find the First Non-blank Value in a Row »

January 20, 2021

You want to build a formula to return the first non-blank cell in a row. Perhaps columns B:K reflect data at various points in time. Due to the sampling methodology, certain items are checked infrequently.

Excel Stories

Excel Stories »

January 6, 2021

When you hand the world’s most flexible software to 750 million people, everyone finds interesting things to do or interesting ways to use Excel. I love traveling to do the in-person Excel seminars because I get to meet these people. At every seminar, someone has an interesting story of how they are using Excel.

Excel More Excel Tips. Photo Credit: Sam Truong Dan at

Excel 2020: More Excel Tips »

January 4, 2021

I published more than 200 ideas since February. While the following ideas did not get much press here, they are self-explanatory in a 140-character tweet.

Excel Ctrl+Click To Unselect Cells. Photo Credit: Timothy Muza at

Excel 2020: Ctrl+Click to Unselect Cells »

December 30, 2020

You've always had the ability to select multiple selections in Excel by Ctrl+Dragging to select cells. However, in the past, there was no way to unselect one cell. You can now Ctrl + Click to unselect that cell.

Favorite Keyboard Shortcuts. Photo Credit: Juan Gomez at

Excel 2020: Favorite Keyboard Shortcuts »

December 28, 2020

As I started polling readers about their favorite Excel tips, a large number of them were keyboard shortcuts. Following keyboard shortcuts are presented in order of popularity.

Excel Settings in the Excel Options Menu. Photo Credit: Manuel Boxler at

Excel 2020: Settings in the Excel Options Menu »

December 24, 2020

Consider a few of these settings after you choose File, Options.

Create Your Own QAT Routines Using VBA Macros. Photo Credit: Markus Spiske at

Excel 2020: Create Your Own QAT Routines Using VBA Macros »

December 23, 2020

There are several short macros you can add to your Personal Macro Workbook and then add to the QAT. In this tip, you will see how to create the Personal Macro Workbook, type some macros, and then assign them to icons on the QAT.

Customize the Quick Access Toolbar. Photo Credit: The Roaming Platypus at

Excel 2020: Customize the Quick Access Toolbar »

December 16, 2020

Even though the Excel team does not think many features are Home-tab-worthy, you can add your favorite features to the Quick Access Toolbar (QAT).

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

Excel 2020: A Great April Fool’s Day Trick »

December 14, 2020

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.”

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

Excel 2020: Provide Feedback with Sound »

December 10, 2020

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

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

Excel 2020: Avoid Whiplash with Speak Cells »

December 9, 2020

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.