I’ve been trying to insert some tables created in Excel into a Word document. I’ve discovered the hard way that simply pasting them leads to all sorts of weird problems, so the only option is to insert them as Excel worksheets.
The problem is that Word doesn’t seem to want to let me use the bottom/right hand side of the page (landscape format). I can’t see the three furthest columns of the worksheet on the Word page. I can insert the worksheet without a problem, but I can’t extend it into the right hand side of the page at all. I can type in that area, or use it for text boxes, pictures etc, but for some reason it is a dead space for the worksheet. I tried minimising the page margins, but now I have 10cm of space that still can’t be used to resize the worksheet.
If I try to resize the worksheet when it’s open by revealing more columns it allows me to drag the sheet out, then as soon as I let go it snaps back to size. If I reduce the font size of the worksheet I get more white spaces on the page, but no extra columns. If I resize the worksheet without opening it the font distorts but I still can’t show any more columns.
The really annoying part is that if I insert the worksheet in text box I can resize the text box to full page width, but the worksheet only appears in part of the text box, still with the right hand columns missing.
So what am I missing here? I assume it’s something really obvious because this “quirk” serves no purpose. It seems to exist purely to frustrate. And if that is its purpose then it’s working
You need to edit the worksheet by right-clicking and choosing Edit - do not choose Open. Are you doing it that way?
Don’t resize the object in Word - that’s why the font is distorting; all you are resizing is the picture of the Excel worksheet - not the worksheet itself.
Yep. I’ve tried every way, from double clicking to right-clicking and choosing edit to right-clicking and choosing open. Same result.
Nope. It’s not resizing the picture of the Excel worksheet that’s causing the problems. The worksheet istself can be resized in Excel, but not in Word. I can only see as far as Column O within the word document. If I right click and edit I can drag the Excel frame to encompass more cells, but as soon as i let go it snaps back to “O”. I can move within the Excel frame so I can see, for example, columns B through P, but that doesn’t change the number of columns visible.
Hmmm. I am doing what you are doing and it’s working for me.
Are you sure that having a worksheet with columns all the way to O is still small enough to fit on one page of the word doc? I made a test with many more columns than will fit on an 11" wide page, and I can right-click and edit the Excel, or add more columns, but when I go back to Word only the part that will fit on the Word doc is visible in Page Layout. I can see the whole thing if I view the Word doc in Normal instead of Page Layout.
That’s the annoying part, it’s acting like it is too big, but it clearly isn’t. I have over 10cm of space to the right of the worksheet in which I can type, attack pictures etc. so the space is more than sufficient to fit. It just don’t want to.
I’m sure I’m overlooking something really obvious here and am due a :smack: moment when I figure out what it is.
Thanks for the offer. In fact thanks for your help.
I’m proficient enough with office to know that this thing is behaving like it’s oversize. The problem is that I also know that it isn’t because I can type or insert pictures to the right of the worksheet. That’s the frustrating part. I don’t what to have to reduce down to a 6 point font and have a table that only occupies 3/4 of the printable page area.
If you’re agreeable I’ll email you the page I’m having trouble with so you can see what I mean. (Pleeeasse)
I am not sure but I can get my table to get the same result that you are having - having a bunch of space on the right - and it’s because of resizing it incorrectly. Not sure if that’s what your issue is, though. You might have some weird bug. Feel free to send the doc and I’ll take a look.
Try this. Right-click the table and choose “Format Object”. Under the “Size” tab, play with the height and width with the “Lock Aspect Ratio” and Relative to Original" check boxes checked. I found if I sized the table at a (for example) 75% of original, it shrunk the whole table so that it would fit. And I could also drag more columns into the page. It’s also probably necessary to check the “Picture” tab and align the picture either in front of or behind text.
I know this is GQ and not GD. Sorry. Shinola like this is among my pet peeves with Microsoft. No helpful advice, but perhaps the knowlage that your troubles are in no way associated with your intelligence, and that multitudes feel you pain will make you feel better and less alone.