Two lines of characters in one cell

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

Guest

After increasing the height of a row, how do I type two lines of text in one
cell,

Example: "Excess Wages
3rd Qtr."

Thank You in advance.
Linda
 
Format|Cells. Check Wrap Text on the Alignment Tab.
Alternatively, you can press Alt+Enter to force a new line in a cell.

tj
 
Hi Linda

Use Alt-Enter if you want to go to the next line in a cell
 
And if you ever need to do it with formulas:

=a1&char(10)&b1

(format|cells|alignment tab|check wordwrap)
 

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

Back
Top