how do i make text fit into 1 block in 2 or more lines in Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i want to know do i make my text fit into 1 block if it is a long sentance
needing two or three lines . pressing enter in the fromula bar doen't work.
 
You can force text to wrap by inserting the vertical bar symbol "|"
(above the backslash on most US keyboards.) You may have to adjust the
cell height to see the second line.

---Glenn
 
Sorry, I guess my age is showing, I was thinking 1-2-3. Use Alt-Enter
to force the line wrap within a cell in Excel...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - How do I fit 2 lines of text in one cell, vs a long line? 4
How can I get a long block of wrapped text to print? 3
Changing Font Size Doesn't Allow More Text to Fit in Cell 4
Comparing 2 blocks of text and data 2
how do i insert the best fit line into my graft please? 2
Excel 2007 - Scale To Fit 1
Word to Excel: Export comments with text and line number 0
AUTO FIT not WORKING properly. Does not shrink row to fit 2

Back
Top