Share via

Copy Values and Color Format at the same time?

Anonymous
2019-08-29T13:35:13+00:00

I currently have a document that has lots of colored cells and formulas.  I want to be able to either export the information into a new worksheet with the call the colors, but just the values or paste it into another worksheet.  When I do copy and paste format and values it brings over the formulas as well.  Any ideas?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2019-08-29T17:17:25+00:00

    I hope that recent UI changes in Excel have not eliminated the following one-step methods (Excel 2010).

    1. After copying the original cell, right-click the destination cell, hover over "paste special", then click the icon for "value and number formats" (or press a).

    1. After copying the original cell, right-click the destination cell, click "paste special", then click next to "values and number formats", and click OK.

    1 person found this answer helpful.
    0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2019-08-29T13:52:53+00:00

    To:  Rose

    Re:  copying

    Paste the Values then paste Formatting (two separate steps).

    '---

    Free Excel add-ins and workbooks at MediaFire...

    http://www.mediafire.com/folder/lto3hbhyq0hcf/Documents

    0 comments
  2. Anonymous
    2019-08-29T14:35:15+00:00

    Hi RoseGould, my name is Albanis

    1. If you only want to paste values, use option123 Values ​​(V)
    2. To apply the same format, select a cell from the data source, right click / "Format Painter" option

    then go to the sheet where you pasted the values ​​and apply it

    Let me know if it was helpful

    Regards

    0 comments