If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formatting EXCEL spreadsheet onto WORD document
Ok, I know how to paste link an excel spreadsheet onto a word document. The
problem I am having is formatting the spreadsheet. The spreadsheet is set to fit to one (1) page when it prints and that is the look I want on the word document as well. The problem I have is that when I pastelink the excel spreadsheet it is too large. I know I can pull the corners to shrink it, but I am looking for a more efficient way to do it. Thanks in advance for your help. |
#2
|
|||
|
|||
Hi =?Utf-8?B?eW95b3lvb3Jlbw==?=,
Ok, I know how to paste link an excel spreadsheet onto a word document. The problem I am having is formatting the spreadsheet. The spreadsheet is set to fit to one (1) page when it prints and that is the look I want on the word document as well. The problem I have is that when I pastelink the excel spreadsheet it is too large. I know I can pull the corners to shrink it, but I am looking for a more efficient way to do it. Version of Word involved? Have you tried inserting into a Frame (forms toolbar) of the specific size you need? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
#3
|
|||
|
|||
Hi Cindy, thank you for the response! I am using 2003 Word. I have never
used frames before. Will that format the word document so that all the data from the spreadsheet link is within one page? Thanks again for your help, and I really appreciate. "Cindy M -WordMVP-" wrote: Hi =?Utf-8?B?eW95b3lvb3Jlbw==?=, Ok, I know how to paste link an excel spreadsheet onto a word document. The problem I am having is formatting the spreadsheet. The spreadsheet is set to fit to one (1) page when it prints and that is the look I want on the word document as well. The problem I have is that when I pastelink the excel spreadsheet it is too large. I know I can pull the corners to shrink it, but I am looking for a more efficient way to do it. Version of Word involved? Have you tried inserting into a Frame (forms toolbar) of the specific size you need? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
#4
|
|||
|
|||
Hi =?Utf-8?B?eW95b3lvb3Jlbw==?=,
I am using 2003 Word. I have never used frames before. Will that format the word document so that all the data from the spreadsheet link is within one page? The contents of a frame (from the FORMS toolbar, not the Insert menu!) will never break across multiple pages. If what's in the frame grows so much that it fills the frame (with an exact height setting) the additional content will disappear at the bottom of the frame (it's still there, just not visible, except in Normal view). A frame with a variable height setting will grow until it hits the bottom of the page; any additional content will disappear. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
WP Delay Code - Word Equiv | Mike G - Milw, WI | General Discussion | 6 | January 10th, 2005 04:12 PM |
Link Lanscaped Excel spreadsheet w 14 columns into a word document | macropod | General Discussion | 1 | November 4th, 2004 01:23 PM |
Word 2000/2002 - Proper Mail Merge steps for ODBC? | Tony_VBACoder | Mailmerge | 7 | September 2nd, 2004 09:21 PM |
Need a document that pops up a dialog box for user to enter info to merge | Bomber | Mailmerge | 6 | May 12th, 2004 01:45 AM |
Excel 2002 -Formatting Changes not holding in Linked document | dano | Links and Linking | 2 | January 14th, 2004 03:12 PM |