Microsoft Excel – gridlines lost when formatting cell background

When you add colour to a cell background in Excel, either manually using the Cell Background  Cell background icon button or by using Conditional Formatting, you lose the gridline round the cell.

Cell gridlines


If you really want to see the gridline, you can reproduce it using the cell borders button. Select the relevant cells, then from the Borders dropdown, select All Borders, then click More Borders. The Format Cells dialog box will be displayed with the Borders tab uppermost. From the Color dropdown, choose White, Background 1, Darker 15%. On the right-hand side, click on all borders of the rectangle in the Border section.

Format Cells Borders dialog box

Click OK.

You will now see gridlines round your data.

Cell gridlines

Find out more about our Microsoft Excel training London, UK.

Find out more about our Microsoft Excel training Wiltshire, Hampshire, Dorset.



About jdonbavand

I am a trainer of Microsoft Office, Microsoft Project and Crystal Reports. I have called my blog "If Only I'd Known That...." because I hear it so many times in training sessions. In fact, if only I had a £100 (or 150 Aussie dollars)for every time someone says "If only I'd known that." ....
This entry was posted in Microsoft Excel, Microsoft Excel 2007, Microsoft Excel 2010, Microsoft Excel 2013, Microsoft Excel 2016, Uncategorized and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s