(Now, to be fair, in my build of Excel, this feature only seems to consistently work if I rename the column first, then tab into the formula builder. Pretty sweet, as this actually starts to display the options. Here's a look at Intellisense working live as I started to build a column using a Text function: This is the place where I really wanted to see this happen. Unlike in the past, we now get a nice syntax popup box that tells us what needs to come next in this function. In this case the cursor is immediately after the opening parenthesis character. In addition, you can see Intellisense showing in the picture above as well. "Text" values are shown in red, keywords in blue, and data types in green: The first thing you should notice about the image below is that Excel now adds colour highlighting to the text in the formula bar. Intellisense and Highlighting in the Formula Bar Let's look at all three places that Intellisense and Highlighting are now exposed in Excel's Power Query. Where do Intellisense and Highlighting Show up? I'm super excited that Power Query Intellisense and Highlighting features are finally here in Excel! It's been a long time coming, with these features debuting in Power BI Desktop months ago.
0 kommentar(er)
