Excel: Enter Special Symbols

This page is an advertiser-supported excerpt of the book, Power Excel 2010-2013 from MrExcel - 567 Excel Mysteries Solved. If you like this topic, please consider buying the entire e-book.


  1. Look at both tabs.

    Problem: I work in the music business, and I routinely have to enter copyright symbols. How can I do so easily?

    Strategy: You can enter (c) followed by a space as a shortcut for the © symbol. You can use (r) for the registered trademark symbol, ®. For other special symbols, you can use Insert, Symbol to display the Symbol dialog.

    You simply select any symbol from the Symbol dialog and choose Insert to type the symbol in the cell.