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?
I get rid of them? How do I prevent them?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Pete_UK
What are Push Pins ?
Pete
Pete
G
Gord Dibben
Maybe "Smart Tags" under Tools>Autocorrect Options?
I don't know. I have never used them.
Gord Dibben MS Excel MVP
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.
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.
G
Gord Dibben
Thanks for letting us know the steps taken to resolve the issue.
Gord
Gord