The text can be in one row or multiple rows.Excel only includes the rows of text that are selected.If you select too many rows Excel will just fill what it needs, and if you select too few it will give you a warning, which is handy if you have data underneath your text. Excel will automatically select the number of rows required.You’ll find Fill Justify on the Home tab of the ribbon in the Editing group:Īnd if you use it all the time you can add it to your Quick Access Toolbar so it's always just a click away. there must be something it can't do that Word can.um.oh, there is one thing it can't do Mail Merge! If you manage to read the text in the animated image above you should know that I am joking 🙂 Excel can't. You can see in the animated image below that it’s quick to change the number of rows or columns the text occupies by simply selecting the text and the number of columns you want it to span by applying the Fill Justify tool: They say the true Excel fan has uninstalled Word from their PC, and removed the F1 key from their keyboard (accidentally pressing F1 opens ‘Help’ which slows you down).Īfter all, who needs Word when you have everything you need to write a letter right there in Excel?Ī must know tool for us Excel Die Hards is the Fill Justify tool which enables us to rearrange text across columns and rows automatically. Excel for Decision Making Under Uncertainty Course.Excel for Customer Service Professionals.

Right justify text excel