Can I insert a large Excel sheet into Word so that it shrinks to fit the page?
I don't want to manually tweak font and table dimensions. Ideally the whole thing should scale to fit the page.
I'm using the 2007 version for both.
microsoft-excel microsoft-word microsoft-excel-2007 microsoft-word-2007
asked Jan 20 at 4:42
zipzapboingzipzapboing
134
add a comment |
I don't want to manually tweak font and table dimensions. Ideally the whole thing should scale to fit the page.
I'm using the 2007 version for both.
microsoft-excel microsoft-word microsoft-excel-2007 microsoft-word-2007
asked Jan 20 at 4:42
zipzapboingzipzapboing
134
What shrinking exactly mean for you? Decrease font size? Paste as picture and zoom? Optimize column width? How "large" is it?
– Máté Juhász
Jan 20 at 5:53
1
Ideally the entire content would be scaled down as a picture would, without the limitation of it being pixelated if someone zooms in or no longer editable in case we want to add notes during a meeting. It's just large enough that it will fit on a horizontal layout with zero margins but I'd prefer not to do that.
– zipzapboing
Jan 20 at 5:55
Seems that setting bigger page size in Word would be the solution so you can keep text and don't need to waste time with decreasing font size. I'd you want to print, just save as pdf first than you can scale down easily.
– Máté Juhász
Jan 20 at 6:20
What stopped you? Did you try? At most if it can't be scaled down beyond Word's capabilities, you will get horizontal/ vertical scroll bars in the excel area.
– VSRawat
Feb 6 at 9:25
1
Can you screenshot an example of what that would look like? Is there some special paste option I should be using? Currently if I select the cells and copy+paste them into Word, it either overflows the document or gets deformed to fit the page.
– zipzapboing
Feb 6 at 12:48
add a comment |
I don't want to manually tweak font and table dimensions. Ideally the whole thing should scale to fit the page.
I'm using the 2007 version for both.
microsoft-excel microsoft-word microsoft-excel-2007 microsoft-word-2007
asked Jan 20 at 4:42
zipzapboingzipzapboing
134
I don't want to manually tweak font and table dimensions. Ideally the whole thing should scale to fit the page.
I'm using the 2007 version for both.
microsoft-excel microsoft-word microsoft-excel-2007 microsoft-word-2007
microsoft-excel microsoft-word microsoft-excel-2007 microsoft-word-2007
asked Jan 20 at 4:42
zipzapboingzipzapboing
134
asked Jan 20 at 4:42
zipzapboingzipzapboing
134
asked Jan 20 at 4:42
zipzapboingzipzapboing
134
asked Jan 20 at 4:42
zipzapboingzipzapboing
134
asked Jan 20 at 4:42
zipzapboingzipzapboing
134
134
What shrinking exactly mean for you? Decrease font size? Paste as picture and zoom? Optimize column width? How "large" is it?
– Máté Juhász
Jan 20 at 5:53
1
Ideally the entire content would be scaled down as a picture would, without the limitation of it being pixelated if someone zooms in or no longer editable in case we want to add notes during a meeting. It's just large enough that it will fit on a horizontal layout with zero margins but I'd prefer not to do that.
– zipzapboing
Jan 20 at 5:55
Seems that setting bigger page size in Word would be the solution so you can keep text and don't need to waste time with decreasing font size. I'd you want to print, just save as pdf first than you can scale down easily.
– Máté Juhász
Jan 20 at 6:20
What stopped you? Did you try? At most if it can't be scaled down beyond Word's capabilities, you will get horizontal/ vertical scroll bars in the excel area.
– VSRawat
Feb 6 at 9:25
1
Can you screenshot an example of what that would look like? Is there some special paste option I should be using? Currently if I select the cells and copy+paste them into Word, it either overflows the document or gets deformed to fit the page.
– zipzapboing
Feb 6 at 12:48
add a comment |
What shrinking exactly mean for you? Decrease font size? Paste as picture and zoom? Optimize column width? How "large" is it?
– Máté Juhász
Jan 20 at 5:53
1
Ideally the entire content would be scaled down as a picture would, without the limitation of it being pixelated if someone zooms in or no longer editable in case we want to add notes during a meeting. It's just large enough that it will fit on a horizontal layout with zero margins but I'd prefer not to do that.
– zipzapboing
Jan 20 at 5:55
Seems that setting bigger page size in Word would be the solution so you can keep text and don't need to waste time with decreasing font size. I'd you want to print, just save as pdf first than you can scale down easily.
– Máté Juhász
Jan 20 at 6:20
What stopped you? Did you try? At most if it can't be scaled down beyond Word's capabilities, you will get horizontal/ vertical scroll bars in the excel area.
– VSRawat
Feb 6 at 9:25
1
Can you screenshot an example of what that would look like? Is there some special paste option I should be using? Currently if I select the cells and copy+paste them into Word, it either overflows the document or gets deformed to fit the page.
– zipzapboing
Feb 6 at 12:48
What shrinking exactly mean for you? Decrease font size? Paste as picture and zoom? Optimize column width? How "large" is it?
– Máté Juhász
Jan 20 at 5:53
What shrinking exactly mean for you? Decrease font size? Paste as picture and zoom? Optimize column width? How "large" is it?
– Máté Juhász
Jan 20 at 5:53
1
1
Ideally the entire content would be scaled down as a picture would, without the limitation of it being pixelated if someone zooms in or no longer editable in case we want to add notes during a meeting. It's just large enough that it will fit on a horizontal layout with zero margins but I'd prefer not to do that.
– zipzapboing
Jan 20 at 5:55
Ideally the entire content would be scaled down as a picture would, without the limitation of it being pixelated if someone zooms in or no longer editable in case we want to add notes during a meeting. It's just large enough that it will fit on a horizontal layout with zero margins but I'd prefer not to do that.
– zipzapboing
Jan 20 at 5:55
Seems that setting bigger page size in Word would be the solution so you can keep text and don't need to waste time with decreasing font size. I'd you want to print, just save as pdf first than you can scale down easily.
– Máté Juhász
Jan 20 at 6:20
Seems that setting bigger page size in Word would be the solution so you can keep text and don't need to waste time with decreasing font size. I'd you want to print, just save as pdf first than you can scale down easily.
– Máté Juhász
Jan 20 at 6:20
What stopped you? Did you try? At most if it can't be scaled down beyond Word's capabilities, you will get horizontal/ vertical scroll bars in the excel area.
– VSRawat
Feb 6 at 9:25
What stopped you? Did you try? At most if it can't be scaled down beyond Word's capabilities, you will get horizontal/ vertical scroll bars in the excel area.
– VSRawat
Feb 6 at 9:25
1
1
Can you screenshot an example of what that would look like? Is there some special paste option I should be using? Currently if I select the cells and copy+paste them into Word, it either overflows the document or gets deformed to fit the page.
– zipzapboing
Feb 6 at 12:48
Can you screenshot an example of what that would look like? Is there some special paste option I should be using? Currently if I select the cells and copy+paste them into Word, it either overflows the document or gets deformed to fit the page.
– zipzapboing
Feb 6 at 12:48
add a comment |
2 Answers
2
active
oldest
votes
The above shows an Excel File inserted within a Word file, (Insert - Text - Object - Create from File - browse from your HDD)
If you single click over the block, 8 anchor points will appear in the boundary and moving them will change the size of image.
However if you double click on the block, entire Excel file will open and there will be 8 anchor points, by moving which the part of file visible within word changes. It has to be column-width wise and row-height wise, you can display or hide part row/ part column.
Then double click outside the block or press escape and the block will remain in word in its new size.
answered yesterday
VSRawatVSRawat
14712
add a comment |
Try highlighting the cells containing the desired rows and columns and going to Word and right click Paste Special.
You may be able to default the Word Document to the Font you want.
This is not a perfect solution as you just want to paste the cells into word and have them look right.
From my experience you are better off working to make your Excel Document Printable by setting the Print Area etc and forget about using Word for more than few columns.
answered Jan 20 at 5:10
user711393user711393
111
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%2f1396231%2fcan-i-insert-a-large-excel-sheet-into-word-so-that-it-shrinks-to-fit-the-page%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
The above shows an Excel File inserted within a Word file, (Insert - Text - Object - Create from File - browse from your HDD)
If you single click over the block, 8 anchor points will appear in the boundary and moving them will change the size of image.
However if you double click on the block, entire Excel file will open and there will be 8 anchor points, by moving which the part of file visible within word changes. It has to be column-width wise and row-height wise, you can display or hide part row/ part column.
Then double click outside the block or press escape and the block will remain in word in its new size.
answered yesterday
VSRawatVSRawat
14712
add a comment |
The above shows an Excel File inserted within a Word file, (Insert - Text - Object - Create from File - browse from your HDD)
If you single click over the block, 8 anchor points will appear in the boundary and moving them will change the size of image.
However if you double click on the block, entire Excel file will open and there will be 8 anchor points, by moving which the part of file visible within word changes. It has to be column-width wise and row-height wise, you can display or hide part row/ part column.
Then double click outside the block or press escape and the block will remain in word in its new size.
answered yesterday
VSRawatVSRawat
14712
add a comment |
The above shows an Excel File inserted within a Word file, (Insert - Text - Object - Create from File - browse from your HDD)
If you single click over the block, 8 anchor points will appear in the boundary and moving them will change the size of image.
However if you double click on the block, entire Excel file will open and there will be 8 anchor points, by moving which the part of file visible within word changes. It has to be column-width wise and row-height wise, you can display or hide part row/ part column.
Then double click outside the block or press escape and the block will remain in word in its new size.
answered yesterday
VSRawatVSRawat
14712
The above shows an Excel File inserted within a Word file, (Insert - Text - Object - Create from File - browse from your HDD)
If you single click over the block, 8 anchor points will appear in the boundary and moving them will change the size of image.
However if you double click on the block, entire Excel file will open and there will be 8 anchor points, by moving which the part of file visible within word changes. It has to be column-width wise and row-height wise, you can display or hide part row/ part column.
Then double click outside the block or press escape and the block will remain in word in its new size.
answered yesterday
VSRawatVSRawat
14712
answered yesterday
VSRawatVSRawat
14712
answered yesterday
VSRawatVSRawat
14712
answered yesterday
VSRawatVSRawat
14712
14712
add a comment |
add a comment |
Try highlighting the cells containing the desired rows and columns and going to Word and right click Paste Special.
You may be able to default the Word Document to the Font you want.
This is not a perfect solution as you just want to paste the cells into word and have them look right.
From my experience you are better off working to make your Excel Document Printable by setting the Print Area etc and forget about using Word for more than few columns.
answered Jan 20 at 5:10
user711393user711393
111
add a comment |
Try highlighting the cells containing the desired rows and columns and going to Word and right click Paste Special.
You may be able to default the Word Document to the Font you want.
This is not a perfect solution as you just want to paste the cells into word and have them look right.
From my experience you are better off working to make your Excel Document Printable by setting the Print Area etc and forget about using Word for more than few columns.
answered Jan 20 at 5:10
user711393user711393
111
add a comment |
Try highlighting the cells containing the desired rows and columns and going to Word and right click Paste Special.
You may be able to default the Word Document to the Font you want.
This is not a perfect solution as you just want to paste the cells into word and have them look right.
From my experience you are better off working to make your Excel Document Printable by setting the Print Area etc and forget about using Word for more than few columns.
answered Jan 20 at 5:10
user711393user711393
111
Try highlighting the cells containing the desired rows and columns and going to Word and right click Paste Special.
You may be able to default the Word Document to the Font you want.
This is not a perfect solution as you just want to paste the cells into word and have them look right.
From my experience you are better off working to make your Excel Document Printable by setting the Print Area etc and forget about using Word for more than few columns.
answered Jan 20 at 5:10
user711393user711393
111
answered Jan 20 at 5:10
user711393user711393
111
answered Jan 20 at 5:10
user711393user711393
111
answered Jan 20 at 5:10
user711393user711393
111
111
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.
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%2f1396231%2fcan-i-insert-a-large-excel-sheet-into-word-so-that-it-shrinks-to-fit-the-page%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
What shrinking exactly mean for you? Decrease font size? Paste as picture and zoom? Optimize column width? How "large" is it?
– Máté Juhász
Jan 20 at 5:53
1
Ideally the entire content would be scaled down as a picture would, without the limitation of it being pixelated if someone zooms in or no longer editable in case we want to add notes during a meeting. It's just large enough that it will fit on a horizontal layout with zero margins but I'd prefer not to do that.
– zipzapboing
Jan 20 at 5:55
Seems that setting bigger page size in Word would be the solution so you can keep text and don't need to waste time with decreasing font size. I'd you want to print, just save as pdf first than you can scale down easily.
– Máté Juhász
Jan 20 at 6:20
What stopped you? Did you try? At most if it can't be scaled down beyond Word's capabilities, you will get horizontal/ vertical scroll bars in the excel area.
– VSRawat
Feb 6 at 9:25
1
Can you screenshot an example of what that would look like? Is there some special paste option I should be using? Currently if I select the cells and copy+paste them into Word, it either overflows the document or gets deformed to fit the page.
– zipzapboing
Feb 6 at 12:48