tcho·6 か月前·議論In case this is helpful, you can get newlines within the Excel cell itself by doing the following.> 1. You can drag down the bottom of the formula bar/field and make it multi-line.> 2. You can insert arbitrary newlines in an Excel formula.> For example: =INDEX( $C$17:$S$24, MATCH(A6,$A$17:$A$24,0), MATCH(C6,$C$15:$S$15,0) ) I learned this from this comment from last week: https://news.ycombinator.com/item?id=46341227
> 1. You can drag down the bottom of the formula bar/field and make it multi-line.
> 2. You can insert arbitrary newlines in an Excel formula.
> For example:
I learned this from this comment from last week: https://news.ycombinator.com/item?id=46341227