Copy worksheet1 to worksheet2, keep cell format eg cell size

  • Thread starter Thread starter slocookie
  • Start date Start date
S

slocookie

I want to copy information from worksheet 1 to worksheet 2. I copy the
information in H1 and the size of the cell conforms to the size of the row.
Is there a way to paste in the info, and keep the worksheets' formats separte?
 
Hi slocookie,

Have you tried Paste special? Copy then at H1 right click then select paste
special, then values.
--
Regards
Warren
Excel Novice
Addiewell, Scotland.

If this helps please click the Yes button.
 
copy selection,then go to new workbook or sheet.select paste special- column with- paste it and then paste again all.



slocooki wrote:

Copy worksheet1 to worksheet2, keep cell format eg cell size
14-Nov-08

I want to copy information from worksheet 1 to worksheet 2. I copy the
information in H1 and the size of the cell conforms to the size of the row.
Is there a way to paste in the info, and keep the worksheets' formats separte?

Previous Posts In This Thread:

Copy worksheet1 to worksheet2, keep cell format eg cell size
I want to copy information from worksheet 1 to worksheet 2. I copy the
information in H1 and the size of the cell conforms to the size of the row.
Is there a way to paste in the info, and keep the worksheets' formats separte?

Hi slocookie,Have you tried Paste special?
Hi slocookie

Have you tried Paste special? Copy then at H1 right click then select paste
special, then values
--
Regard
Warre
Excel Novic
Addiewell, Scotland

If this helps please click the Yes button

:


Submitted via EggHeadCafe - Software Developer Portal of Choice
COM+ Services Overhead in .NET
http://www.eggheadcafe.com/tutorial...19-02edbea0e9fb/com-services-overhead-in.aspx
 
Back
Top