| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to Keep my Format ??
Hello....
I have worksheet call Template.xls with format I like to use..(bold.. align center..borders..etc.....) But whenever I copy cells from another worksheet and paste on Template.xls then my format is gone..(NO bold, align center...etc..) So my question is ... is there any way to keeping my format? even though I copy and paste from another wokrsheet... Thanks in advance... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to Keep my Format ??
Try to use PasteSpecial/Values instead of Paste! Paste copies values and
formats as well. Regards, Stefi €˛Astroboy€¯ ezt Ć*rta: Hello.... I have worksheet call Template.xls with format I like to use..(bold.. align center..borders..etc.....) But whenever I copy cells from another worksheet and paste on Template.xls then my format is gone..(NO bold, align center...etc..) So my question is ... is there any way to keeping my format? even though I copy and paste from another wokrsheet... Thanks in advance... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to Keep my Format ??
Hello Stefi,
Thank you for reply.... Is Paste Special has HOT Key? Like Paste (ctl-v)? b/c I am using on script to paste the copied cells... Thank you.... "Stefi" wrote: Try to use PasteSpecial/Values instead of Paste! Paste copies values and formats as well. Regards, Stefi €˛Astroboy€¯ ezt Ć*rta: Hello.... I have worksheet call Template.xls with format I like to use..(bold.. align center..borders..etc.....) But whenever I copy cells from another worksheet and paste on Template.xls then my format is gone..(NO bold, align center...etc..) So my question is ... is there any way to keeping my format? even though I copy and paste from another wokrsheet... Thanks in advance... |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to Keep my Format ??
PasteSpecial doesn't have any hot key, but if you use a script (VBA macro)
for copy and paste, you can assign an own hot key to your macro! Stefi €˛Astroboy€¯ ezt Ć*rta: Hello Stefi, Thank you for reply.... Is Paste Special has HOT Key? Like Paste (ctl-v)? b/c I am using on script to paste the copied cells... Thank you.... "Stefi" wrote: Try to use PasteSpecial/Values instead of Paste! Paste copies values and formats as well. Regards, Stefi €˛Astroboy€¯ ezt Ć*rta: Hello.... I have worksheet call Template.xls with format I like to use..(bold.. align center..borders..etc.....) But whenever I copy cells from another worksheet and paste on Template.xls then my format is gone..(NO bold, align center...etc..) So my question is ... is there any way to keeping my format? even though I copy and paste from another wokrsheet... Thanks in advance... |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to Keep my Format ??
Copy/paste this into the sheet module of your Template.xls
Private Sub Worksheet_Change(ByVal Target As Range) 'retain formatting when a cell is copied over Dim myValue With Application .EnableEvents = False myValue = Target.Value .Undo Target = myValue Application.CutCopyMode = False .EnableEvents = True End With End Sub Gord Dibben MS Excel MVP On Mon, 10 Mar 2008 04:14:12 -0700, Astroboy wrote: Hello.... I have worksheet call Template.xls with format I like to use..(bold.. align center..borders..etc.....) But whenever I copy cells from another worksheet and paste on Template.xls then my format is gone..(NO bold, align center...etc..) So my question is ... is there any way to keeping my format? even though I copy and paste from another wokrsheet... Thanks in advance... |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to Keep my Format ??
Hello,
Thank you for reply... But the format still changed.. And this is what I did and please let me know if I did something wrong... Right click on Sheet1 and choose View Code and pasted the code you gave to me And copy cells from another template and Ctrl-V on template.xls.. But the format still changed... Any Idea? Thank you in advance... "Gord Dibben" wrote: Copy/paste this into the sheet module of your Template.xls Private Sub Worksheet_Change(ByVal Target As Range) 'retain formatting when a cell is copied over Dim myValue With Application .EnableEvents = False myValue = Target.Value .Undo Target = myValue Application.CutCopyMode = False .EnableEvents = True End With End Sub Gord Dibben MS Excel MVP On Mon, 10 Mar 2008 04:14:12 -0700, Astroboy wrote: Hello.... I have worksheet call Template.xls with format I like to use..(bold.. align center..borders..etc.....) But whenever I copy cells from another worksheet and paste on Template.xls then my format is gone..(NO bold, align center...etc..) So my question is ... is there any way to keeping my format? even though I copy and paste from another wokrsheet... Thanks in advance... |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to Keep my Format ??
Oh... it works.... and thank you~~~!!!!!!!!!!!!!!!!!!!!
"Gord Dibben" wrote: Copy/paste this into the sheet module of your Template.xls Private Sub Worksheet_Change(ByVal Target As Range) 'retain formatting when a cell is copied over Dim myValue With Application .EnableEvents = False myValue = Target.Value .Undo Target = myValue Application.CutCopyMode = False .EnableEvents = True End With End Sub Gord Dibben MS Excel MVP On Mon, 10 Mar 2008 04:14:12 -0700, Astroboy wrote: Hello.... I have worksheet call Template.xls with format I like to use..(bold.. align center..borders..etc.....) But whenever I copy cells from another worksheet and paste on Template.xls then my format is gone..(NO bold, align center...etc..) So my question is ... is there any way to keeping my format? even though I copy and paste from another wokrsheet... Thanks in advance... |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to Keep my Format ??
Good to hear.
I was about to reply with a few questions........my style<g But now I don't have to. Curious to know what happened in the half hour between "it didn't work" to "it works" Most likely pasting to the wrong sheet?? Gord On Mon, 10 Mar 2008 13:09:01 -0700, Astroboy wrote: Oh... it works.... and thank you~~~!!!!!!!!!!!!!!!!!!!! "Gord Dibben" wrote: Copy/paste this into the sheet module of your Template.xls Private Sub Worksheet_Change(ByVal Target As Range) 'retain formatting when a cell is copied over Dim myValue With Application .EnableEvents = False myValue = Target.Value .Undo Target = myValue Application.CutCopyMode = False .EnableEvents = True End With End Sub Gord Dibben MS Excel MVP On Mon, 10 Mar 2008 04:14:12 -0700, Astroboy wrote: Hello.... I have worksheet call Template.xls with format I like to use..(bold.. align center..borders..etc.....) But whenever I copy cells from another worksheet and paste on Template.xls then my format is gone..(NO bold, align center...etc..) So my question is ... is there any way to keeping my format? even though I copy and paste from another wokrsheet... Thanks in advance... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Lock Cell Format - Allow copy and paste of data without format change | Excel Worksheet Functions | |||
| Converting a time format to a String format in Excel | Excel Discussion (Misc queries) | |||
| Decide comment format 'globally'? Restore format with ws_change? | Excel Discussion (Misc queries) | |||
| Replace million-billion number format to lakhs-crores format | Excel Discussion (Misc queries) | |||
| how to format excel format to text format with separator "|" in s. | New Users to Excel | |||
Linear Mode
