When you click the link, Excel will run and will open your Excel workbook. Click, or ctrl-click to link? By default, you need to do ctrl-click to follow a hyperlink from a Word document. In this article, I’ll show you a couple of ways you can sort text, lists and tables in Word. Note that if you already have data in Excel, you can easily insert an Excel spreadsheet into your Word document. Sorting Lists in Word. There are three types of lists you can sort in Word.

What if we say, we can automate your accounting? Toby mac ' i just need u.

I have embedded excel spreadsheets in a word document. I want to edit the spreadsheet to insert an extra row. When I do this (by double clicking to bring up excel, inserting the row and closing) - the view of the spead sheet in word does not expand to show the extra row. Any attempt to expand the embedded object using the object frame just scales the existing view. The embedded spreadsheet was inserted by selecting and copying in excel and then using 'past special' in word ('paste' checkbox rather then 'paste link') and pasting it as an 'MS Excel Worksheet Object'. The effect is repeatable in the new document.

In Office 97, this can be done since the editing is in place and you can expand the viewed area. If I instead insert the object linked to the original document rather then embedded, then I can edit the field code to change the displayed area - but for embedded objects this information does not seem to be accessible (the field code is just 'EMBED Excel.Sheet.8.' Other then removing the spreadsheets to an external workbook and linking back to them, is there any way around this. The version stuff - Office X for Mac SR1, MacOSX Version 10.2.3 Thanks John McGhie [MVP] 13/2/2003, 3:43 น.

Hi Terry: I have not got Excel here at the moment to try, so do this for me: 1) Use Format>Object>Size to set the Size to 100 per cent. Does that fix it? 2) Double-click the object, add and remove a space from one of the cells, then close it. Did that fix it? 3) The object is actually encased in a Text Box. There are two frames: one for the object, the other for the text box.

If you click, then click again, slowly, the selection rectangle will slightly change its appearance. When that happens, try dragging again. It's damned difficult to get this to work: the first click selects the object, the second click selects the frame. In Word X, it's nearly impossible to see the difference. Hope this helps This responds to article, from 'T Farrell' on 11/2/03 4:29 PM: -- All Spam and attachments blocked by Microsoft Entourage for Mac OS X.

Please post replies to the newsgroup to maintain the thread. John McGhie, Microsoft MVP: Word for Macintosh and Word for Windows Consultant Technical Writer +61 4 1209 1410; Sydney, Australia: GMT + 10 hrs T Farrell 16/2/2003, 19:16 น. 'John McGhie [MVP]' wrote in message news. > Hi Terry: > > I have not got Excel here at the moment to try, so do this for me: > > 1) Use Format>Object>Size to set the Size to 100 per cent. Does that fix > it?

No - it was already at 100%. It appears that any change to the size here just scales the object. > > 2) Double-click the object, add and remove a space from one of the cells, > then close it. Did that fix it? > > 3) The object is actually encased in a Text Box. There are two frames: one > for the object, the other for the text box. > > If you click, then click again, slowly, the selection rectangle will > slightly change its appearance.

When that happens, try dragging again. > It's damned difficult to get this to work: the first click selects the > object, the second click selects the frame. In Word X, it's nearly > impossible to see the difference. Afraid not - I don't see the change you mention. When clicking slowly the second time it seems to move into a 'drag' mode. The 'Picture' tool bar - which I think should change to 'Format Text Box' mode if I end up in a text box, does not change. > > Hope this helps Thanks for the attempt.