How to make 'Grid Lines' visible after using 'Fill Color' in Excel Online?

Anonymous
2017-12-19T03:20:57+00:00

I filled color in Excel Online but as I filled the color, suddenly the Grid Lines in colored grids disappeared.

How can I make them visible?

Here's a screenshot of disappeared grid lines:

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
{count} votes
Answer accepted by question author
  1. Anonymous
    2017-12-19T03:49:34+00:00

    Hello,

    the Excel grid lines are only visible when a cell has no fill. If you want to see grid lines on cells with a fill colour, you need to format the cell borders.

    Tip: Create a style that has the fill AND the cell borders applied, then you only need on click in the Styles panel to apply the look.

    202 people found this answer helpful.
    0 comments No comments

3 additional answers

Sort by: Most helpful
  1. Anonymous
    2017-12-19T04:04:12+00:00

    Thanks. But I wish think that Excel should take care of this by itself. Just like google docs does. Here's a screen shot of the same situation in Google Sheets:

    Anyways thanks for the answer, it solved my problem.

    Also, can you please suggest me some resources for learning Excel-Online?

    60 people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2017-12-19T08:18:15+00:00

    Online resources for learning Excel or resources about the specifics of Excel in a browser?? Excel online is a sub-set of Excel desktop. It can show most things that are created in Excel for desktop, like tables, pivot tables, conditional formats, shapes, slicers, but many of these can not be created in Excel online. Microsoft adds new functionality to Excel online all the time, though, so what does not work today may work tomorrow.

    2 people found this answer helpful.
    0 comments No comments
  3. Anonymous
    2017-12-19T09:36:56+00:00

    Thanks.

    1 person found this answer helpful.
    0 comments No comments