Typing text in excel question

PATSYS

Well-known Member
Joined
Mar 12, 2006
Messages
1,749
How do you do it in excel in such a way that when you type a text, that if the text gets so long that it doesn't go to the far right side. Instead it goes to the next line, just like it would if you type in in WORD document.

I think I have seen that done before siomewhere.

Thanks.
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

PATSYS

Well-known Member
Joined
Mar 12, 2006
Messages
1,749
Hi,

Thanks for your reply. Your suiggestion is one way to do it but that will entail that I merge cells otherwise my text will be wrapped in just one cell.

I think I have seen something before wherein you wouldn't need to merge cells, you will just have to highlight them and do something and your text will be wrapped in a certain range.
 

patrickmuldoon99

Active Member
Joined
Jun 27, 2006
Messages
345
You do not have to merge a cell, you can simply increase the column width to accommodate the text you wish to enter. I never mentioned merging cells.

The only thing I can think of that sounds similar to what you're saying is to select your range, and goto Format Cells --> Alignment and in the 'Horizontal' drop down box select center across cells.

Another alternative you have is to place a text box from teh drawing toolbar on your document, allowing you to type in a similar vein to Microsoft Word.

What you have to remember is that XL is not designed for rich text formatting - its a number crunching app. If such issues are particularly imiportant, perhaps you should reconsider your choice of program for your task?
 

Forum statistics

Threads
1,141,718
Messages
5,708,072
Members
421,543
Latest member
SGM

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top