Get 20+ Excel courses at Simon Sez IT, including training for Excel 365, 2021, 2019, 2016, 2013, and more ️ https://www.simonsezit.com/course-category/excel/ Get my free 3 hour Excel 2013 course: https://simonsezit.leadpages.net/free-excel-2013-course/
Get 17 training videos to help you learn MS Excel 2013.

When typing some data into a cell in Excel, sometimes the text is long such that the text just spills over. What do you do to make the text fit into the cell? You could make the column wider, but there's a better way of dealing with that. In this video, you will learn more about how to Wrap Text and other formatting functions such as vertical alignment, horizontal alignment, and alignment for numbers. You can set alignment as General, Justify, or Center. Find out all these in this Excel 2013 training tutorial!

Get over 70 hours of Microsoft Office 2013 training here course here: http://bit.ly/office-2013-training

Stay in touch:
StreamSKill.com: http://streamskill.com/
SimonSezIT.com: https://www.SimonSezIT.com/
The Simon Sez IT email newsletter: http://bit.ly/18bMwY0
YouTube Channel: http://bit.ly/foiItB
Twitter: http://bit.ly/177EU5J
Google+: http://bit.ly/11JbHdb

If you enjoyed the video, please give a "thumbs up" and subscribe to the channel -)


Hello again. In this section, we’re looking again at formatting a worksheet in our course on Excel 2013. In the previous section, we looked at things like inserting and deleting columns and rows. In this one, we’re going to look at a little bit more detail on formatting a worksheet. Now I’ve gone back to the table of expenses that we looked at earlier on. I’ve inserted another column here.

The other column I’ve got here is one that denotes the name of the particular customer that a particular expense was associated with. Where there isn’t a customer name then I’ve just put it under the heading of prospects. This is for potential customers. And one of the entries here I’ve left blank and I’ll talk about that in a moment or two.

So having entered this other Column what I’m now going to do is to set about formatting it in a better way, make it look a little bit more attractive. And we’re going to use both the work we’ve done already on formatting columns and rows but also we’re going to introduce theme and style considerations as well. So let’s get started.

Now one of the first things that I’m going to deal with here is what happens in a situation like this one where I’ve added another row but the description of the expense is now even longer than any of the ones that we’ve had before. And potentially dealing with a description as long as the long that I’ve typed in there is going to mean that in order to extend the width of Column D enough to accommodate that, first of all the width of the overall expenses claim is going to get wider and wider and secondly there’s a lot of wasted space here with the others. So the first thing I want to show you is that when you’re dealing with text fields, you can actually use more than one line for a description in this case and you can do that by wrapping text.

Now if I select Column D, right click, and go into Format Cells, then one of the options there on the Alignment tab is Wrap Text. So let’s check Wrap Text, click on OK, and see what happens. Now at the moment there’s no need for the text to wrap because it’s got plenty of width. But supposing I reduced the Column D width down again, watch what happens as I reduce it. Now when I get to that point you can see that in two of the entries the text has wrapped. The other things you can probably notice, first of all, in Row 7 I’ve lost part of the text and in all of them the text is aligned with the bottom of the cell. So for instance here, the date in Row 8 is at the bottom of Row 8. Now you may not particularly want it at the bottom or you may. But I need to show you how to set that as well.

And this in fact leads us to a very important aspect of formatting in a worksheet in general. When you’re formatting in a worksheet, what you’re formatting applies to is what you have selected at that time. When I set Wrap Text just now, I had Column D selected, the whole of Column D. And remember there are potentially thousands of rows in Column D. Every row in Column D has the same setting for text wrapping and that is text will wrap.

If I had chosen say one cell in Column D, let’s say if I’d chosen that one I’d right clicked on that, gone into Format Cells, and for that one I had checked off Wrap Text. So I unchecked it, click on OK, and for that one cell alone text is not wrapped. Now clearly that’s not a very good solution in this case because that’s the worse cell of all and the one that needs wrapping the most.

Sorry, we couldn't fit the entire video transcription here since YouTube only allows 5000 characters.