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

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

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

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 »