Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question

Go to the Excel Options and in the "Advanced" Section there is a paragraph called "Cut, Copy and Paste". There you can find an option to "show Paste Options". That disables or enables the little menu that pops up when you paste something. The default is to show it and to copy formatting however. Not sure how that got lost in your Excel.

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .