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

Posted on 2011-10-21
Last Modified: 2012-05-12
I googled this and couldn't get an answer on it. It's very intuitive in 2003. How do I do it in 2007?

Question by:gabrielPennyback
    LVL 3

    Assisted Solution

    The format painter is what I use it is on the Home Ribbon below the copy.
    LVL 3

    Accepted Solution


    By shape do you mean differently sized selections of cells?

    If so, select the "source" cells.  Click the "Format Painter" button in the Home ribbon (in the left hand side clipboard group, by default) and then click and drag over the "target" cells for which you wish to copy the formatting.  The formatting will change when you release the mouse button.

    Alternatively, you can also select and copy the "source" cells, then select the "target" cells, right-click, Choose "Paste Special...", then Formats, and OK.


    LVL 1

    Author Comment

    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. : -)


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
    Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now