<div>
Hi, thanks for posting. I know how to copy cell formats, and I always used the same method for shapes. &nbsp;For some reason it wasn't working, but I just went and tried it again and it worked as it does in 2003. That's really bizarre, but at least it's working. <br />
<br />
Thnaks for your posts because they made me try it one time and for some reason the Excel formatting gods decided to smile. : -)<br />
<br />
Thanks,<br />
John
</div>


Hi, thanks for posting. I know how to copy cell formats, and I always used the same method for shapes.  For some reason it wasn't working, but I just went and tried it again and it worked as it does in 2003. That's really bizarre, but at least it's working.

Thnaks for your posts because they made me try it one time and for some reason the Excel formatting gods decided to smile. : -)

Thanks,
John

<div>
<div class="content wysiwyg-content">
I googled this and couldn't get an answer on it. It's very intuitive in 2003. How do I do it in 2007?<br />
<br />
Thanks,<br />
John
</div>
</div>


I googled this and couldn't get an answer on it. It's very intuitive in 2003. How do I do it in 2007?

Thanks,
John

Copy and paste formatting from one shape to another in Excel 2007.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.