Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts
    How do you remove the little triangular indicators in the top left hand corner in cells? For that matter - any extras in cells?

  2. #2
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Shetland Isles, Shetland, Scotland
    Posts
    154
    Thanks
    3
    Thanked 1 Time in 1 Post
    [quote name='LindaR' post='799325' date='22-Oct-2009 11:54']How do you remove the little triangular indicators in the top left hand corner in cells? For that matter - any extras in cells?[/quote]

    Hi, just to be clear, you are asking about the top LEFT hand corner of the cell?

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='jmacleod' post='799327' date='22-Oct-2009 11:07']Hi, just to be clear, you are asking about the top LEFT hand corner of the cell?[/quote]

    Yes. That is what I see now - but I don't want anything in the cells except numbers or text.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    I edited the subject of your post to mention Excel instead of Access.

    Excel displays a green triangle in the upper left corner of a cell if that cell contains an error or inconsistent value/formula. To hide these triangles:
    - Click the Office button.
    - Click Excel Options.
    - Click Formulas in the navigation pane on the left hand side.
    - Clear the "Enable background error checking" check box under Error Checking.

    By default, comments are indicated by a red triangle in the upper right corner of a cell. If you don't display these, you won't have an idea which cells contain comments. But if you prefer to hide them:
    - Click the Office button.
    - Click Excel Options.
    - Click Advanced in the navigation pane on the left hand side.
    - Select "No comments or indicators" under "For cells with comments, show" in the Display section.

    A purple triangle in the lower right corner of a cell indicates a Smart Tag. To hide them:
    - Click the Office button.
    - Click Excel Options.
    - Click Proofing in the navigation pane on the left hand side.
    - Click AutoCorrect Options...
    - Activate the Smart Tags tab.
    - Select None from the "Show smart tags as" dropdown.

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Posts
    1,119
    Thanks
    0
    Thanked 0 Times in 0 Posts
    [quote name='HansV' post='799330' date='22-Oct-2009 11:15']I edited the subject of your post to mention Excel instead of Access.

    Excel displays a green triangle in the upper left corner of a cell if that cell contains an error or inconsistent value/formula. To hide these triangles:
    - Click the Office button.
    - Click Excel Options.
    - Click Formulas in the navigation pane on the left hand side.
    - Clear the "Enable background error checking" check box under Error Checking.

    By default, comments are indicated by a red triangle in the upper right corner of a cell. If you don't display these, you won't have an idea which cells contain comments. But if you prefer to hide them:
    - Click the Office button.
    - Click Excel Options.
    - Click Advanced in the navigation pane on the left hand side.
    - Select "No comments or indicators" under "For cells with comments, show" in the Display section.

    A purple triangle in the lower right corner of a cell indicates a Smart Tag. To hide them:
    - Click the Office button.
    - Click Excel Options.
    - Click Proofing in the navigation pane on the left hand side.
    - Click AutoCorrect Options...
    - Activate the Smart Tags tab.
    - Select None from the "Show smart tags as" dropdown.[/quote]


    Thanks Hans - I think I am still sleeping. I am going to go to the cafeteria and get some coffee.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •