From the course: Excel Tips Weekly

Unlock this course with a free trial

Join today to access over 22,600 courses taught by industry experts.

Use Alt+Enter and Wrap Text for line-wrapping titles and improving formula readability

Use Alt+Enter and Wrap Text for line-wrapping titles and improving formula readability - Microsoft Excel Tutorial

From the course: Excel Tips Weekly

Start my 1-month free trial Buy for my team

Use Alt+Enter and Wrap Text for line-wrapping titles and improving formula readability

“

- [Instructor] On this worksheet called employee list I'm putting in headings in row one. And in cell C1, I'm about to type 2021 salary. And I recognize that this column is going to be a lot wider than needs to be because the text below it will not exceed six characters. So I've got some options here. I could consider using a feature called wrap text. And at the moment it has not been selected. Sliding over wrap text, you see the description, wrap extra long text into multiple lines so you can see all of it. Sounds good, but I'm going to use first it's keystroke equivalent. Not quite a perfect keystroke equivalent because it's limited in what it can do but on the other hand, it might be easier to use. So, I'm going to type 20 and then press Alt + Enter. Look what happens. A line break has been introduced. Then we'll type salary and Enter. And immediately the row becomes taller. That's a slight negative perhaps.…

Contents