force line breaks within a cell

[Marguerite]

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

I used to know how to force a line break in a cell, but I can't figure it out in this new version and the help menu is no help.

Does anyone know how to do this? Thanks!

 

[Bob Greenblatt]

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

I used to know how to force a line break in a cell, but I can't figure it out
in this new version and the help menu is no help.

Does anyone know how to do this? Thanks!

Control-option-Return

 

[CyberTaz]

Bob G answered your question, but as for Help being of no Help, this is just
a small portion of what you get with a search for: Excel keyboard shortcuts;

________________________________________________________________
About keyboard shortcuts
You can quickly perform tasks by using keyboard shortcuts — one or more keys
that you press on the keyboard to complete a task. For example, pressing ⌘+P
opens the Print dialog box.
Notes
Keyboard shortcut descriptions refer to the U.S. keyboard layout. Keys on
other keyboard layouts might not correspond to the keys on a U.S. keyboard.
Keyboard shortcuts for laptop computers might also differ.
The settings in some versions of the Macintosh operating system and some
utility applications might conflict with keyboard shortcuts and function key
operations in Office. For more information, see My keyboard shortcut doesn't
work. For information about changing the key assignment of a keyboard
shortcut, see Mac Help for your version of the Macintosh operating system or
see your utility application.
You cannot search within this page when using the Office Help viewer.
However, you can open Excel keyboard shortcuts on the Microsoft Web site in
your Web browser. To search this page in a Web browser, click Show All at
the top of the page, and then use your browser's Find function.

Function keys

Moving and scrolling in a sheet or workbook

Previewing and printing

Entering data on a sheet
To
Press
Complete a cell entry and move down in the selection
RETURN
Start a new line in the same cell
CONTROL+OPTION+RETURN
______________________________________________________

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

 

[Jeff Chapman]

Bob G answered your question, but as for Help being of no Help, this is just

a small portion of what you get with a search for: Excel keyboard shortcuts;

Indeed, the answer is in the help contents, both offline and online.
I'm wondering, though, if the person who asked the question got confused
about how to use the Help function. With Leopard and Snow Leopard,
there is a little Spotlight-like search box that appears when you
click on the Help menu text. However, this doesn't actually search
the Excel application help content. Rather, it searches the Excel
menus for a match, and then it searches the Mac OS X general help
content. Kind of strange behavior and certainly not what we'd expect
for an application-specific help function.

Anyway, this might explain why the person asking the question
was disillusioned with the Excel help content - they may not
have gone into the Excel help itself, but might have
based their judgment on what the results of that Spotlight-like
search box brought them...

???

Jeff

 

[CyberTaz]

Indeed, the answer is in the help contents, both offline and online.
I'm wondering, though, if the person who asked the question got confused
about how to use the Help function. With Leopard and Snow Leopard,
there is a little Spotlight-like search box that appears when you
click on the Help menu text. However, this doesn't actually search
the Excel application help content. Rather, it searches the Excel
menus for a match, and then it searches the Mac OS X general help
content. Kind of strange behavior and certainly not what we'd expect
for an application-specific help function.

Anyway, this might explain why the person asking the question
was disillusioned with the Excel help content - they may not
have gone into the Excel help itself, but might have
based their judgment on what the results of that Spotlight-like
search box brought them...

???

Jeff

Yeah, that's one of Apple's little gems. IMHO, one of the most undesirable
quirks of the OS X guidelines. Apple's response is "Well, [app name] Help is
listed right there, all the user need do is select it..." They refuse to
understand that most users are not looking for Mac Help *at all* when they
access the Help menu from within the program they're currently using.

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