LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 293
Default Add A Line In A Text Cell

Greetings,

I need to add a line in a cell being used as a header. There are
three ways to do this:

1) Use Char(10) in a formula - disadvantage is no formatting (Size,
color or font)

2) Use a LOT of spaces - disadvantage is it looks messy and sometimes
does unexpected things.

3) Use some keystroke combination to force a line feed - disadvantage
is you cannot mix text and formulas (I can live with that)..

I am looking for number 3.

Anyone know what that keystroke combination is?

Any help is appreciated, thanks.

-Minitman
 
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
Keep text at top line of cell Sarah Excel Discussion (Misc queries) 3 March 28th 08 08:38 PM
Why does text in a cell appear as a line of '#' symbols? Kramer Excel Discussion (Misc queries) 3 March 8th 07 08:13 PM
I have alot of text in a cell, I just want to see the top line Emma Excel Worksheet Functions 1 November 14th 05 05:27 AM
Can you get line breaks in a text cell RFJ Excel Discussion (Misc queries) 3 November 9th 05 07:20 PM
A 2 line text showing up in the Cell in Excel prints in 1 line Danny Excel Discussion (Misc queries) 6 July 12th 05 08:47 PM


All times are GMT +1. The time now is 06:07 AM.

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"