• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Retain wrap format when pasting text

artgirl200

New Member
I do a lot of cutting and pasting of text into my spreadsheet. Is there a way that when I paste it conforms to the format already set? So I dont have to reapply wrap and alignment all the time? Would a template solve this?
 
If you have word wrap on in the cell you copy, and use Ctrl C and Ctrl V for Copy and Paste it takes the format with you?


If using a mouse don't paste Values or Formulas, most of the other paste formats bring word wrap with you.


Comments above based on excel 2010
 
Back
Top