Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3
Default Text In Cells Query

Can I Split Text into two lines within one Cell
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 2
Default Text In Cells Query

Right click in the cell you wish to enter text in and select format cells,
then select Alignment and check the Wrap text box. Go back to your sell and
type the info you want.
--
MaggieB


"bambiethree" wrote:

Can I Split Text into two lines within one Cell

  #3   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Text In Cells Query

Think it's easier to use Alt+ENTER to force a new line within a cell
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"MaggieB" wrote:
Right click in the cell you wish to enter text in and select format cells,
then select Alignment and check the Wrap text box. Go back to your sell and
type the info you want.


  #4   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3
Default Text In Cells Query

Hi Maggi B
Thanks for your tip, much appreciated.
Kind Regards
bambiethree

"MaggieB" wrote:

Right click in the cell you wish to enter text in and select format cells,
then select Alignment and check the Wrap text box. Go back to your sell and
type the info you want.
--
MaggieB


"bambiethree" wrote:

Can I Split Text into two lines within one Cell

  #5   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Text In Cells Query

Just press Alt+ENTER to break for a new line within a cell
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"bambiethree" wrote:
Can I Split Text into two lines within one Cell



  #6   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3
Default Text In Cells Query

Hi Max,
Many Thanks for your Tip, much appreciated.
bambiethree

"Max" wrote:

Just press Alt+ENTER to break for a new line within a cell
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"bambiethree" wrote:
Can I Split Text into two lines within one Cell

  #7   Report Post  
Posted to microsoft.public.excel.newusers
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Text In Cells Query

Welcome, bambiethree.
Thanks for the feedback
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"bambiethree" wrote in message
...
Hi Max,
Many Thanks for your Tip, much appreciated.
bambiethree



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
Formula Query - Using Time & Text JDB Excel Worksheet Functions 7 July 12th 06 08:34 AM
Query counting cells in a row that exactly match cells in another Marlsnz Excel Discussion (Misc queries) 1 June 2nd 06 07:08 AM
Copy Text from cell to paste on New Web Query vovlov Excel Discussion (Misc queries) 0 May 19th 06 01:21 PM
Referencing a form text box in a query James O Excel Discussion (Misc queries) 0 September 13th 05 10:50 PM
Help With Query Web & Imported Text Blackmore Excel Discussion (Misc queries) 0 August 13th 05 01:11 PM


All times are GMT +1. The time now is 04:17 PM.

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

About Us

"It's about Microsoft Excel"