User Name
Password
AppleNova Forums » Genius Bar »

How to Create Excel Table in Word 2004?


Register Members List Calendar Search FAQ Posting Guidelines
How to Create Excel Table in Word 2004?
Thread Tools
gbh
Member
 
Join Date: Jun 2007
 
2007-06-20, 21:21

I am used to using Word 2007 where you can create a spreadsheet directly in word without having to do so outside and insert it. It is very easy, seamless and immediately. However, it looks like in word 2004 it is much more involved. Is there any simple way I can create spreadsheets directly in my word 2004 document like I do in the windows version? The way it appears you have to do it- create the spreadsheet then insert is much more time consuming. I need any help I can get.
  quote
Banana
is the next Chiquita
 
Join Date: Feb 2005
 
2007-06-21, 00:06

Isn't that good enough for you? (I'm not sure if that was what you were talking or not)
  quote
_Ω_
Veteran Member
 
Join Date: May 2004
Send a message via AIM to _Ω_  
2007-06-21, 00:38

A table does not have the same flexibility as an embedded spreadsheet. You could just open a spreadsheet and then select a few cells and cut and then paste special into the word document. You should have the option to embed the spreadsheet into the document.

Then all you need to do is double click on the embedded spreadsheet and you should be taken into the Excel environment.

Hopefully all this makes sense.

=)

"If God is our Father, then Satan must be our cousin."
  quote
Wyatt
On twitter: @bwyatt
 
Join Date: Mar 2005
Location: Near Indianapolis
 
2007-06-21, 06:16

Quote:
Originally Posted by _Ω_ View Post
A table does not have the same flexibility as an embedded spreadsheet. You could just open a spreadsheet and then select a few cells and cut and then paste special into the word document. You should have the option to embed the spreadsheet into the document.
That's what I do, too. Word's spreadsheet editor is pretty much ass, so I stick with Excel for creating them and "paste special" (does that sound stupid to anyone else?) into Word.

Twitter: bwyatt | Minecraft: bwyatt_IN
  quote
gbh
Member
 
Join Date: Jun 2007
 
2007-06-21, 07:00

Thanks for the ideas. I have to use lots of spreadsheets throughout documents to do elaborate calculations and why tables are no good.

What you describe, though, is what I want to avoid- cutting and pasting, etc. Contrast this with Word 2003 or 2007 for windows where there is a button on the word toolbar, I click it and its immediately inserts a blank spreadsheet IN the document and when I modify it it is in the document and stays with it. I resize it, modify it, etc., in the document, which is much easier, much faster, etc.

However, with Word 2004, I have to create a spreadsheet outside a document and save it and then insert it, or copy it and paste it. These extra steps may not sound like much, but I challenge anyone to do one fourth as fast as I can with Word 2007 or 2003.

I want to use and move to the MAC and am trying to figure out if there is a way to do this similarly. If not, I may just have to park the MacBook Pro until the new office 2008 comes out in the fall and hope it has a similar capability.

I also tried NeoOffice and OpenOffice, but it looks like they have the same limitations. Any other ideas?

The other option I have is to use Parallels and Office 2007. I have done that and it works fine, but it involves a little hassle.

Any ideas appreciated as I want to move permanently to the Mac.
  quote
Banana
is the next Chiquita
 
Join Date: Feb 2005
 
2007-06-21, 10:05

Okay, now that I understand the question better, you can do this without having to firing up the Excel.

Insert -> Object -> Mircosoft Excel Worksheet.

But if you want a button to click on,

Edit -> Toolbars -> Customize

In dialog, click "Command" tabs.

Scroll down to InsertExcelTable and select that.

You then will get this button in your Normal toolabr (assuming that is what you have selected. If you would prefer another toolbar, there's a drop down list on the bottom of the list that lets you select which toolbar you want the button to go.)



HTH.
  quote
gbh
Member
 
Join Date: Jun 2007
 
2007-06-21, 10:34

That is a nice trick and thanks.

However, it still does not solve the problem. It still means that when I click on it in the document to work on the spreadsheet it opens up an external document instead of working in the document. If you try to re-resize it you cannot go beyond five columns and there is a severe limitation on row numbers. None of this is present in the windows versions. You just click on the spreadsheet in the document itself and drag the handles to make it as big or small as you want it.
  quote
gbh
Member
 
Join Date: Jun 2007
 
2007-06-21, 10:39

Plus, I forgot to add that you do not have to save an external spreadsheet. By saving the document it is saved.
  quote
Posting Rules Navigation
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Post Reply

Forum Jump
Thread Tools
Similar Threads
Thread Thread Starter Forum Replies Last Post
Word 2004 Print to PDF Problems solstace Genius Bar 1 2007-06-20 07:10
Problems creating pdf files from Excel 2004 fwtong Genius Bar 5 2006-06-19 22:35
Darwine Requirements doublem9876 Third-Party Products 2 2006-02-26 10:58
Word 2004 Inserting Footnotes saturn Genius Bar 8 2005-05-15 22:40
Office 2004, OpenOffice, iWork - Best Word Processor for Mac? Nico_from_Paris Third-Party Products 37 2005-03-08 03:02


« Previous Thread | Next Thread »

All times are GMT -5. The time now is 06:34.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright ©2004 - 2018, AppleNova