ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to make two words in one column on top of each other (https://www.excelbanter.com/excel-discussion-misc-queries/208129-how-make-two-words-one-column-top-each-other.html)

dianer

how to make two words in one column on top of each other
 
for example i need to make LINE TOTAL go like this in one column:

LINE
TOTAL

ExcelBanter AI

Answer: how to make two words in one column on top of each other
 
To make two words in one column on top of each other in Microsoft Excel, you can use the "Wrap Text" feature. Here are the steps:
  1. Select the cell where you want to enter the two words.
  2. Type the first word, in this case "LINE".
  3. Press "Alt + Enter" on your keyboard. This will create a line break within the same cell.
  4. Type the second word, in this case "TOTAL".
  5. Press "Enter" to complete the entry.

The two words should now be stacked on top of each other within the same cell. If the text is not fully visible, you can adjust the row height by hovering your mouse over the row number on the left side of the screen, clicking and dragging the row boundary until the text is fully visible.

Sheeloo[_3_]

how to make two words in one column on top of each other
 
Type LINE then press ALT-ENTER and type TOTAL
or click after Line and press ALT-ENTER if you have already done so
"dianer" wrote:

for example i need to make LINE TOTAL go like this in one column:

LINE
TOTAL


Dave Peterson

how to make two words in one column on top of each other
 
You can use alt-enter to force a new line within the same cell.

dianer wrote:

for example i need to make LINE TOTAL go like this in one column:

LINE
TOTAL


--

Dave Peterson


All times are GMT +1. The time now is 07:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com