Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to control the area?
I have a small Excel spreadsheet that I am trying to insert as an object in
a Word document. The spreadsheet is about 10 columns wide x 30 rows high. When I insert this into Word, the object includes more area than I am using for data. Is there any way to limit or control the area included in the object so that just the area of the spreadsheet which actually has data in it is seen? Thanks Allan |
#2
|
|||
|
|||
Do you need it to be a live spreadsheet object in the Word document?
If not, copy a picture of the area of the spreadsheet rather than a full spreadsheet object. (Select the area and Shift+Edit / Copy Picture) Otherwise, hide the excess rows and columns (Format / Column / Hide) Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
#3
|
|||
|
|||
Thanks for your response, but there is no change in the behavior.
I want a live connection. As it is when I insert it into Word document, there is about an inch on the botttom and 2 inches on the right of white space. The result is that I have a spreadsheet sitting inside an island of blank space , and I cannot place text any closer than the boundry of the white space. Thanks Allan "Bill Manville" wrote in message ... Do you need it to be a live spreadsheet object in the Word document? If not, copy a picture of the area of the spreadsheet rather than a full spreadsheet object. (Select the area and Shift+Edit / Copy Picture) Otherwise, hide the excess rows and columns (Format / Column / Hide) Bill Manville MVP - Microsoft Excel, Oxford, England No email replies please - respond to newsgroup |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to insert date using a pop up calendar control in a cell i | Excel Discussion (Misc queries) | |||
I cannot drag a Pivot Table field into the page area | Excel Discussion (Misc queries) | |||
Control Tab from Combo box- format control missing!! | Excel Discussion (Misc queries) | |||
Copying list-box control | Excel Discussion (Misc queries) | |||
Bar Chart Label Sizes | Charts and Charting in Excel |