How do I enter a line break within a cell?

ALT + ENTER


Gord Dibben Excel MVP

On Thu, 17 Nov 2005 11:15:15 -0800, "Striving for efficiency"
<[email protected]> wrote:

alt-enter if you're typing
or "& char(10) &" if you're using a formula:

="this is line 1" & char(10) & "this is not line 1"

format|Cells|alignment tab|check wrap text.



Striving for efficiency wrote:

--

Dave Peterson

does anyone else get an error when responding to a post with no text? I
can't respond at all to these posts.

"Gord Dibben" wrote:

> ALT + ENTER
>
>
> Gord Dibben Excel MVP
>
> On Thu, 17 Nov 2005 11:15:15 -0800, "Striving for efficiency"
> <[email protected]> wrote:
>
>
>

Most of the regulars around here don't use the web based interface. You may
want to switch, too (if it's ok with your company's firewall???):

Saved from a previous post:

If you have Outlook Express installed, try clicking on these links (or copy and
paste into MSIE).

news://msnews.microsoft.com/microsof...ic.excel.setup
news://msnews.microsoft.com/microsoft.public.excel.misc
news://msnews.microsoft.com/microsof...heet.functions
news://msnews.microsoft.com/microsof...excel.newusers
news://msnews.microsoft.com/microsof...el.programming

(and a few more for MSWord)
news://msnews.microsoft.com/microsof....docmanagement
news://msnews.microsoft.com/microsof...word.word97vba
news://msnews.microsoft.com/microsof....word.newusers
news://msnews.microsoft.com/microsof...ord.pagelayout
news://msnews.microsoft.com/microsof...ord.vba.addins
news://msnews.microsoft.com/microsof....vba.beginners
news://msnews.microsoft.com/microsof....customization
news://msnews.microsoft.com/microsof...rd.vba.general
news://msnews.microsoft.com/microsof....vba.userforms
news://msnews.microsoft.com/microsof....word6-7macros

(You can always connect to more later)

Here are some links that explain it better:

Chip Pearson has some notes written by Leonard Meads at:
http://www.cpearson.com/excel/DirectConnect.htm

David McRitchie's notes at:
http://www.mvps.org/dmcritchie/excel/xlnews.htm
http://www.mvps.org/dmcritchie/excel/oe6.htm
http://www.mvps.org/dmcritchie/excel/oe6nws01.htm

Tushar Mehta's notes at:
http://www.tushar-mehta.com/misc_tut...e_ng/index.htm

And if you're looking for old posts:

Or you can use google to search for stuff you've posted (and find the replies,
too)

http://groups.google.com/advanced_group_search
http://groups.google.com/advanced_gr...Excel*&num=100

Ron de Bruin has an excel addin that you may like:
http://www.rondebruin.nl/Google.htm




Sloth wrote:
>
> does anyone else get an error when responding to a post with no text? I
> can't respond at all to these posts.
>
> "Gord Dibben" wrote:
>
> > ALT + ENTER
> >
> >
> > Gord Dibben Excel MVP
> >
> > On Thu, 17 Nov 2005 11:15:15 -0800, "Striving for efficiency"
> > <[email protected]> wrote:
> >
> >
> >

--

Dave Peterson