December 4, 2023 - by Bill Jelen
Problem: I don’t want to use just static text in a shape; I want to display the results of a calculation in the shape.
Strategy: This is possible, although typing the formula in the shape is not the way to do it. Here’s how you do it:
Add Text to Any Closed Shape »
November 28, 2023 - by Bill Jelen
How can I add fixed text to a shape?
25 Years of MrExcel on November 21, 2023 »
November 21, 2023 - by Suat M. Ozgur
Can you believe it's been a quarter century since the MrExcel Message Board kicked off? Time really does fly when you're having Excel fun! As we take a stroll down memory lane, let's celebrate this incredible journey we've all been on together.
November 20, 2023 - by Bill Jelen
The oval tool in the Drawing toolbar is hard to use. If I start drawing the rectangle in the upper-left corner of the cell, the shape will start in that corner. But if I start drawing a circle in the same spot, the oval I draw will not completely include the text in the cells. Also, why aren’t there circle and square shapes? I have a hard time drawing perfectly round circles and perfectly square squares.
Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)
December 2021
Use Microsoft 365 Excel and Excel 2021 pivot tables and pivot charts to produce powerful, dynamic reports in minutes: take control of your data and your business!
March 2021
Cool Excel Sh*t is designed with the Excel guru in mind, introducing advanced, creative solutions and hacks for the software's most challenging problems.
April 2022
The 6th Edition of MrExcel XL, updated with new functions released for Microsoft 365.
Supercharge Power BI - 3rd Edition
February 2021
Released in 2021, this book will teach you the DAX language from the ground up, using Power BI as your canvas.