the trailboss abuses his CodeRanch power for his other stuff (power corrupts. absolute power corrupts absolutely is kinda neat!)
permaculture light bulbs permaculture electric heat permaculture cast iron permaculture wood burning stove permaculture solar food dehydrators
The moose likes Meaningless Drivel and the fly likes AOP: Any Excel experts out there? (soft return in a cell?) Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Other » Meaningless Drivel
Bookmark "AOP: Any Excel experts out there? (soft return in a cell?)" Watch "AOP: Any Excel experts out there? (soft return in a cell?)" New topic
Author

AOP: Any Excel experts out there? (soft return in a cell?)

Bert Bates
author
Sheriff

Joined: Oct 14, 2002
Posts: 8883
    
    5
I use a Mac.

In Excel (the spreadsheet), I know how to set word-wrap on a cell so that I can type a paragraph into the cell. What'd I like to do is some really crude formatting within a cell - it would be awesome if I could just figure out how to do - what I'm calling - a soft return. That would let me do, for instance, a crude bulleted list within a cell.

Anyone know how or if I can do that?

Thanks!

Spot false dilemmas now, ask me how!
(If you're not on the edge, you're taking up too much room.)
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 61648
    
  67

Of no help whatsoever:

Question: How can you tell a software manager from a software engineer?

Answer: The manager uses Excel as his compiler.

(OK, it's a slow day.)


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Bert Bates
author
Sheriff

Joined: Oct 14, 2002
Posts: 8883
    
    5
har, de, har, har...

But, if I could take only 5 pieces of software with me to the fabled desert island, a good spreadsheet tool would be one of them... hey, that could be a good MD thread!
Matthew Brown
Bartender

Joined: Apr 06, 2010
Posts: 4464
    
    8

On Windows I think it's Alt-Enter. Haven't used a Mac for about 15 years, so can't remember the equivalent.
Bert Bates
author
Sheriff

Joined: Oct 14, 2002
Posts: 8883
    
    5
of course!

doh!

why didn't I think of: apple, option, return...

(works like a champ)
 
wood burning stoves
 
subject: AOP: Any Excel experts out there? (soft return in a cell?)