Copyright Symbol

[Guest]

Is there a way to create a copyright symbol into the header or footer of
Excel 2003?
Thank you

 

[Paul Lautman]

Is there a way to create a copyright symbol into the header or footer
of Excel 2003?
Thank you

Just go to CHARMAP (Start->Run->type charmap click OK
Select the copyright symbol
click copy
go to Excel
View->Header and Footer...
Paste in the symbol

 

[Guest]

It should be set up as an AutoCorrect option: (c) should convert to your
copyright symbol. Check Tools > AutoCorrect Options, the AutoCorrect tab.

 

[Paul Lautman]

That doesn't seem to work in the header

It should be set up as an AutoCorrect option: (c) should convert to
your copyright symbol. Check Tools > AutoCorrect Options, the
AutoCorrect tab.

 

[Guest]

The easiest way is to hold ALT and type 0169.

Check out this page for more symbols:

http://www.forlang.wsu.edu/help/keyboards.asp

 

[Jim May]

You have to use VBA;
In a cell (somewhere, say Z1), do (from the Menu, Insert
Symbol, Click (once you find it) the Circled C.. - Click on the Insert
button.
Now with Z1 = C (copyright sign)

Go to VBE - This Workbook,
Private Sub Workbook_BeforePrint(Cancel As Boolean)
ActiveSheet.PageSetup.LeftHeader = Sheets("Sheet1").Range("z1")
End Sub

Hope that helps,,
Jim May

 

[Paul Lautman]

No you don't. My first post explaining how to do it with charmap works fine.

 

[Guest]

Thank you all for your input - The ALT keyboard symbols works great - Thanks
again!

 

[via135]

hi!

try this!

=CHAR(169)

-via13

 

[Guest]

the only way I could get it to work was to use the auto correct feature (
type in (c))in the actual worksheet then copy it and paste it into the header.

 

[M. Claire]

Thank you this was very helpful and the easiest way.