Click in any cell you want (not in the footer) and then go to
find the picture of the copyright symbol, its in the seventh row I think.
close the insert box
highlight the cell with the pic of the symbol
cut and paste into your footer.