ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   basic: how to make excel not cut off words! (https://www.excelbanter.com/excel-discussion-misc-queries/190012-basic-how-make-excel-not-cut-off-words.html)

irafi

basic: how to make excel not cut off words!
 
in excel 2007, how do I make Excel just skip to the next line when displaying
something I've typed that is too long to fit on one line, instead of just
cutting it off so I have partial headings?

Right now when I print preview, I have for instance in one cell...
Walden Internatio

and I'd like it to do
Walden
International
thanks!

Niek Otten

basic: how to make excel not cut off words!
 
FormatCellsAlignment tab, check Wrap text

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"irafi" wrote in message ...
| in excel 2007, how do I make Excel just skip to the next line when displaying
| something I've typed that is too long to fit on one line, instead of just
| cutting it off so I have partial headings?
|
| Right now when I print preview, I have for instance in one cell...
| Walden Internatio
|
| and I'd like it to do
| Walden
| International
| thanks!



rdwj

basic: how to make excel not cut off words!
 
format
cells
wrap text

"irafi" wrote:

in excel 2007, how do I make Excel just skip to the next line when displaying
something I've typed that is too long to fit on one line, instead of just
cutting it off so I have partial headings?

Right now when I print preview, I have for instance in one cell...
Walden Internatio

and I'd like it to do
Walden
International
thanks!



All times are GMT +1. The time now is 04:14 PM.

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