Forum home » Delegate support and help forum » Microsoft Excel Training and help » White gap in grid lines

White gap in grid lines

ResolvedVersion 2016

Fri 20 Apr 2018, 12:19 Delegate Katy said...

Katy has attended:
Word Introduction course
Word Intermediate course
PowerPoint Introduction course
Excel Introduction course
PowerPoint Intermediate Advanced course
Word Advanced course
Excel Advanced course

White gap in grid lines

Hi,

I seem to have a white gap within a section of my gridlines, how can i get rid of this and get it back to just showing the gridlines?

I can send over a screen shot of my spreadsheet if that helps?

Thanks,

Katy

Fri 20 Apr 2018, 18:54 Trainer Jens said...

RE: White gap in grid lines

Hi Katy,

Thank you for the forum question. It must be because you have a white fill colour in the range. Please select the range with missing borders. Click the Fill Color down arrow on the Home tab in the Font group. Click the option No Fill.

Please let me know if this is not showing your borders again.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Fri 27 Apr 2018: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Highlighting a data range

Attempting to use a mouse to highlight a large range of cells with data in Excel can make the mouse to have a life of it's own!

Use keyboard strokes instead.

Step 1. Place the cusor in the cell where the highlighting should begin.

Step 2. Select keystroke, CTRL+SHIFT+END

This will take the cursor to the furthermost bottom corner of the data range found in that worksheet. And highlight that range of cells at the same time

View all Excel hints and tips

White gap in grid lines

White gap in grid lines

RE: White gap in grid lines

Excel articles

Excel tip:

Highlighting a data range