You select the cells up to the seventh column (G). But here’s how you can achieve this by using Fill/Justify. Now doing this manually could turn out to be quite a difficult task.

So the Question would go, how to get all this text to span evenly over the first seven columns. But as we can see, the lyrics span over unevenly and in some cases (Paul McCartney’s middle section) over the entire length of the Excel window. In our case it’s the lyrics of “A Day in the life” by The Beatles. Often you are given the data that looks very similar to the picture above. We will sort them into two piles, primary and secondary. Now this one can do wonders, and in many different ways. You can find it in HOME/Editing/Fill/Justify Well this is great, and works as one would expect, but there is another Justify in Excel. Interestingly enough, it’s only missing from the HOME tab, but you can add it to your QAT (Quick Access Toolbar). Now whereas this seems great in word, in Excel, the icon is missing. Well the last one is called Justify and the following picture shows what it does. The four icons bellow are well known to all. But as this is a rather unknown command in Excel, let’s dig into it from the start. So just the other day, as the lesson on Fill/Series… took us deep into Weekday territory, I got served with a rather unorthodox use of the command Fill/Justify described here in Fill/Series secondary. Whereas sometimes when I’m done so on an Excel Basic training, it just makes me want to rethink the whole career path, in general, these are the moments I crave for since it means I am about to learn something new.

But every so often I’m the one getting served. In my work as a trainer I’m usually the one serving the Excel goodies to the audience.

What justify text excel