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

Guerrilla Data Analysis Using Microsoft Excel - 3rd Edition

May 2022

Two of the leading Excel channels on YouTube join forces to combat bad data. This book includes step-by-step examples and case studies that teach users the many power tricks for analyzing data in Excel. These are tips honed by Bill Jelen, "MrExcel," and Oz do Soleil during their careers run as financial analysts.

Microsoft Excel Inside Out (Office 2021 and Microsoft 365)

December 2021

Dive Into Microsoft Excel for Office 2021 and Microsoft 365 and really put your spreadsheet expertise to work. This supremely well-organized reference packs hundreds of timesaving solutions, tips, and workaroundsall you need to make the most of Excels most powerful tools for analyzing data and making better decisions.

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.

Your Excel Survival Kit - Second Edition

March 2021

This book helps you realize that Excel is on your side. It can be your friend, not your enemy. If and when you upgrade your Excel skills you will experience many positives: you will learn to love Excel, you will learn how to use Excel to become an invaluable asset in your workplace.

see more products »