Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Incerting Excel spreadsheet into a word document
I am incerting excel spreadsheets into a word document using paste special
and linking the document so word updates as I makes changes to excel. No problems there. The only thing that I can't figure out how to do is center the spreadheet on the PAGE irreguardless of where the word margins are. Right now I can only move it to the left margin and can't get it to move any more left, but it looks uncentered in the document because of its size. if I make it smaller so it seems more centered, the numbers get too small. Any help is appreciated. Thanks, Jim |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Incerting Excel spreadsheet into a word document
It depends on how you're inserting it.
Let's assume you're inserting it as an Excel Worksheet object. Select it, and choose Format - Object. In the Layout tab, choose something other than In Line with Text, such as Tight. Set Horizontal alignment to Center, and click Advanced. In the Picture Position tab under Horizonal Alignment, Alignment should be set to Centered. Set relative to to Page. Note that you might get a notice that it's too close to the edge of the page when you try to print or choose Print Preview, in which case you'll need to make adjustments... which it shoulds like you're used to doing. -- Herb Tyson MS MVP http://www.herbtyson.com Please respond in the newsgroups so everyone can follow along. "Jim" wrote in message ... I am incerting excel spreadsheets into a word document using paste special and linking the document so word updates as I makes changes to excel. No problems there. The only thing that I can't figure out how to do is center the spreadheet on the PAGE irreguardless of where the word margins are. Right now I can only move it to the left margin and can't get it to move any more left, but it looks uncentered in the document because of its size. if I make it smaller so it seems more centered, the numbers get too small. Any help is appreciated. Thanks, Jim |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Incerting Excel spreadsheet into a word document
perfect, thank you!
"Herb Tyson [MVP]" wrote: It depends on how you're inserting it. Let's assume you're inserting it as an Excel Worksheet object. Select it, and choose Format - Object. In the Layout tab, choose something other than In Line with Text, such as Tight. Set Horizontal alignment to Center, and click Advanced. In the Picture Position tab under Horizonal Alignment, Alignment should be set to Centered. Set relative to to Page. Note that you might get a notice that it's too close to the edge of the page when you try to print or choose Print Preview, in which case you'll need to make adjustments... which it shoulds like you're used to doing. -- Herb Tyson MS MVP http://www.herbtyson.com Please respond in the newsgroups so everyone can follow along. "Jim" wrote in message ... I am incerting excel spreadsheets into a word document using paste special and linking the document so word updates as I makes changes to excel. No problems there. The only thing that I can't figure out how to do is center the spreadheet on the PAGE irreguardless of where the word margins are. Right now I can only move it to the left margin and can't get it to move any more left, but it looks uncentered in the document because of its size. if I make it smaller so it seems more centered, the numbers get too small. Any help is appreciated. Thanks, Jim |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting WordPerfect 12 files to Word 2003 | New Users | |||
Reveal codes in a word document | Microsoft Word Help | |||
How to put graphics on envelopes? | Microsoft Word Help | |||
Excel Spreadsheet within a Word Document | Microsoft Word Help | |||
How do I create & merge specific data base & master documents? | New Users |