MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Bill Jelen's Sternly Written Policy on Posting Your Worksheet to the MrExcel Message Board


January 24, 2020 - by Bill Jelen

Effective January 9, 2020, there are two acceptable ways to post your worksheet to the MrExcel Message Board: (1) Paste a screenshot or (2) post code generated by the official XL2BB.xlam add-in developed by Suat M Ozgur (aka smozgur at the board). I will not support any other methods for posting worksheets to the board—and I'll tell you why.

As of this writing, there are 5 million posts at this board. From 2009 to 2019, we welcomed various methods of posting to the board. I loved the creativity of Colo, Richard, Excel Jeannie, HTMLMaker, and others.

However, during 2019, when we were planning on converting from vBulletin to Xenforo, converting from HTML to BBCode, we discovered around 200,000 spreadsheets posted to the board using 36 different styles. My goal is to preserve every single contribution because it enriches the community. We had to write code to convert each old style to the new style.

continue reading »

More Reading


MrExcel Publishing’s Attempt to Document the Constantly Changing Excel Features in Office 365 »

January 13, 2020 - by Bill Jelen


“XLOOKUP is Great, but it Makes this Book Obsolete.” MrExcel Publishing’s Attempt to Document the Constantly Changing Excel Features in Office 365.

Resolve to Learn Power BI in 2020 »

December 26, 2019 - by Bill Jelen


It’s a new decade. You’ve been saying that you really need to transition your Excel skills to Power BI. If you are looking for a New Years Resolution for 2020, now is the time to get comfortable with Power BI and create a few dashboards.

read more articles »


Supercharge your career with training from MrExcel

Featured Products


The Absolute Guide to Dashboarding & Reporting with Power BI

The Absolute Guide to Dashboarding & Reporting with Power BI »


Learn Power BI Dashboarding Techniques by Watching A Pro!

Power Excel With MrExcel - 2019 Edition

Power Excel With MrExcel - 2019 Edition »


This is the print book edition of "Power Excel with MrExcel - 2019 Edition" - by Bill Jelen. Master Pivot Tables, Subtotals, Visualizations, VLOOKUP, Power BI and Data Analysis.

Microsoft Excel 2019 Inside Out

Microsoft Excel 2019 Inside Out »


Dive into Microsoft Excel 2019–and really put your spreadsheet expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds–all you need to make the most of Excel’s most powerful tools for analyzing data and making better decisions.

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.

Excel Insights – A Microsoft MVP Guide to the Best Parts of Excel

Excel Insights – A Microsoft MVP Guide to the Best Parts of Excel »


There are fewer than 100 Excel MVPs worldwide. 24 of them have contributed to this book. Written, edited, reviewed and printed by Excel MVPs, this is practical Excel passion undiluted, with each MVP highlighting some of their favorite topics.

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.

see more products »