How to change default background color in excel 2010 to make grid more visible

status1

New Member
Joined
Mar 26, 2025
Messages
4
Office Version
  1. 2010
I got a new pc with windows 11 and I installed excel 2010 on it The problem I am trying to fix is to have visible grid lines
By default when I right click to open a new spreadsheet it opens with 3 sheets that are all white with no visible grid because the grid lines are also white
On the old pc with windows 7 and excel 2010 I have it so the background is light gray and the grid lines are white but I don't remember how I did it since it was many years ago

I made a template which works if I use excel.exe to open anew spreadsheet but for some reason when I right click it's not using that template
I vaguely remember trying to use a fill color as a background but I am not sure if that is a permanent solution that would work with right click
Can something be done in the registry perhaps ?
Is there a way to know if excel is storing these files somewhere that are used when doing the right click or are these files just built into excel ?
 
not sure on making background grey
BUT to show grid lines on 2010
Excel 2010, go to File > Options > Advanced, scroll down to "Display options for this worksheet", and make sure the "Show gridlines" checkbox is selected
 
Upvote 0
but for some reason when I right click it's not using that template
The template for that is usually "C:\Program Files\Microsoft Office\root\vfs\Windows\SHELLNEW\EXCEL12.XLSX"
 
Upvote 0
The grid lines are on it's just not visible
I can make the grid lines visible by choosing a different color other than white but that is just for that sheet it does not affect a new sheet
Also I have a template but not in that folder actually I don't have any sub folder called root
I have a template in the XLSTART folder but as I said it makes no difference because when I right click the template is not used
 
Upvote 0
I put my hard drive back in the old pc with windows 7 and I found out why it is working there
It was the windows color that I set to light gray so it doesn't need any template

Is it possible to change the window color in windows 11 ? I have seen the dark mode but I don't want to use that
 
Upvote 0
sorry i have no idea on windows 11 issues , hopefully other members may know
 
Upvote 0
I finally got it fixed and it was a lot simpler than I thought I did another search for white grid lines and there was a link on the Microsoft website that was provided to a user with similar problem and this was the link Microsoft confirms new Windows 11 issue: some Apps may render Colors Incorrectly - gHacks Tech News

The link was saying that some windows 11 had a problem rendering accurate colors

So than I started thinking that it could be a display issue since it worked on the laptop but not on the desktop So than I adjusted the display from warm to cool while I had the excel open with white grid lines and as soon as I changed the setting to cool the grid lines showed up


Now I can open any file old or new and see the grid lines
 
Upvote 0
Solution

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top