Formatting

[xxsalahxx]

Hello I wnat to be able to copy and paste from one spreadsheet to another without changing column widths. For example. Spreadsheet 1 is set up with the widths of the colums i need. The other excel Spreadsheet2 I need to copy out the data from this into spreadsheet1 but im colums go back to the default widths in excel is there a way around this? Thanking you in advance for any help.

 

[Misca]

Try pasting the values only ( = the 123 symbol found under the right mouse button click).

 

[xxsalahxx]

Thank you much appreciatd