Excel cells in color not transferring in copy/paste.

JaneMMPoppinsLV 

One possible reason for this issue could be that the default paste options in Outlook or Word are set to paste only the text and not the formatting.

You can try changing the default paste options in Outlook or Word by following these steps:

1. In Outlook or Word, click on the File tab and select Options.
2. In the Options dialog box, select Mail (in Outlook) or Advanced (in Word).
3. Scroll down to the “Cut, copy, and paste” section.
4. In the “Pasting from other programs” drop-down list, select “Keep Source Formatting”.
5. Click OK to save your changes.

After changing this setting, try copying and pasting your Excel data again to see if the cell colors are preserved.

If this doesn’t work, you can try pasting your data using the “Paste Special” command.

Here’s how:

1. In Excel, select the cells you want to copy and press Ctrl+C to copy them to the clipboard.
2. In Outlook or Word, right-click on the location where you want to paste the data and select “Paste Special”.
3. In the Paste Special dialog box, select “Microsoft Excel Worksheet Object” and click OK.

This should paste your data along with its formatting, including cell colors.

I hope this helps!