Green Tick Marks

  • Thread starter Thread starter DNA
  • Start date Start date
D

DNA

How do you turn the green ticks marks off so you don't know cells contain a
formula. Does everyone know what I'm talking about?
 
From Microsoft's website:

"For more information about error types and how to correct them, click
Microsoft Excel Help on the Help menu, type 'find and correct errors in
formulas' in the Search for box in the Assistance pane, and then click Start
searching to view the topic."

HTH
Jason
Atlanta, GA
 
There's nothing wrong with the formulas. The spreadsheet is fine on my PC,
when I emailed it, the other user has the green tick marks. They have not
changed the formulas.
 
You need to protect the sheet and then they will go away.
These ****ing things are a curse. No one I know wants them, they are just MS
giving help where help is not wanted.
Go on Tools > Options and also 'Auto Correct' options and look for 'Smart
Tags'.
Disable the annoying SOB's and you should be OK
Regards,
Alan.
 
The green tickmarks do not necessarily indicate formulas. They indicate what
Excel thinks is an error or anomaly in the cell.

Try Tools>Options>Error Checking. Uncheck the option and the green triangles
will go away.

To hide the formulas in the formula bar you can select the cells and
Format>Protection>Hidden.

Then protect the worksheet under Tools>Protection>Protect Sheet.


Gord Dibben Excel MVP
 

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

Back
Top