Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.