ExcelBanter - Copyright in Footer

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Copyright in Footer (https://www.excelbanter.com/excel-worksheet-functions/61329-copyright-footer.html)

Excel User

Copyright in Footer

How do I insert the Copyright symbol in the footer? Many thanks.

Excel User

Copyright in Footer

Got It!

"Excel User" wrote:

How do I insert the Copyright symbol in the footer? Many thanks.

David Billigmeier

Copyright in Footer

While editing your footer (<View <Header and Footer) hold ALT and type 0169.

--
Regards,
Dave

"Excel User" wrote:

How do I insert the Copyright symbol in the footer? Many thanks.

Gary''s Student

Copyright in Footer

This little bit of VBA can enter the symbol in the footer:

Sub Macro1()
With ActiveSheet.PageSetup
.LeftFooter = Chr(169)
End With
End Sub
--
Gary's Student

"Excel User" wrote:

How do I insert the Copyright symbol in the footer? Many thanks.

All times are GMT +1. The time now is 10:43 AM.