| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copy worksheet1 to worksheet2, keep cell format eg cell size
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. "slocookie" wrote: 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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
how to copy cell size in excel
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: On Friday, November 14, 2008 1:03 AM slocooki wrote: 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? On Friday, November 14, 2008 4:33 AM WarrenEasto wrote: 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. -- Regards Warren Excel Novice Addiewell, Scotland. If this helps please click the Yes button. "slocookie" wrote: Submitted via EggHeadCafe - Software Developer Portal of Choice COM+ Services Overhead in .NET http://www.eggheadcafe.com/tutorials...erhead-in.aspx |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Data from Worksheet1 to Worksheet2 IF Worksheet1 Column D = Y | Excel Worksheet Functions | |||
| How to add column from worksheet1.xls to column in worksheet2.xls | Excel Discussion (Misc queries) | |||
| columns on worksheet2 don't sort with worksheet1 | Excel Worksheet Functions | |||
| How do I copy data in single cell format to a merged cell format | Excel Discussion (Misc queries) | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Linear Mode
