Hello mrbill -
I don't question that you may have seen bulleted/numbered content in an
Excel worksheet, but - AFAIK - no version of the program has ever had a
Bullets & Numbering feature. My memory is admittedly not the best but I've
been using the program on both Mac & PC since it was introduced some 20
years ago
and just confirmed in both 2003 & 2007.
Here's what Excel 2003 Help has to say on the subject:
============================================================
Insert bullets in a worksheet
Unlike Microsoft Word, Microsoft Excel does not provide a button to create a
bulleted list in text. To add bullets to worksheet text, you need to insert
a symbol.
Do one of the following:
To add a bullet to an empty cell on the worksheet, click the cell.
You may want to do this if your bullets will be in a separate column from
the list items.
To add a bullet to a cell that contains text, double-click the cell, and
then place the insertion point where you want the bullet to appear.
Do this when you want the bullet and list item to appear in the same cell.
On the Insert menu, click Symbol.
On the Symbols tab, in the Font box, click the font that you want to use.
Use the scroll bar on the right side to find the symbol that you want to
insert.
Tip Different fonts provide different symbols. If your font does not
provide the bullet or other symbol that you want, try a selecting a font
like Wingdings.
Click the bullet or symbol that you want, click Insert, and then click
Close.
To add more bullets, you can copy and paste the first one that you inserted.
Or, if the bullet is in its own cell, you can drag the fill handle (fill
handle: The small black square in the lower-right corner of the selection.
When you point to the fill handle, the pointer changes to a black cross.) to
repeat the symbol in adjacent cells.
============================================================
Re the ability to create a line break - Yes, it can certainly be done. It's
just that you're not only using a different version of the program but it's
also running on different operating system. Try either:
Command+Option (Alt)+return, or
Control+Option+return
A couple of others you may be in search of as well:
Toggle Absolute References: Command+T
Edit directly in a cell: Control+U
You might want to have a look in Excel Help on the topic: Excel Keyboard
Shortcuts to find out what some of the others were *before* they ported
Excel to the Windows OS & started changing things
If you have any other questions on the differences that have evolved over
the years someone here will be more than glad to help out.
HTH |:>)
Bob Jones
[MVP] Office:Mac
