Is there a way of deleting the coloured triangles from all the cells in a
column at the same time,instead of having to delete each one individually?

Do you mean the comment indicators? If so, select all those cells and do
Edit - Clear - Comments. HTH Otto
"MEANLEANDEANE" wrote in message
...
Is there a way of deleting the coloured triangles from all the cells in a
column at the same time,instead of having to delete each one individually?

If it's green triangles, you could try unchecking "Formulas referring to
empty cells"

Tools/options/error checking

TGHC


--
tghcogo
------------------------------------------------------------------------
tghcogo's Profile: http://www.excelforum.com/member.php...o&userid=10494
View this thread: http://www.excelforum.com/showthread...hreadid=494834

Could you mean the Error warnings (in the upper left)--little (usually) green
triangles.

If yes, you can use a macro:

Option Explicit
Sub testme01()
Dim myCell As Range
Dim myRng As Range
Dim wks As Worksheet
Dim iCtr As Long

Set wks = ActiveSheet
With wks
Set myRng = .Range("f1", .Cells(.Rows.Count, "F").End(xlUp))
For Each myCell In myRng.Cells
'1 xlEvaluateToError
'2 xlTextDate
'3 xlNumberAsText
'4 xlInconsistentFormula
'5 xlOmittedCells
'6 xlUnlockedFormulaCells
'7 xlEmptyCellReferences
'8 xlListDataValidation
For iCtr = 1 To 8
With myCell.Errors(iCtr)
If .Value = True Then
.Ignore = True
End If
End With
Next iCtr
Next myCell
End With

End Sub

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

MEANLEANDEANE wrote:

Is there a way of deleting the coloured triangles from all the cells in a
column at the same time,instead of having to delete each one individually?

--

Dave Peterson