Print two arbitrary excel worksheets as one page, double-sided
up vote
1
down vote
favorite
I have an Excel file. It contains several worksheets (ex: A, B, C, D ...). Each worksheet prints on one page in the same orientation.
How do I quickly print any two of these worksheets (ex: A & C, B & C, etc.) as a single page, double-sided?
If I ctrl select the two worksheet tabs and print, Excel will print just those 2 selected worksheets, but they print as separate pages even when the double-sided print option from the Excel print screen is set.
microsoft-excel printing microsoft-excel-2013
asked Oct 13 '15 at 6:17
Colin Fukai
10614
add a comment |
up vote
1
down vote
favorite
I have an Excel file. It contains several worksheets (ex: A, B, C, D ...). Each worksheet prints on one page in the same orientation.
How do I quickly print any two of these worksheets (ex: A & C, B & C, etc.) as a single page, double-sided?
If I ctrl select the two worksheet tabs and print, Excel will print just those 2 selected worksheets, but they print as separate pages even when the double-sided print option from the Excel print screen is set.
microsoft-excel printing microsoft-excel-2013
asked Oct 13 '15 at 6:17
Colin Fukai
10614
1
if you can't manage to work it directly from Excel, try to export to pdf first.
– Máté Juhász
Oct 13 '15 at 6:22
Did you try to Ctrl select the two worksheets, open a new document, paste there and print? Else I suppose you can overcame with a little macro.
– Hastur
Oct 13 '15 at 7:40
Ctrl select worksheets (holding Ctrl and clicking on the worksheet tabs) and then copy them to single new worksheet? I tried and did not work. So far, export to PDF seems to be the easiest way.
– Colin Fukai
Oct 16 '15 at 1:33
add a comment |
up vote
1
down vote
favorite
up vote
1
down vote
favorite
I have an Excel file. It contains several worksheets (ex: A, B, C, D ...). Each worksheet prints on one page in the same orientation.
How do I quickly print any two of these worksheets (ex: A & C, B & C, etc.) as a single page, double-sided?
If I ctrl select the two worksheet tabs and print, Excel will print just those 2 selected worksheets, but they print as separate pages even when the double-sided print option from the Excel print screen is set.
microsoft-excel printing microsoft-excel-2013
asked Oct 13 '15 at 6:17
Colin Fukai
10614
I have an Excel file. It contains several worksheets (ex: A, B, C, D ...). Each worksheet prints on one page in the same orientation.
How do I quickly print any two of these worksheets (ex: A & C, B & C, etc.) as a single page, double-sided?
If I ctrl select the two worksheet tabs and print, Excel will print just those 2 selected worksheets, but they print as separate pages even when the double-sided print option from the Excel print screen is set.
microsoft-excel printing microsoft-excel-2013
microsoft-excel printing microsoft-excel-2013
asked Oct 13 '15 at 6:17
Colin Fukai
10614
asked Oct 13 '15 at 6:17
Colin Fukai
10614
asked Oct 13 '15 at 6:17
Colin Fukai
10614
asked Oct 13 '15 at 6:17
Colin Fukai
10614
asked Oct 13 '15 at 6:17
Colin Fukai
10614
10614
1
if you can't manage to work it directly from Excel, try to export to pdf first.
– Máté Juhász
Oct 13 '15 at 6:22
Did you try to Ctrl select the two worksheets, open a new document, paste there and print? Else I suppose you can overcame with a little macro.
– Hastur
Oct 13 '15 at 7:40
Ctrl select worksheets (holding Ctrl and clicking on the worksheet tabs) and then copy them to single new worksheet? I tried and did not work. So far, export to PDF seems to be the easiest way.
– Colin Fukai
Oct 16 '15 at 1:33
add a comment |
1
if you can't manage to work it directly from Excel, try to export to pdf first.
– Máté Juhász
Oct 13 '15 at 6:22
Did you try to Ctrl select the two worksheets, open a new document, paste there and print? Else I suppose you can overcame with a little macro.
– Hastur
Oct 13 '15 at 7:40
Ctrl select worksheets (holding Ctrl and clicking on the worksheet tabs) and then copy them to single new worksheet? I tried and did not work. So far, export to PDF seems to be the easiest way.
– Colin Fukai
Oct 16 '15 at 1:33
1
1
if you can't manage to work it directly from Excel, try to export to pdf first.
– Máté Juhász
Oct 13 '15 at 6:22
if you can't manage to work it directly from Excel, try to export to pdf first.
– Máté Juhász
Oct 13 '15 at 6:22
Did you try to Ctrl select the two worksheets, open a new document, paste there and print? Else I suppose you can overcame with a little macro.
– Hastur
Oct 13 '15 at 7:40
Did you try to Ctrl select the two worksheets, open a new document, paste there and print? Else I suppose you can overcame with a little macro.
– Hastur
Oct 13 '15 at 7:40
Ctrl select worksheets (holding Ctrl and clicking on the worksheet tabs) and then copy them to single new worksheet? I tried and did not work. So far, export to PDF seems to be the easiest way.
– Colin Fukai
Oct 16 '15 at 1:33
Ctrl select worksheets (holding Ctrl and clicking on the worksheet tabs) and then copy them to single new worksheet? I tried and did not work. So far, export to PDF seems to be the easiest way.
– Colin Fukai
Oct 16 '15 at 1:33
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
There is a solution, following the @MatheJuhasz comment:
Select the sheets you would like to print by holding CTRL and
clicking on individual worksheets.Save those as a .pdf (File->Save as ... -> Save at type:PDF)
Print .pdf on both sides, as usually.
Tadaaaa!!! :)
answered Feb 2 '17 at 9:51
maycca
1012
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%2f985927%2fprint-two-arbitrary-excel-worksheets-as-one-page-double-sided%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
0
down vote
There is a solution, following the @MatheJuhasz comment:
Select the sheets you would like to print by holding CTRL and
clicking on individual worksheets.Save those as a .pdf (File->Save as ... -> Save at type:PDF)
Print .pdf on both sides, as usually.
Tadaaaa!!! :)
answered Feb 2 '17 at 9:51
maycca
1012
add a comment |
up vote
0
down vote
There is a solution, following the @MatheJuhasz comment:
Select the sheets you would like to print by holding CTRL and
clicking on individual worksheets.Save those as a .pdf (File->Save as ... -> Save at type:PDF)
Print .pdf on both sides, as usually.
Tadaaaa!!! :)
answered Feb 2 '17 at 9:51
maycca
1012
add a comment |
up vote
0
down vote
up vote
0
down vote
There is a solution, following the @MatheJuhasz comment:
Select the sheets you would like to print by holding CTRL and
clicking on individual worksheets.Save those as a .pdf (File->Save as ... -> Save at type:PDF)
Print .pdf on both sides, as usually.
Tadaaaa!!! :)
answered Feb 2 '17 at 9:51
maycca
1012
There is a solution, following the @MatheJuhasz comment:
Select the sheets you would like to print by holding CTRL and
clicking on individual worksheets.Save those as a .pdf (File->Save as ... -> Save at type:PDF)
Print .pdf on both sides, as usually.
Tadaaaa!!! :)
answered Feb 2 '17 at 9:51
maycca
1012
answered Feb 2 '17 at 9:51
maycca
1012
answered Feb 2 '17 at 9:51
maycca
1012
answered Feb 2 '17 at 9:51
maycca
1012
1012
add a comment |
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%2f985927%2fprint-two-arbitrary-excel-worksheets-as-one-page-double-sided%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
1
if you can't manage to work it directly from Excel, try to export to pdf first.
– Máté Juhász
Oct 13 '15 at 6:22
Did you try to Ctrl select the two worksheets, open a new document, paste there and print? Else I suppose you can overcame with a little macro.
– Hastur
Oct 13 '15 at 7:40
Ctrl select worksheets (holding Ctrl and clicking on the worksheet tabs) and then copy them to single new worksheet? I tried and did not work. So far, export to PDF seems to be the easiest way.
– Colin Fukai
Oct 16 '15 at 1:33