How can I copy cells in Excel 2007 and paste with formatting
Posted
by
John
on Super User
See other posts from Super User
or by John
Published on 2012-12-07T22:32:09Z
Indexed on
2012/12/07
23:16 UTC
Read the original article
Hit count: 340
I am wanting to be able to copy cells in a worksheet and paste them elsewhere in the same worksheet while maintaining the original formatting. I also want to be able to paste into Word and Outlook and keep the same formatting.
Everything I have tried discards the the formatting and only pastes unformatted text.
Paste Option buttons do not appear even though they have been defined in the setting to appear. Also Format Painter does not seem to do anything at all.
Is there a setting that needs to be changed to resolve this?
© Super User or respective owner