Creating a excel table

[maclover]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC

how do I create a table using excel 2008 for mac

 

[CyberTaz]

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

 

[Jim Gordon MVP]

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

 

[CyberTaz]

Hi Jim -

Hi,

I think our correspondent is referring to the new "table" feature of
Excel 2007 for Windows,

Yeah, I figured as much, but I'm just too lazy to ramble on about something
that *may not* be what the OP is looking for or to arbitrarily punch out
half a dozen options & say "pick one that may apply"

which is a prettied-up, cut-down version of the
Mac Excel List feature.

"Prettied-up" I'll buy, but "cut-down" not so much. In what respect do you
see it as being cut down?

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.

Admittedly I haven't done a great deal with this but I've not experienced
what you're referring to... Unless you just mean the removal of the List
frame & other "Visuals". The list itself is certainly not "destroyed" & the
AutoFilter is retained. I've also not had to reapply the list when returning
to '08 after having applied a Table in '07 & Saving As .xlsx - the only
thing I lost - as warned at the time - is the Table Style. Although when
saving directly back in an .xls I did have to click the Calculations button
when reopened in '08, but that's no biggie.

Going the other way, Mac Excel ignores the pretty font formatting of
Windows Excel 2007 Tables, but doesn't wreck the Table.

-Jim

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[Jim Gordon MVP]

Hi Jim -



Yeah, I figured as much, but I'm just too lazy to ramble on about something
that *may not* be what the OP is looking for or to arbitrarily punch out
half a dozen options & say "pick one that may apply"

Given the fuss that Microsoft is making about the "new" Table feature in
XL2007 for Windows, I felt pretty sure that's what maclover was
referring to. Our lover has not chimed in one way or the other to
confirm or squelch my presumption.

"Prettied-up" I'll buy, but "cut-down" not so much. In what respect do you
see it as being cut down?

By "prettied-up" I mean that Windows XL 2007 supports text styles. Mac
Excel does not.

By cut-down I mean that the whole concept of a list is almost lost in
the new Table feature. The table feature doesn't seem to lead you to the
full power of formulas the way the Mac version does.

Admittedly I haven't done a great deal with this but I've not experienced
what you're referring to... Unless you just mean the removal of the List
frame & other "Visuals". The list itself is certainly not "destroyed" & the
AutoFilter is retained. I've also not had to reapply the list when returning
to '08 after having applied a Table in '07 & Saving As .xlsx - the only
thing I lost - as warned at the time - is the Table Style. Although when
saving directly back in an .xls I did have to click the Calculations button
when reopened in '08, but that's no biggie.

Win XL 2007 converts all List objects into a Range objects. It
shouldn't. I should convert List objects onto a Table objects if it is
going to do any converting at all, which it shouldn't. That's a pretty
big bug.

Unfortunately, in VBA Tables they are not the same object as the List
object, which is kinda dumb, because they are, or at least ought to be.
To me, the Table object was a quick-n-dirty shortcut so Win Xl didn't
have to do a proper job of porting the List object, and could implement
the new text styles for show.

=Jim