MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2019: Put the Worksheet Name in a Cell


February 21, 2019 - by Bill Jelen

Excel Put the Worksheet Name in a Cell. Photo Credit: Jannes Glas at Unsplash.com

If you want each report to have the name of the worksheet as a title, use the following formula:

=TRIM(MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,20)) &" Report"

continue reading »

More Reading


Fast Worksheet Copy. Photo Credit: Joe Green at Unsplash.com

Excel 2019: Fast Worksheet Copy »

February 20, 2019 - by Bill Jelen


You can right-click any sheet tab and choose Move or Copy to make a copy of a worksheet. But that is the very slow way to copy a worksheet. The fast way: Hold down the Ctrl key and drag the worksheet tab to the right.

Excel Fill Jan, Feb, ..., Dec, Total. Photo Credit: Curtis MacNewton at Unsplash.com

Excel 2019: Fill Jan, Feb, ..., Dec, Total »

February 19, 2019 - by Bill Jelen


While you can edit any custom list that you create, you cannot edit the first four lists in the Custom Lists dialog.

read more articles »


IMA Data Analytics Leveraging Excel

Featured Products


Power Pivot and Power BI

Power Pivot and Power BI »


Power Pivot for Excel and its close cousin Power BI Desktop are Microsoft’s tightly-related pair of revolutionary analytical tools – tools that are fundamentally changing the way organizations work with data.

Power Excel With MrExcel - 2017 Edition

Power Excel With MrExcel - 2017 Edition »


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

Learn to Write DAX

Learn to Write DAX »


Data analysis expressions (DAX) is the formula language of PowerPivot and Power BI. Simply reading a book is normally not enough to help Excel users learn DAX skills – you need to complete exercises and get plenty of practice to make the transition.

Excel 2016 in Depth

Excel 2016 in Depth »


Experienced with Excel? Don’t let Excel 2016 make you feel like a beginner again! This new full-color edition of the bestselling book has been completely overhauled. Gone is unnecessary and rarely used content; emphasis is on the most-used and new aspects of Excel 2016.

MrExcel LIVe

MrExcel LIVe »


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 »