Excel - can you change the line colour of a Freeze panel divider?
up vote
2
down vote
favorite
I've been doing a stylistic overhaul of some daily checksheets we use for cross-checking data. The first three rows have been set as a Frozen pane so they remain at the top as you scroll, but ideally I'd like to change the colour of the divider in order to have it stand out less.
I've tried adjusting the bottom border of row three, but no matter what I do with it I'm still left with the black 1px line underneath it. Does anybody know of any way to change or remove it?
I note that this guy over on MrExcel.com once had the opposite problem of his Windows 7 theme over-riding the black and making it gray, but I can't find anybody else who's written about this.
Edit:
Thanks to @jcbermu for the thought that if the line can't be changed, a top-down fill could be applied to the row above it. Though this doesn't change the divider, it can be used to fool the eye with the appearance of a line change, and at least allows departure from the stark black-and-whiteness of the default setting, assuming it is indeed impossible to modify the 1px line itself as @teylyn affirms. Will mark the answer as accepted if nothing else comes in within 3 days.
microsoft-excel microsoft-excel-2010 colors format
asked Jun 19 '15 at 11:23
Steve Taylor
465522
add a comment |
up vote
2
down vote
favorite
I've been doing a stylistic overhaul of some daily checksheets we use for cross-checking data. The first three rows have been set as a Frozen pane so they remain at the top as you scroll, but ideally I'd like to change the colour of the divider in order to have it stand out less.
I've tried adjusting the bottom border of row three, but no matter what I do with it I'm still left with the black 1px line underneath it. Does anybody know of any way to change or remove it?
I note that this guy over on MrExcel.com once had the opposite problem of his Windows 7 theme over-riding the black and making it gray, but I can't find anybody else who's written about this.
Edit:
Thanks to @jcbermu for the thought that if the line can't be changed, a top-down fill could be applied to the row above it. Though this doesn't change the divider, it can be used to fool the eye with the appearance of a line change, and at least allows departure from the stark black-and-whiteness of the default setting, assuming it is indeed impossible to modify the 1px line itself as @teylyn affirms. Will mark the answer as accepted if nothing else comes in within 3 days.
microsoft-excel microsoft-excel-2010 colors format
asked Jun 19 '15 at 11:23
Steve Taylor
465522
add a comment |
up vote
2
down vote
favorite
up vote
2
down vote
favorite
I've been doing a stylistic overhaul of some daily checksheets we use for cross-checking data. The first three rows have been set as a Frozen pane so they remain at the top as you scroll, but ideally I'd like to change the colour of the divider in order to have it stand out less.
I've tried adjusting the bottom border of row three, but no matter what I do with it I'm still left with the black 1px line underneath it. Does anybody know of any way to change or remove it?
I note that this guy over on MrExcel.com once had the opposite problem of his Windows 7 theme over-riding the black and making it gray, but I can't find anybody else who's written about this.
Edit:
Thanks to @jcbermu for the thought that if the line can't be changed, a top-down fill could be applied to the row above it. Though this doesn't change the divider, it can be used to fool the eye with the appearance of a line change, and at least allows departure from the stark black-and-whiteness of the default setting, assuming it is indeed impossible to modify the 1px line itself as @teylyn affirms. Will mark the answer as accepted if nothing else comes in within 3 days.
microsoft-excel microsoft-excel-2010 colors format
asked Jun 19 '15 at 11:23
Steve Taylor
465522
I've been doing a stylistic overhaul of some daily checksheets we use for cross-checking data. The first three rows have been set as a Frozen pane so they remain at the top as you scroll, but ideally I'd like to change the colour of the divider in order to have it stand out less.
I've tried adjusting the bottom border of row three, but no matter what I do with it I'm still left with the black 1px line underneath it. Does anybody know of any way to change or remove it?
I note that this guy over on MrExcel.com once had the opposite problem of his Windows 7 theme over-riding the black and making it gray, but I can't find anybody else who's written about this.
Edit:
Thanks to @jcbermu for the thought that if the line can't be changed, a top-down fill could be applied to the row above it. Though this doesn't change the divider, it can be used to fool the eye with the appearance of a line change, and at least allows departure from the stark black-and-whiteness of the default setting, assuming it is indeed impossible to modify the 1px line itself as @teylyn affirms. Will mark the answer as accepted if nothing else comes in within 3 days.
microsoft-excel microsoft-excel-2010 colors format
microsoft-excel microsoft-excel-2010 colors format
asked Jun 19 '15 at 11:23
Steve Taylor
465522
asked Jun 19 '15 at 11:23
Steve Taylor
465522
edited Jun 19 '15 at 12:31
asked Jun 19 '15 at 11:23
Steve Taylor
465522
asked Jun 19 '15 at 11:23
Steve Taylor
465522
asked Jun 19 '15 at 11:23
Steve Taylor
465522
465522
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
2
down vote
accepted
As far as I'm aware, the color of the Freeze Panes divider line cannot be customized with either the Excel user interface nor the VBA object model.
Don't shoot the messenger.
answered Jun 19 '15 at 11:41
teylyn
16.7k22438
1
This is a way to disguise it that looks interesting datapigtechnologies.com/blog/index.php/…
– jcbermu
Jun 19 '15 at 11:50
@jcbermu Nice catch, but I agree with Mike Alexander that this most convoluted way to manipulate the line appearance is not the desired solution.
– teylyn
Jun 19 '15 at 11:57
thanks @jcbermu, that's an interesting idea. I'd tried using a custom shape in a similar way, but hadn't thought about using shading to change the style of the line. I suppose the same idea could be managed more neatly by having a blank line 3 with a custom top-to-bottom fade fill.
– Steve Taylor
Jun 19 '15 at 11:57
1
That solution looked promising. I was hoping there might be a way to extend the shape over the divider or use an outside shadow with 0% transparency to hide it with something that can be controlled, but no matter what you do the divider is superimposed over the shape. Same with charts and pictures. You can make it stand out more by applying a thicker bottom/right border to the frozen row/column in the same color as the divider (4th lightest gray, "White, Background 1, Darker 35%"), but both workarounds only make the divider blend into something else. It's impossible to change it.
– Adi Inbar
Aug 16 '16 at 20:43
add a comment |
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f929913%2fexcel-can-you-change-the-line-colour-of-a-freeze-panel-divider%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
2
down vote
accepted
As far as I'm aware, the color of the Freeze Panes divider line cannot be customized with either the Excel user interface nor the VBA object model.
Don't shoot the messenger.
answered Jun 19 '15 at 11:41
teylyn
16.7k22438
1
This is a way to disguise it that looks interesting datapigtechnologies.com/blog/index.php/…
– jcbermu
Jun 19 '15 at 11:50
@jcbermu Nice catch, but I agree with Mike Alexander that this most convoluted way to manipulate the line appearance is not the desired solution.
– teylyn
Jun 19 '15 at 11:57
thanks @jcbermu, that's an interesting idea. I'd tried using a custom shape in a similar way, but hadn't thought about using shading to change the style of the line. I suppose the same idea could be managed more neatly by having a blank line 3 with a custom top-to-bottom fade fill.
– Steve Taylor
Jun 19 '15 at 11:57
1
That solution looked promising. I was hoping there might be a way to extend the shape over the divider or use an outside shadow with 0% transparency to hide it with something that can be controlled, but no matter what you do the divider is superimposed over the shape. Same with charts and pictures. You can make it stand out more by applying a thicker bottom/right border to the frozen row/column in the same color as the divider (4th lightest gray, "White, Background 1, Darker 35%"), but both workarounds only make the divider blend into something else. It's impossible to change it.
– Adi Inbar
Aug 16 '16 at 20:43
add a comment |
up vote
2
down vote
accepted
As far as I'm aware, the color of the Freeze Panes divider line cannot be customized with either the Excel user interface nor the VBA object model.
Don't shoot the messenger.
answered Jun 19 '15 at 11:41
teylyn
16.7k22438
1
This is a way to disguise it that looks interesting datapigtechnologies.com/blog/index.php/…
– jcbermu
Jun 19 '15 at 11:50
@jcbermu Nice catch, but I agree with Mike Alexander that this most convoluted way to manipulate the line appearance is not the desired solution.
– teylyn
Jun 19 '15 at 11:57
thanks @jcbermu, that's an interesting idea. I'd tried using a custom shape in a similar way, but hadn't thought about using shading to change the style of the line. I suppose the same idea could be managed more neatly by having a blank line 3 with a custom top-to-bottom fade fill.
– Steve Taylor
Jun 19 '15 at 11:57
1
That solution looked promising. I was hoping there might be a way to extend the shape over the divider or use an outside shadow with 0% transparency to hide it with something that can be controlled, but no matter what you do the divider is superimposed over the shape. Same with charts and pictures. You can make it stand out more by applying a thicker bottom/right border to the frozen row/column in the same color as the divider (4th lightest gray, "White, Background 1, Darker 35%"), but both workarounds only make the divider blend into something else. It's impossible to change it.
– Adi Inbar
Aug 16 '16 at 20:43
add a comment |
up vote
2
down vote
accepted
up vote
2
down vote
accepted
As far as I'm aware, the color of the Freeze Panes divider line cannot be customized with either the Excel user interface nor the VBA object model.
Don't shoot the messenger.
answered Jun 19 '15 at 11:41
teylyn
16.7k22438
As far as I'm aware, the color of the Freeze Panes divider line cannot be customized with either the Excel user interface nor the VBA object model.
Don't shoot the messenger.
answered Jun 19 '15 at 11:41
teylyn
16.7k22438
answered Jun 19 '15 at 11:41
teylyn
16.7k22438
answered Jun 19 '15 at 11:41
teylyn
16.7k22438
answered Jun 19 '15 at 11:41
teylyn
16.7k22438
16.7k22438
1
This is a way to disguise it that looks interesting datapigtechnologies.com/blog/index.php/…
– jcbermu
Jun 19 '15 at 11:50
@jcbermu Nice catch, but I agree with Mike Alexander that this most convoluted way to manipulate the line appearance is not the desired solution.
– teylyn
Jun 19 '15 at 11:57
thanks @jcbermu, that's an interesting idea. I'd tried using a custom shape in a similar way, but hadn't thought about using shading to change the style of the line. I suppose the same idea could be managed more neatly by having a blank line 3 with a custom top-to-bottom fade fill.
– Steve Taylor
Jun 19 '15 at 11:57
1
That solution looked promising. I was hoping there might be a way to extend the shape over the divider or use an outside shadow with 0% transparency to hide it with something that can be controlled, but no matter what you do the divider is superimposed over the shape. Same with charts and pictures. You can make it stand out more by applying a thicker bottom/right border to the frozen row/column in the same color as the divider (4th lightest gray, "White, Background 1, Darker 35%"), but both workarounds only make the divider blend into something else. It's impossible to change it.
– Adi Inbar
Aug 16 '16 at 20:43
add a comment |
1
This is a way to disguise it that looks interesting datapigtechnologies.com/blog/index.php/…
– jcbermu
Jun 19 '15 at 11:50
@jcbermu Nice catch, but I agree with Mike Alexander that this most convoluted way to manipulate the line appearance is not the desired solution.
– teylyn
Jun 19 '15 at 11:57
thanks @jcbermu, that's an interesting idea. I'd tried using a custom shape in a similar way, but hadn't thought about using shading to change the style of the line. I suppose the same idea could be managed more neatly by having a blank line 3 with a custom top-to-bottom fade fill.
– Steve Taylor
Jun 19 '15 at 11:57
1
That solution looked promising. I was hoping there might be a way to extend the shape over the divider or use an outside shadow with 0% transparency to hide it with something that can be controlled, but no matter what you do the divider is superimposed over the shape. Same with charts and pictures. You can make it stand out more by applying a thicker bottom/right border to the frozen row/column in the same color as the divider (4th lightest gray, "White, Background 1, Darker 35%"), but both workarounds only make the divider blend into something else. It's impossible to change it.
– Adi Inbar
Aug 16 '16 at 20:43
1
1
This is a way to disguise it that looks interesting datapigtechnologies.com/blog/index.php/…
– jcbermu
Jun 19 '15 at 11:50
This is a way to disguise it that looks interesting datapigtechnologies.com/blog/index.php/…
– jcbermu
Jun 19 '15 at 11:50
@jcbermu Nice catch, but I agree with Mike Alexander that this most convoluted way to manipulate the line appearance is not the desired solution.
– teylyn
Jun 19 '15 at 11:57
@jcbermu Nice catch, but I agree with Mike Alexander that this most convoluted way to manipulate the line appearance is not the desired solution.
– teylyn
Jun 19 '15 at 11:57
thanks @jcbermu, that's an interesting idea. I'd tried using a custom shape in a similar way, but hadn't thought about using shading to change the style of the line. I suppose the same idea could be managed more neatly by having a blank line 3 with a custom top-to-bottom fade fill.
– Steve Taylor
Jun 19 '15 at 11:57
thanks @jcbermu, that's an interesting idea. I'd tried using a custom shape in a similar way, but hadn't thought about using shading to change the style of the line. I suppose the same idea could be managed more neatly by having a blank line 3 with a custom top-to-bottom fade fill.
– Steve Taylor
Jun 19 '15 at 11:57
1
1
That solution looked promising. I was hoping there might be a way to extend the shape over the divider or use an outside shadow with 0% transparency to hide it with something that can be controlled, but no matter what you do the divider is superimposed over the shape. Same with charts and pictures. You can make it stand out more by applying a thicker bottom/right border to the frozen row/column in the same color as the divider (4th lightest gray, "White, Background 1, Darker 35%"), but both workarounds only make the divider blend into something else. It's impossible to change it.
– Adi Inbar
Aug 16 '16 at 20:43
That solution looked promising. I was hoping there might be a way to extend the shape over the divider or use an outside shadow with 0% transparency to hide it with something that can be controlled, but no matter what you do the divider is superimposed over the shape. Same with charts and pictures. You can make it stand out more by applying a thicker bottom/right border to the frozen row/column in the same color as the divider (4th lightest gray, "White, Background 1, Darker 35%"), but both workarounds only make the divider blend into something else. It's impossible to change it.
– Adi Inbar
Aug 16 '16 at 20:43
add a comment |
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f929913%2fexcel-can-you-change-the-line-colour-of-a-freeze-panel-divider%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
