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!
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:
' 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
I've set the keyboard shortcut and it adds the light gray border to all the selected cells when I press Ctrl+Shift+G.