I need help. How do I insert a copyright symbol into a footer of an Excel spreadsheet. I have tried (c) and I have tried cutting and pasting, but nothing seems to work. I understand I can used (c), but I want to use the actual symbol. Please help!:(
Inserting the copyright symbol in an Excel Footer
-
-
Click in any cell you want (not in the footer) and then go to
insert
symbol
find the picture of the copyright symbol, its in the seventh row I think.
hit insert
close the insert box
highlight the cell with the pic of the symbol
cut and paste into your footer. -
Alternatively, while you are in the Footer section press and hold down the ALT key and then enter 0169 (from the numeric keypad, not the keys above your QWERTY keys) then release the ALT key.
-
...or....
in any cell type =char(169) -
Hi nledgemon
You can get all the Short cut keys for these by going into the Visual Basic Editor, pushing F1 and typing: Character set
You can also get the same from the Windows Character Map normally under Start>Programs>Accessories>System Tools
-
-
Sub MakeFooter()
ActiveSheet.PageSetup.RightFooter = "My Company " & Chr(169)
End Sub
Participate now!
Don’t have an account yet? Register yourself now and be a part of our community!