Push Pins Appear in Spreadsheet

S

swolfe

Push Pins appear in cells in a spreadsheet. How did they get there? How do
I get rid of them? How do I prevent them?
 
G

Gord Dibben

Maybe "Smart Tags" under Tools>Autocorrect Options?

I don't know. I have never used them.


Gord Dibben MS Excel MVP
 
S

swolfe

Thanks for pointing me in the right direction.

In Excell 2007, under the Office Button, click the Excel Options, Go to
Proofing, then AutoCorrect Options. Click the SmartTags tab and uncheck the
check box for Label Data With Smart Tags.

To get rid of them, I had to copy and Paste Values, Formulas, and Formats
into a new sheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top