setting to prevent hidden cells from opening when entering a cell formula that references a different cell

cd turley 0 Reputation points
2023-03-31T19:54:59.3233333+00:00

need to stop the sheets hidden cells opening as grouped or titles cells when entering formula in cell by selection of a different cell. lotus transition does not affect. problem started in last 2 mos.

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,536 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,659 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Ayomide Oluwaga 946 Reputation points
    2023-03-31T21:05:52.86+00:00

    Hello @cd turley

    Welcome to the Q&A,

    It sounds like you may be accidentally selecting grouped or outlined cells when you enter a formula that references a different cell.

    To prevent Excel from automatically grouping or outlining cells when you enter a formula that references cells within them, you can disable the "Outline Symbols" feature. Here's how:

    1. Click on the "File" tab in the ribbon.
    2. Click on "Options" in the left-hand menu.
    3. In the Excel Options dialog box, click on "Advanced" in the left-hand menu.
    4. In the "Display options for this workbook" section, uncheck the "Show outline symbols if an outline is applied" option.
    5. Click "OK" to save your changes.

    This should prevent Excel from automatically grouping or outlining cells when you enter a formula that references cells within them.

    If you still experience the same issue after disabling the "Outline Symbols" feature, you may want to check if there are any macros or add-ins running that may be causing this behavior. You can try disabling any add-ins or macros and see if that resolves the issue.

    If this solved your problem, let me know, else provide more information under this Answer.


  2. cd turley 0 Reputation points
    2023-04-06T18:52:18.5566667+00:00

    safe mode solved the problem. problem still persisted after resetsettings done in normal mode. was there a excel upgrade that would have caused this?