Thread: Always keeping source formatting when copying and pasting in Excel
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mail Merge and Form Protection in Word 2 Mail Merge and Form Protection in Word 2 is offline
external usenet poster
  
Posts: 1
Default Always keeping source formatting when copying and pasting in Excel
I have upgraded to Excel 2007. Now when I copy something from a 2003
spreadsheet and then paste it into another spreadsheet (in compatability
mode) everything in the text box ends up right justified. I have a pop-up
box that gives me the option to keep source formatting, which then puts the
text back the way it should be. Is there a way to always keep source
formatting without having to do this for each thing I copy and paste?
Reply With QuoteReply With Quote