Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Typing more than 1 line in a cell

How do I do this? I have enlarged the cell and am using auto wrap. I want to
type in the customers name and address on 3 lines. I can get it to wrap, but
not where I want it to, ie. it will wrap at the end of the width of the cell
but I want it to wrap at the end of the name.
TIA
Linda in IL
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 5,939
Default Typing more than 1 line in a cell

Hold down the Alt key and hit Enter
--
HTH...

Jim Thomlinson


"Linda in IL" wrote:

How do I do this? I have enlarged the cell and am using auto wrap. I want to
type in the customers name and address on 3 lines. I can get it to wrap, but
not where I want it to, ie. it will wrap at the end of the width of the cell
but I want it to wrap at the end of the name.
TIA
Linda in IL

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Typing more than 1 line in a cell

Thank you soooooo much Jim!!!

"Jim Thomlinson" wrote:

Hold down the Alt key and hit Enter
--
HTH...

Jim Thomlinson


"Linda in IL" wrote:

How do I do this? I have enlarged the cell and am using auto wrap. I want to
type in the customers name and address on 3 lines. I can get it to wrap, but
not where I want it to, ie. it will wrap at the end of the width of the cell
but I want it to wrap at the end of the name.
TIA
Linda in IL

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Typing in a cell Help Excel Discussion (Misc queries) 4 May 2nd 08 06:00 AM
Typing "..." gives me a verticle line. how do i disable this? Dave Close Excel Discussion (Misc queries) 1 August 29th 07 12:44 PM
typing addresses & when I hit enter need to be on next line cel B Tina Excel Discussion (Misc queries) 2 June 30th 06 08:52 AM
how do i go to a cell by just typing a letter aaggeorge Excel Discussion (Misc queries) 1 January 26th 06 06:30 PM
How do I advance to next line when typing in the formula bar? Penguin New Users to Excel 2 January 21st 05 09:39 PM


All times are GMT +1. The time now is 03:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"