Tables - Word or Excel?

[coriolis]

I'm working at home and am taking a break. I'm working on Word documents which have tables at the end. I was debating whether to do the tables in Word, as part of the document, or in Excel, in which case they'd be separate documents.

I've been using Excel more and more for tables - it just seems a little easier and more natural. Especially if there's much formatting to do with the cells.

I've reached the point that I'll only use Word for simple tables in simple documents where I don't want to deal with separate documents. Anything more elaborate, and I go right to Excel. Of course it's a no brainer, that anything with numbers and formulas go in Excel.

Does anyone else have anything to share?

[PurdueWx80]

I prefer making tables and charts in Excel - you have many more options that way. And just as with images, you can import the Excel tables, once finished, into the Word document wherever you'd like them (either close to the text that refers to them, or at the end of the document)

[Stormsfury]

Excel tables are by far much more manageable than trying these in Word. Also with Excel, the tables will line up properly w/out having to worry about what specific font to use to align tables if you were using Word.

SF

[HurricaneGirl]

I agree. Excel is much easier to work with than Word.

[StormChasr]

For a large spreadsheet, nothing beats Excel. It is the professional tool for multi row-column data entry.

[rockythehusky]

EXCEL

[Stephanie]

Definately Excel! You have the benefit of creating formulas in Excel whereas with Word, you have to type everything (at least that's my experience).

[GalvestonDuck]

Pool

[tomboudreau]

Do them in Lotus 1-2-3 JK. I would do them in Excel as well.

[Persepone]

Generally agree, especially for numerical data.

However, Word Perfect handles tables much better than Microsoft Word. If you are working with text, and want better tables, check out Word Perfect.