Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
vsimmons
 
Posts: n/a
Default how do I enter more than one line in the same Excel Cell by using.

I want to have more than one line of text in the same Excel Cell without
using the wrap text format option. For example, I want to put an entire
address in the Cell by typing in the name of the person, then hit enter, type
the steet address, then hit enter, then type in the city, state, and zip.
  #2   Report Post  
Michael
 
Posts: n/a
Default

Use alt-enter to put in a line break.

"vsimmons" wrote:

I want to have more than one line of text in the same Excel Cell without
using the wrap text format option. For example, I want to put an entire
address in the Cell by typing in the name of the person, then hit enter, type
the steet address, then hit enter, then type in the city, state, and zip.

  #3   Report Post  
Michael
 
Posts: n/a
Default

Use alt-enter

"vsimmons" wrote:

I want to have more than one line of text in the same Excel Cell without
using the wrap text format option. For example, I want to put an entire
address in the Cell by typing in the name of the person, then hit enter, type
the steet address, then hit enter, then type in the city, state, and zip.

  #4   Report Post  
Michael
 
Posts: n/a
Default

Use alt-enter

"vsimmons" wrote:

I want to have more than one line of text in the same Excel Cell without
using the wrap text format option. For example, I want to put an entire
address in the Cell by typing in the name of the person, then hit enter, type
the steet address, then hit enter, then type in the city, state, and zip.

  #5   Report Post  
vsimmons
 
Posts: n/a
Default

works great, thank you.

"Michael" wrote:

Use alt-enter

"vsimmons" wrote:

I want to have more than one line of text in the same Excel Cell without
using the wrap text format option. For example, I want to put an entire
address in the Cell by typing in the name of the person, then hit enter, type
the steet address, then hit enter, then type in the city, state, and zip.



  #6   Report Post  
vsimmons
 
Posts: n/a
Default

works great, thank you.

"Michael" wrote:

Use alt-enter to put in a line break.

"vsimmons" wrote:

I want to have more than one line of text in the same Excel Cell without
using the wrap text format option. For example, I want to put an entire
address in the Cell by typing in the name of the person, then hit enter, type
the steet address, then hit enter, then type in the city, state, and zip.

  #7   Report Post  
Robert
 
Posts: n/a
Default

This doesn't seem to work for me....Am I missing something?

"Michael" wrote:

Use alt-enter

"vsimmons" wrote:

I want to have more than one line of text in the same Excel Cell without
using the wrap text format option. For example, I want to put an entire
address in the Cell by typing in the name of the person, then hit enter, type
the steet address, then hit enter, then type in the city, state, and zip.

  #8   Report Post  
Gord Dibben
 
Posts: n/a
Default

Robert

Type the person's name then hold ALT key and hit <ENTER key.

Type next line then ALT + <ENTER again.

Type third line then hit just <ENTER key to leave the cell.


Gord Dibben Excel MVP


On Tue, 15 Mar 2005 05:15:05 -0800, Robert
wrote:

This doesn't seem to work for me....Am I missing something?

"Michael" wrote:

Use alt-enter

"vsimmons" wrote:

I want to have more than one line of text in the same Excel Cell without
using the wrap text format option. For example, I want to put an entire
address in the Cell by typing in the name of the person, then hit enter, type
the steet address, then hit enter, then type in the city, state, and zip.


  #9   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default how do I enter more than one line in the same Excel Cell by us

Wondering if you have found a solution as none working for me
thanks

"Robert" wrote:

This doesn't seem to work for me....Am I missing something?

"Michael" wrote:

Use alt-enter

"vsimmons" wrote:

I want to have more than one line of text in the same Excel Cell without
using the wrap text format option. For example, I want to put an entire
address in the Cell by typing in the name of the person, then hit enter, type
the steet address, then hit enter, then type in the city, state, and zip.

  #10   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,480
Default how do I enter more than one line in the same Excel Cell by us

Hi

Do as you have been instructed and used Alt+Enter

After you have finished, mark the cellsFormatAlignmentremove check mark
from Wrap text.
You will see a small square symbol appearing between each entry you have
made, where the line feed would appear in wrap text mode.

--
Regards
Roger Govier



"Benongo" wrote in message
...
Wondering if you have found a solution as none working for me
thanks

"Robert" wrote:

This doesn't seem to work for me....Am I missing something?

"Michael" wrote:

Use alt-enter

"vsimmons" wrote:

I want to have more than one line of text in the same Excel Cell
without
using the wrap text format option. For example, I want to put an
entire
address in the Cell by typing in the name of the person, then hit
enter, type
the steet address, then hit enter, then type in the city, state, and
zip.





  #11   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default how do I enter more than one line in the same Excel Cell by us

Alt + ENTER is the tried and true method of inserting a linefeed in a cell.

Person name Alt + ENTER, street address Alt + ENTER etc.

Hit just ENTER when you are done.


Gord Dibben MS Excel MVP


On Sat, 17 Nov 2007 23:28:00 -0800, Benongo
wrote:

Wondering if you have found a solution as none working for me
thanks

"Robert" wrote:

This doesn't seem to work for me....Am I missing something?

"Michael" wrote:

Use alt-enter

"vsimmons" wrote:

I want to have more than one line of text in the same Excel Cell without
using the wrap text format option. For example, I want to put an entire
address in the Cell by typing in the name of the person, then hit enter, type
the steet address, then hit enter, then type in the city, state, and zip.


  #12   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8
Default how do I enter more than one line in the same Excel Cell by us

thanks this was great and so easy and i spent hours trying to look up how to
do this and found this and wowo so easy thanks again

"Michael" wrote:

Use alt-enter to put in a line break.

"vsimmons" wrote:

I want to have more than one line of text in the same Excel Cell without
using the wrap text format option. For example, I want to put an entire
address in the Cell by typing in the name of the person, then hit enter, type
the steet address, then hit enter, then type in the city, state, and zip.

  #13   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default how do I enter more than one line in the same Excel Cell by us

Easily found in Help under Keyboard ShortcutsKeys for entering, editing,
formatting, and calculating data

Alt + Enter is second in the list.

You should spend a few minutes one day going through the list of keyboard
shortcuts. Can be quite handy.


Gord Dibben MS Excel MVP

On Fri, 2 Jan 2009 15:19:01 -0800, nippy
wrote:

thanks this was great and so easy and i spent hours trying to look up how to
do this and found this and wowo so easy thanks again

"Michael" wrote:

Use alt-enter to put in a line break.

"vsimmons" wrote:

I want to have more than one line of text in the same Excel Cell without
using the wrap text format option. For example, I want to put an entire
address in the Cell by typing in the name of the person, then hit enter, type
the steet address, then hit enter, then type in the city, state, and zip.


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
Line and Column Graph Nikki Charts and Charting in Excel 3 February 4th 05 05:42 AM
How do I change the colour of/remove the Freeze Panes line in Exce katya_1978 Excel Worksheet Functions 1 January 20th 05 07:17 PM
Line chart - date line association gone mad! Johannes Czernin Charts and Charting in Excel 5 January 17th 05 09:48 PM
Macro - Skipping a line PaulPoll Excel Worksheet Functions 4 December 21st 04 01:43 AM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 04:56 AM


All times are GMT +1. The time now is 03:50 PM.

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"