How we can add background color in EXCEL for printing?
How we can add background color in EXCEL for printing? I create a small image with gray color and add it to PAGE LAYOUT-Background Image. When I see the main window of EXCEL everything is fine and all cells are gray but in print page only used cells are gray and other remaining cells are white. How can I set all page background color to a specific color for printing?
microsoft-excel printing colors
edited Oct 14 '15 at 10:40
Chenmunka
2,79481931
asked Sep 20 '15 at 12:53
user2991243user2991243
11627
add a comment |
How we can add background color in EXCEL for printing? I create a small image with gray color and add it to PAGE LAYOUT-Background Image. When I see the main window of EXCEL everything is fine and all cells are gray but in print page only used cells are gray and other remaining cells are white. How can I set all page background color to a specific color for printing?
microsoft-excel printing colors
edited Oct 14 '15 at 10:40
Chenmunka
2,79481931
asked Sep 20 '15 at 12:53
user2991243user2991243
11627
As per Microsoft support site: support.microsoft.com/en-us/kb/213977, You cannot print a background graphic for a Excel worksheet
– Prasanna
Sep 20 '15 at 13:59
You are right @teylyn, Images fromimgurdo not load in my office PC. Just checked the question from the mobile app and got to see the image. Thanks
– Prasanna
Sep 21 '15 at 9:19
Your approach the problem is incorrect. If you add an image to theBackgroundunder Page layout - you will never see it in print. Use fill cells to get the desired colour
– Prasanna
Sep 21 '15 at 9:30
There is a work-around if you want to print with background extendoffice.com/documents/excel/…
– Prasanna
Sep 21 '15 at 9:35
add a comment |
How we can add background color in EXCEL for printing? I create a small image with gray color and add it to PAGE LAYOUT-Background Image. When I see the main window of EXCEL everything is fine and all cells are gray but in print page only used cells are gray and other remaining cells are white. How can I set all page background color to a specific color for printing?
microsoft-excel printing colors
edited Oct 14 '15 at 10:40
Chenmunka
2,79481931
asked Sep 20 '15 at 12:53
user2991243user2991243
11627
How we can add background color in EXCEL for printing? I create a small image with gray color and add it to PAGE LAYOUT-Background Image. When I see the main window of EXCEL everything is fine and all cells are gray but in print page only used cells are gray and other remaining cells are white. How can I set all page background color to a specific color for printing?
microsoft-excel printing colors
microsoft-excel printing colors
edited Oct 14 '15 at 10:40
Chenmunka
2,79481931
asked Sep 20 '15 at 12:53
user2991243user2991243
11627
edited Oct 14 '15 at 10:40
Chenmunka
2,79481931
asked Sep 20 '15 at 12:53
user2991243user2991243
11627
edited Oct 14 '15 at 10:40
Chenmunka
2,79481931
edited Oct 14 '15 at 10:40
Chenmunka
2,79481931
edited Oct 14 '15 at 10:40
Chenmunka
2,79481931
2,79481931
asked Sep 20 '15 at 12:53
user2991243user2991243
11627
asked Sep 20 '15 at 12:53
user2991243user2991243
11627
asked Sep 20 '15 at 12:53
user2991243user2991243
11627
11627
As per Microsoft support site: support.microsoft.com/en-us/kb/213977, You cannot print a background graphic for a Excel worksheet
– Prasanna
Sep 20 '15 at 13:59
You are right @teylyn, Images fromimgurdo not load in my office PC. Just checked the question from the mobile app and got to see the image. Thanks
– Prasanna
Sep 21 '15 at 9:19
Your approach the problem is incorrect. If you add an image to theBackgroundunder Page layout - you will never see it in print. Use fill cells to get the desired colour
– Prasanna
Sep 21 '15 at 9:30
There is a work-around if you want to print with background extendoffice.com/documents/excel/…
– Prasanna
Sep 21 '15 at 9:35
add a comment |
As per Microsoft support site: support.microsoft.com/en-us/kb/213977, You cannot print a background graphic for a Excel worksheet
– Prasanna
Sep 20 '15 at 13:59
You are right @teylyn, Images fromimgurdo not load in my office PC. Just checked the question from the mobile app and got to see the image. Thanks
– Prasanna
Sep 21 '15 at 9:19
Your approach the problem is incorrect. If you add an image to theBackgroundunder Page layout - you will never see it in print. Use fill cells to get the desired colour
– Prasanna
Sep 21 '15 at 9:30
There is a work-around if you want to print with background extendoffice.com/documents/excel/…
– Prasanna
Sep 21 '15 at 9:35
As per Microsoft support site: support.microsoft.com/en-us/kb/213977, You cannot print a background graphic for a Excel worksheet
– Prasanna
Sep 20 '15 at 13:59
As per Microsoft support site: support.microsoft.com/en-us/kb/213977, You cannot print a background graphic for a Excel worksheet
– Prasanna
Sep 20 '15 at 13:59
You are right @teylyn, Images from
imgur do not load in my office PC. Just checked the question from the mobile app and got to see the image. Thanks– Prasanna
Sep 21 '15 at 9:19
You are right @teylyn, Images from
imgur do not load in my office PC. Just checked the question from the mobile app and got to see the image. Thanks– Prasanna
Sep 21 '15 at 9:19
Your approach the problem is incorrect. If you add an image to the
Background under Page layout - you will never see it in print. Use fill cells to get the desired colour– Prasanna
Sep 21 '15 at 9:30
Your approach the problem is incorrect. If you add an image to the
Background under Page layout - you will never see it in print. Use fill cells to get the desired colour– Prasanna
Sep 21 '15 at 9:30
There is a work-around if you want to print with background extendoffice.com/documents/excel/…
– Prasanna
Sep 21 '15 at 9:35
There is a work-around if you want to print with background extendoffice.com/documents/excel/…
– Prasanna
Sep 21 '15 at 9:35
add a comment |
1 Answer
1
active
oldest
votes
What is the print area? What do you see when you switch to View > Page break preview? Are the page breaks where you expect them to be? If not, change the print area (in Normal view, select the cells you want to print and click Page Layout > Print Area > Set Print Area, or in Page break preview drag the blue page borders)
answered Sep 21 '15 at 9:00
teylynteylyn
17.3k22539
I guess that the OP is on a wrong path to dofill cellsif he is going to usebackgroundimage for that
– Prasanna
Sep 21 '15 at 9:31
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',
autoActivateHeartbeat: false,
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%2f975587%2fhow-we-can-add-background-color-in-excel-for-printing%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
What is the print area? What do you see when you switch to View > Page break preview? Are the page breaks where you expect them to be? If not, change the print area (in Normal view, select the cells you want to print and click Page Layout > Print Area > Set Print Area, or in Page break preview drag the blue page borders)
answered Sep 21 '15 at 9:00
teylynteylyn
17.3k22539
I guess that the OP is on a wrong path to dofill cellsif he is going to usebackgroundimage for that
– Prasanna
Sep 21 '15 at 9:31
add a comment |
What is the print area? What do you see when you switch to View > Page break preview? Are the page breaks where you expect them to be? If not, change the print area (in Normal view, select the cells you want to print and click Page Layout > Print Area > Set Print Area, or in Page break preview drag the blue page borders)
answered Sep 21 '15 at 9:00
teylynteylyn
17.3k22539
I guess that the OP is on a wrong path to dofill cellsif he is going to usebackgroundimage for that
– Prasanna
Sep 21 '15 at 9:31
add a comment |
What is the print area? What do you see when you switch to View > Page break preview? Are the page breaks where you expect them to be? If not, change the print area (in Normal view, select the cells you want to print and click Page Layout > Print Area > Set Print Area, or in Page break preview drag the blue page borders)
answered Sep 21 '15 at 9:00
teylynteylyn
17.3k22539
What is the print area? What do you see when you switch to View > Page break preview? Are the page breaks where you expect them to be? If not, change the print area (in Normal view, select the cells you want to print and click Page Layout > Print Area > Set Print Area, or in Page break preview drag the blue page borders)
answered Sep 21 '15 at 9:00
teylynteylyn
17.3k22539
edited Sep 21 '15 at 9:25
answered Sep 21 '15 at 9:00
teylynteylyn
17.3k22539
answered Sep 21 '15 at 9:00
teylynteylyn
17.3k22539
answered Sep 21 '15 at 9:00
teylynteylyn
17.3k22539
17.3k22539
I guess that the OP is on a wrong path to dofill cellsif he is going to usebackgroundimage for that
– Prasanna
Sep 21 '15 at 9:31
add a comment |
I guess that the OP is on a wrong path to dofill cellsif he is going to usebackgroundimage for that
– Prasanna
Sep 21 '15 at 9:31
I guess that the OP is on a wrong path to do
fill cells if he is going to use background image for that– Prasanna
Sep 21 '15 at 9:31
I guess that the OP is on a wrong path to do
fill cells if he is going to use background image for that– Prasanna
Sep 21 '15 at 9:31
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.
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%2f975587%2fhow-we-can-add-background-color-in-excel-for-printing%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
As per Microsoft support site: support.microsoft.com/en-us/kb/213977, You cannot print a background graphic for a Excel worksheet
– Prasanna
Sep 20 '15 at 13:59
You are right @teylyn, Images from
imgurdo not load in my office PC. Just checked the question from the mobile app and got to see the image. Thanks– Prasanna
Sep 21 '15 at 9:19
Your approach the problem is incorrect. If you add an image to the
Backgroundunder Page layout - you will never see it in print. Use fill cells to get the desired colour– Prasanna
Sep 21 '15 at 9:30
There is a work-around if you want to print with background extendoffice.com/documents/excel/…
– Prasanna
Sep 21 '15 at 9:35