Forum Discussion
Strange black areas on Excel online
I am getting really strange black and blue areas covering up part of my spreadsheet when I open it in Excel on the web, it works fine on the desktop app. Any ideas what could be causing this? I first thought it was my monitor, but that works fine for everything else (you can still see the row numbers on the left hand side).
16 Replies
- SergeiBaklanDiamond Contributor
Never seen such. Was your sheet coloured manually or by conditional formatting and is such effect in any browser you have?
- acsconnerCopper Contributor
ymcan I wish I had an answer for you, but I'm just happy to see this isn't only happening to me! I've seen this on occasion for the past few weeks in Excel Online and can't figure out when/why it shows up or how to make it go away. Hoping for some answers here! I've checked settings and can't find anything that seems like it would trigger this issue.
- NikolinoDEGold Contributor
Anzeigeproblem - schwarze Felder in Excel
Hallo,
gehe bitte wie folgt vor:
Methode 1:
Deaktiviere bitte in Excel die COM-Add-Ins über Datei > Optionen > Add-Ins > COM-Add-Ins > Gehe zu und teste das Verhalten.
Hilft dies nicht, deaktiviere bitte auch die Excel-Add-Ins über Datei > Optionen > Add-Ins > Excel-Add-Ins > Gehe zu und teste das Verhalten.
Methode 2:
Setze in Excel über Datei > Optionen > Erweitert > Anzeige den Haken bei Hardwaregrafikbeschleunigung deaktivieren und teste das Verhalten.
Methode 3:
1. Schließe alle Office-Anwendungen.
2. Drücke auf deiner Tastatur die Tastenkombination Windows-Taste + R. Es öffnet sich das Dialogfenster Ausführen.
3. Gib den Befehl control printers ein und klicke auf OK.
4. Klicke mit der rechten Maustaste auf Microsoft XPS Document Writer und wähle Als Standarddrucker festlegen.
5. Teste bitte das Verhalten von Excel.
Methode 4:
1. Schließe bitte alle Office Anwendungen.
2. Drücke auf deiner Tastatur die Tastenkombination Windows-Taste + R. Es öffnet sich das Dialogfenster Ausführen.
3. Gib den Befehl regedit ein und klicke auf OK. Es öffnet sich der Registrierungseditor.
4. Navigiere bitte zu folgenden Pfaden und benenne dort jeweils den Ordner mit dem Namen Excel um zu Excel_1 (falls vorhanden und möglich):
HKEY_CURRENT_USER\Software\Microsoft\Office\Excel
HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\Excel
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Excel
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\Excel
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\14.0\Excel
5. Schließe bitte den Registrierungseditor und führe über die Systemsteuerung eine Office-Reparatur durch.
6. Teste bitte das Verhalten.
I would be happy to know if this info from link help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
- ymcanCopper Contributor
My German is limited, however I had a look at option 1 & 2 (option 3 and 4 are not possible in my situation), however there is no 'Options' menu under 'Data' in Excel online. Are you sure the solution you sent refers to Excel online?
- NikolinoDEGold Contributor
Apply or remove cell borders on a worksheet Tips
The Borders button shows the most recently used border style. To apply that style, click the Borders button (not the arrow).
If you apply a border to a selected cell, the border is also applied to adjacent cells that share a bordered cell boundary. For example, if you apply a box border to enclose the range B1:C5, the cells D1:D5 will acquire a left border.
If you apply two different types of borders to a shared cell boundary, the most recently applied border is displayed.
A selected range of cells is formatted as a single block of cells. If you apply a right border to the range of cells B1:C5, the border is displayed only on the right edge of the cells C1:C5.
If you want to print the same border on cells that are separated by a page break, but the border appears on only one page, you can apply an inside border. This way, you can print a border at the bottom of the last row of one page and use the same border at the top of the first row on the next page. Do the following:
Select the rows on both sides of the page break.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
- ArtGSMSCopper Contributor
We just started seeing the same thing today.