Place Cell Contents in a Shape

December 4, 2023 - by Bill Jelen

Place Cell Contents in a Shape

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:

continue reading »

More Reading

Add Text to Any Closed Shape

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

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.

Draw Perfect Circles

Draw Perfect Circles »

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.

read more articles »

Featured Products

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!

Cool Excel Sh*t

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.

MrExcel 2022 Boosting Excel

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.

see more products »