CyberTaz said:
An Excel worksheet *is* a table - quite a large one. It's just a matter of
typing your content into the cells one-by-one. Put captions (field names) in
any row of your choice then list your records beginning on the row below.
<
http://www.microsoft.com/mac/help.mspx?target=5322da0a-e1a3-4890-8443-213e8
ccb58fa1033&clr=99-1-0&parentid=0fa4030a-1bf8-46cd-9729-ee5cf80dff561033&ep=
7&CTT=Category&MODE=pv&locale=en-US&usid=850ade12-12cc-49e8-9c02-60e9df1cb26
c>
If you need something more you'll have to be more specific about what it is.
Regards |:>)
Bob Jones
[MVP] Office:Mac
Hi,
I think our correspondent is referring to the new "table" feature of
Excel 2007 for Windows, which is a prettied-up, cut-down version of the
Mac Excel List feature.
In Mac Excel the List feature is still called the List feature and does
not use the confusing term Table. There are several ways to create Lists
*On the Elements Gallery, click the Sheets tab, and then click the Lists
button. There are several pre-fab lists ready to use.
*On the Elements Gallery, click the Sheets tab, and the click the Blank
Sheets tab. The middle one is List sheet.
*On the File menu choose Project Gallery. Use the List Wizard to create
a new list.
*On the File menu choose Project Gallery. In the left panel click the
Ledger Sheets triangle. All the ledger sheets are lists.
*Ledger sheets in the Elements Gallery are the same as the ones in the
Project Gallery.
*From the Insert menu choose List. You can create a List as an object on
a sheet.
Excel 2007 screws up lists royally. If you use Excel 2007 on Windows to
open a workbook that has a List object, Win Excel destroys the List. If
you get your workbook back after it went to Excel 2007 you will have to
use Insert List and turn the List object on in order to use the List
again. Fortunately, Win Excel won't remove the formulas or wreck the
calculations.
Going the other way, Mac Excel ignores the pretty font formatting of
Windows Excel 2007 Tables, but doesn't wreck the Table.
-Jim