OK, here’s another trick: if you select A1:D3 and issue the justify command, you would get this: Notice the difference with different column widths here (column B is wider, column C is pretty narrow), where A:C was selected: The entire columns A:B were selected prior to using Justify. (The resulting selection, A1:A4, happens after the command is completed. You could have selected just columns A and B and reissued the same command for this result: In the above example, the selection had to be A1:C3 or longer (A1:C4, A1:C100, etc.):įrom this selection, issuing the Justify command would reflow the text as we saw. To use it, you have to make a specific selection first.
Many people are unaware that Excel has this ability already built-in! It’s the Justify command, found on the right side of the Home tab: And you’d like to make it look like this:
0 kommentar(er)
