A busy day over at Ignite 2021 gives us an early look at a significant new feature in Excel that has the potential to have a huge impact in the coming years.
Excel JavaScript API and custom data types
News Sheet
Office Scripts gets… buttons
There's a new way to launch a macro with Office Scripts!
Office Scripts in Excel arrives for everyone*
Office Scripts, the Next Big Thing for the long term future of automation in Excel, is now officially here. Well... sort-of. Read on for more information!
Office Scripts samples and scenarios
Microsoft gets busy collating realistic examples for Office Scripts. Tinkering with Office Scripts yet? Check these out!
15 years of XLSX: choose file formats carefully
Still using .XLS to save new spreadsheets? It has now been 15 years since XLSX arrived. What happens when you choose the wrong format?
Conditional formatting improvements
Now you can duplicate conditional formatting rules and resize conditional formatting dialog boxes.
Unhide multiple worksheets at once
Now you can unhide multiple sheets at once, thanks to the latest Excel software update.
Introducing the LAMBDA function
Now you can define your own re-usable functions with LAMBDA
XLOOKUP and XMATCH: a new lookup to rule them all (almost)
Tired of arguing the relative merits of VLOOKUP or INDEX/MATCH? Well, now there's a new one to add. XLOOKUP is here to be a quicker, smarter VLOOKUP and XMATCH overhauls MATCH. Read on for details!
New Excel function LET
LET lets you name parts of your formulas! This is one of those features that has more power than we might first realize; chances are its use will increase dramatically over time as its utility becomes more obvious.