How to remove gridlines for all but work area

[gijeet]

Hello, I see lots of worksheets where only the work area has gridlines, the rest of the worksheet is all white - not grayed out. This focuses your attention to the work area. How to accomplish this? Thanks!

G

 

[jproffer]

If you see that, it's borders. The native gridlines are either on or off. You could turn them off and put light gray borders on your work area, I suppose.

 

[thisoldman]

The way I do it.

Turn off the gridlines for the whole sheet—on the ribbon's View tab, in the Show section, uncheck the Gridlines checkbox. I do this often so I added the command "View Gridlines" to the Quick Access Toolbar.

For the sections where I want to display gridlines, I set the cell borders to a light gray. The default Excel gridline color is R = 212, G = 212, B = 212.

In my PERSONAL.xlsb I have this macro:

Sub SetGrayBordersAll()
' Formats the selected cells with light gray borders.
' Keyboard Shortcut: Ctrl+Shift+G
''''
    If TypeName(Selection) <> "Range" Then Exit Sub
    Const MYCOLOR As Long = 13948116    ' RGB(212, 212, 212)
    Selection.Borders.Color = MYCOLOR
End Sub

I've set the keyboard shortcut and it adds the light gray border to all the selected cells when I press Ctrl+Shift+G.

 

[gijeet]

Excellent! Thanks!

 

[Macropod]

Cross-posted (and answered) at: https://www.excelforum.com/excel-general/1226969-hide-gridlines-for-all-but-work-area.html
Please read Mr Excel's policy on Cross-Posting in rule 13: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html