Home

New Power Query Enhancements: IntelliSense & Syntax coloring

%3CLINGO-SUB%20id%3D%22lingo-sub-825456%22%20slang%3D%22en-US%22%3ENew%20Power%20Query%20Enhancements%3A%20IntelliSense%20%26amp%3B%20Syntax%20coloring%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-825456%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3EOne%20of%20the%20long-awaited%20features%20was%20recently%20added%20to%20Excel%20in%20the%20latest%20Office%20365%20update%2C%26nbsp%3B%3C%2FSPAN%3E%3C%2FSPAN%3Ewhich%20is%20the%20code%20completion%20(IntelliSense)%20and%20syntax%20coloring%20%3CSPAN%20class%3D%22tlid-translation%20translation%22%3E%3CSPAN%20class%3D%22%22%3Ethat%20was%20added%20in%20%3C%2FSPAN%3E%3C%2FSPAN%3Ethe%20Custom%20Column%20Editor%20and%20the%20Advanced%20Editor.%20In%20addition%20to%20other%20features%20in%20the%20Advanced%20Editor%20such%20as%20Display%20line%20numbers.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F128805i2BC83AB73E50988D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Power%20Query%20IntelliSense.png%22%20title%3D%22Power%20Query%20IntelliSense.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F128807i4ECD8587BA6B2C3F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Advanced%20Editor%20New%20Features.png%22%20title%3D%22Advanced%20Editor%20New%20Features.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20use%20these%20features%20if%20you%20have%20the%20latest%20Office%20365%20update%3A%3C%2FP%3E%3CP%3EVersion%201908%20(Build%2011929.20254)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-825456%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-825499%22%20slang%3D%22en-US%22%3ERe%3A%20New%20Power%20Query%20Enhancements%3A%20IntelliSense%20%26amp%3B%20Syntax%20coloring%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-825499%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35679%22%20target%3D%22_blank%22%3E%40Haytham%20Amairah%3C%2FA%3E%26nbsp%3B%2C%20which%20channel%20is%20it%3F%20On%20Monthly%20Targeted%20it's%20from%20mid%20July%20starting%20from%201907.11901.20080%2C%20is%20it%20Monthly%20Channel%20now%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-825540%22%20slang%3D%22en-US%22%3ERe%3A%20New%20Power%20Query%20Enhancements%3A%20IntelliSense%20%26amp%3B%20Syntax%20coloring%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-825540%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20recently%20added%20the%20stable%20production%20channel%20(Monthly%20Channel)%20which%20is%20the%20intended%20channel%20when%20we%20just%20say%20Office%20365.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYep%2C%20it's%20been%20in%20the%20insider%20(Monthly%20Targeted)%20a%20while%20ago.%20but%20since%20the%20major%20Office%20365%20users%20are%20on%20the%20Monthly%20Channel%2C%20it%20is%20better%20to%20delay%20talking%20about%20it%20until%20it%20reaches%20the%20stable%20version.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-825554%22%20slang%3D%22en-US%22%3ERe%3A%20New%20Power%20Query%20Enhancements%3A%20IntelliSense%20%26amp%3B%20Syntax%20coloring%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-825554%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F35679%22%20target%3D%22_blank%22%3E%40Haytham%20Amairah%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EGreat%2C%20thank%20you.%20The%20only%20reason%20I%20asked%20is%20to%20push%20tomorrow%20some%20people%20I'm%20working%20with%20and%20who%20are%20on%20Monthly%20Channel%20to%20check%20if%20they%20have%20the%20update.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Haytham Amairah
Trusted Contributor

Hi all,

 

One of the long-awaited features was recently added to Excel in the latest Office 365 update, which is the code completion (IntelliSense) and syntax coloring that was added in the Custom Column Editor and the Advanced Editor. In addition to other features in the Advanced Editor such as Display line numbers.

 

Power Query IntelliSense.png

 

Advanced Editor New Features.png

 

You can use these features if you have the latest Office 365 update:

Version 1908 (Build 11929.20254)

 

Regards

3 Replies

@Haytham Amairah , which channel is it? On Monthly Targeted it's from mid July starting from 1907.11901.20080, is it Monthly Channel now?

@Sergei Baklan

 

It's recently added the stable production channel (Monthly Channel) which is the intended channel when we just say Office 365.

 

Yep, it's been in the insider (Monthly Targeted) a while ago. but since the major Office 365 users are on the Monthly Channel, it is better to delay talking about it until it reaches the stable version.

@Haytham Amairah 

Great, thank you. The only reason I asked is to push tomorrow some people I'm working with and who are on Monthly Channel to check if they have the update.