default worksheet background color

Kade

Active Member
Joined
Jul 20, 2002
Messages
258
Hi,

I expect this is an egg on face question, and I have searched and the board for a solution.

How can I alter the default background colour of a worksheet so that when I open a new file the background (all cells) will be, say, very light grey?

I don't want to select all and then force the colour.

I was hoping it would be a selectable option but I can't find it.

If not is there code that can do it.

thanks kade
 

Excel Facts

Lock one reference in a formula
Need 1 part of a formula to always point to the same range? use $ signs: $V$2:$Z$99 will always point to V2:Z99, even after copying
Some solutions,

the first one is more drastic. You can change the "Window background" color in the Display settings.

two, you can create a new template, called Book.xlt, with the green background.

three... mmhmm, maybe, a macro in the Personal.xls workbook, or in an addin that loads on startup that has application events enabled, checking for every new workbook.
 
Upvote 0
thanks Juan,


The first option, I assume you mean the complete windows default not just excel?. A bit to drastic for me, and as this file is distributed to others it wouldn't work on their computers

The second, I assume you mean select all cells, apply the colour and save as a xlt (tried this but causes probs in the default pring range)

I was hoping it could be achieved so that when I selected "no fill" on cell colour it would show the selected shade.

I do not have the skills to embark on your third option

Perhaps my needs are a bit fussy ~~

ta kade
 
Upvote 0
If you're OK with an .xlt solution, how about this:

1) Open MS paint or equivalent
2) Create a picture with just the colour you want (simple with the 'fill with colour' option
3) save picture.
4) In excel, open new file
5) Format | sheet | Background - select your file
6) Save as .xlt

Paddy
 
Upvote 0
Paddy you are a genius!
This does exactly what I want

Follow up Q.
no need to reply if no answer, but I was curious if it was possible for later inserted sheets to automatically have this background formatting?

No big deal as I can easily get round it by move /copy sheet when I need extra sheets. Just curious if the insert sheet can be pre formatted.

I understand that code could do the job somehow but this would not be warranted.

anyhow thanks again Paddy

kade
 
Upvote 0
I think there are Sheet templates also?? SO when the user inserst another sheet the option is there to insert your template. Look in Help under "Sheet Template".

Richard
 
Upvote 0

Forum statistics

Threads
1,213,565
Messages
6,114,338
Members
448,570
Latest member
rik81h

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