Merged Data

[acool]

Hi Everyone,

I am currently trying to figure out a way to have my have my number display as if it is a merged cell, but have the value of 145 in remain in each cell. So while it looks as if it is a merged cell, I would like that value to be in each cell throughout the range. I have attached a photo for reference below. Any help would be greatly appreciated. Thank You!

 

[James006]

Hi,
You are right !!!
To my knowledge, the only trick you can use to achieve your visual effect is ....a picture ...

In order to implement it, you can use the Excel Camera Tool:

How to add and use camera tool in Excel？

www.extendoffice.com

Hope this will help