Share via

How do I stop Excel from highlighting two cells at once?

Steven Manning 0 Reputation points
2026-03-13T19:57:30.6933333+00:00

How do I stop Excel from highlighting two cells at once. I printed my spreadsheet and discovered that one cell printed as ################ instead of the dollar amount of the formula for that cell. I played around with it for some time and I still can't figure it out. I did notice that the adjacent has something to do with this problem.

How can I reset the cell in question, which has a formula, to resolve this problem?

Thanks in advance.

Microsoft 365 and Office | Excel | For home | Windows

1 answer

Sort by: Most helpful
Most helpful Newest Oldest

  1. AI answer

    2026-03-13T19:57:40.2233333+00:00

    Excel is behaving as expected in both cases, and both issues are easy to fix:

    1. Cell prints as ################
      • This is not a formula error. It means the column is too narrow to display the formatted value.
      • Fix:
        1. Widen the column by dragging the right edge of the column header, or
        2. Select the column and use Home > Format > AutoFit Column Width.
    2. Excel “highlighting two cells at once”
      • In many cases this is just Excel selecting a range because of how the mouse was dragged or because Shift/Ctrl was held.
      • To reset selection:
        1. Click once on a single cell (no dragging) so only that cell is selected.
        2. If multiple cells still select unexpectedly, press Esc to cancel any active selection, then click the cell again.
      • If the worksheet is protected, selection behavior can be restricted; unprotecting the sheet (if allowed) can restore normal selection.
    3. Reset the problem cell with the formula
      • After widening the column, the formula result should display correctly.
      • If the cell is still misbehaving (for example, formatted as Text):
        1. Select the cell.
        2. Change its format to a numeric format (e.g., Number or Currency) via Format Cells > Number.
        3. Press F2, then Enter to re‑enter the formula so Excel recalculates and displays the value.

    References:

    AI-generated content may be incorrect. Read our transparency notes for more information.

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.