Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Green Tick Marks
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? |
#2
|
|||
|
|||
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 "DNA" wrote: 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? |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. "DNA" wrote in message lkaboutsoftware.com... 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. |
#5
|
|||
|
|||
Try:
Tools< Options<View then deselect the fromula bar "DNA" wrote: 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? |
#6
|
|||
|
|||
The green tickmarks do not necessarily indicate formulas. They indicate what
Excel thinks is an error or anomaly in the cell. Try ToolsOptionsError 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 FormatProtectionHidden. Then protect the worksheet under ToolsProtectionProtect Sheet. Gord Dibben Excel MVP On Mon, 13 Jun 2005 07:17:11 -0700, "Phil Wales" wrote: Try: Tools< Options<View then deselect the fromula bar "DNA" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Y-axis tick marks in middle of chart? | Charts and Charting in Excel | |||
Tick marks on all sides of charts | Charts and Charting in Excel | |||
Macro to delete data in 'green' cells only | Excel Worksheet Functions | |||
Format color - darker green available? | Excel Worksheet Functions | |||
how I can insert a "tick" symbol | Excel Worksheet Functions |