For a special holiday-week treat, change the color of the gridlines in Excel to red. It could drive your co-workers insane.
Actually, as time goes by, the gridlines are becoming more faint. Changing the gridline color from automatic to black might make the Excel gridlines easier to see.
Actually, as time goes by, the gridlines are becoming more faint. Changing the gridline color from automatic to black might make the Excel gridlines easier to see.
Transcript of the video:
Learn Excel from MrExcel Podcast episode 2454. Red Gridlines in Excel.
Well, this gives either be a nice thing to do for the holiday or if you just want to drive your coworkers absolutely insane.
You know the gridlines back here are nice light Gray, but you can change that.
File, Options, Advanced.
Let's go pretty far down to “Display options for this worksheet”.
There's a dropdown where you can change the grid line color.
There's red.
I had one coworker who did this, and it drove me insane.
Just as an example, here's gridlines in green.
Here's Gridlines in black.
This one might actually be useful.
It seems to me that the automatic grid lines have become fainter.
And you might actually like changing the grid line color to black. Now the one thing that's a bit of a hassle is that File, Options, Advanced, Scroll, Gridline Color affects only the current sheet.
There is VBA code.
This sets it back to automatic.
This is black, this is red, this is green.
Any of the numbers from 1 to 56 should work.
So you could add macros to the Personal Macro Workbook.
And then have a Quick Access Toolbar icon to toggle to red to black to green or automatic.
There you go, one of those very obscure tricks in Excel.
If you like these videos, please down below, Like, Subscribe, and Ring the Bell.
Feel free to post any questions or comments down in the comments below.
I want to thank you for stopping by.
I will see you next time for another netcast from MrExcel.
Let's hear you, Nancy.
Well, this gives either be a nice thing to do for the holiday or if you just want to drive your coworkers absolutely insane.
You know the gridlines back here are nice light Gray, but you can change that.
File, Options, Advanced.
Let's go pretty far down to “Display options for this worksheet”.
There's a dropdown where you can change the grid line color.
There's red.
I had one coworker who did this, and it drove me insane.
Just as an example, here's gridlines in green.
Here's Gridlines in black.
This one might actually be useful.
It seems to me that the automatic grid lines have become fainter.
And you might actually like changing the grid line color to black. Now the one thing that's a bit of a hassle is that File, Options, Advanced, Scroll, Gridline Color affects only the current sheet.
There is VBA code.
This sets it back to automatic.
This is black, this is red, this is green.
Any of the numbers from 1 to 56 should work.
So you could add macros to the Personal Macro Workbook.
And then have a Quick Access Toolbar icon to toggle to red to black to green or automatic.
There you go, one of those very obscure tricks in Excel.
If you like these videos, please down below, Like, Subscribe, and Ring the Bell.
Feel free to post any questions or comments down in the comments below.
I want to thank you for stopping by.
I will see you next time for another netcast from MrExcel.
Let's hear you, Nancy.
Last edited by a moderator:
