Forum Discussion

ymcan's avatar
ymcan
Copper Contributor
Feb 17, 2021

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...
excel
NikolinoDE's avatar
NikolinoDE
Gold Contributor
Feb 18, 2021

ymcan 

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:

    1. 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)

Resources