Google Sheets (Excel) - Always highlighted sheet?

[TAPS_MikeDion]

Would anyone happen to know why every time I go to one specific sheet in the Google Sheets/Excel workbook I'm working on, that particular sheet has all of its cells highlighted?

I'm guessing it's something simple I'm missing.

Every time I go to that one sheet, even if I click a cell to remove the highlighting, when I go back to that sheet, the entire sheet of cells is highlighted again.

 

[sijpie]

Are you working in Excel or in Google? Or is it happening on both?
Is it happening just on one particular sheet or any sheet regardless?

have you checked to see if there is a macro in the sheet module that is causing this? (In Excel right click on the sheet tab, select 'view code'. Is there a macro named Worksheet_Activate)

 

[TAPS_MikeDion]

It's within Google Sheets.

It is happening on only one particular sheet and I still can't figure out why.

 

[Literae]

Try checking "Conditional Formatting". There maybe some cells using a colour format if empty or containing text. Highlight the whole sheet first.

 

[TousleyTN]

Would anyone happen to know why every time I go to one specific sheet in the Google Sheets/Excel workbook I'm working on, that particular sheet has all of its cells highlighted?

I'm guessing it's something simple I'm missing.

Every time I go to that one sheet, even if I click a cell to remove the highlighting, when I go back to that sheet, the entire sheet of cells is highlighted again.

I had the same issue recently, but the problem was my habits and personal awareness vice software in question...

Google Sheets is browser browser-based, and you can live-edit a page you have rights to modify from multiple browsers / computers, etc. Part of it's charm, truly. However, design-wise this means you need to know when a cell you can see is potentially under edit from another browser instance. Google does this without much fan fare by changing the background color of the cell in other instances. There really is no way I'm aware of to find out 'where precisely' that edit is occurring, but if you reboot all the potential systems, that will likely tackle the stray edit underway and resolve the miscolored cell.

When I did it I could only be mad at myself for tending to have so many **** tabs open. I like to keep my data sheets active as I flip around and so dozens of things at once.

Like I said up top, my problem...