Excel:Insert in-cell images with the new IMAGE function

Your images can now be part of the worksheet, instead of floating on top. You can move and resize cells, sort and filter, and work with images within an Excel table.

(more…)

Excel: Insert data from a picture

Add table data from an image from the Data tab.

(more…)

Excel: Run team-owned scripts in Excel for the web

Office Scripts is an automation feature-set in Excel for the web. With this new feature, users will be able to save their scripts to a SharePoint site so that their team members can more easily collaborate, view, and run team-owned scripts on their Excel workbooks.

(more…)

Excel: Argument Assistance

Argument assistance is a card that shows up when the user is writing a formula and accompanies the user during the arguments insert/edit. The Argument Assistance helps the user to be more efficient while writing formulas and reduces risk for errors, without needing to look for help in external resources. It includes descriptions of the formula and the different arguments, as well as an example. The relevant argument (according to caret’s position) will be highlighted for better orientation. The user can collapse the card and see only the top formula signature (like the tooltip today) in case he/she prefers not to hide much of the grid (we’ll save that preference).

(more…)

Excel: Multiline Formula Bar

Users can resize the formula bar and easily navigate.

(more…)

Excel: Queries Task Pane

The Queries Task Pane will allow to view the queries and query groups in the workbook and related details.

(more…)

Excel: Refresh Power Query data from the current workbook

You can refresh Power Query queries that their data was imported from the current workbook.

(more…)

Excel: Run your Office scripts from a workbook button now on Windows

Previously, Office scripts could be run via buttons by everyone with access to the workbook in Excel on the web. Now, you can run that same button on your windows client.

(more…)

Excel: Hyperlinks in Modern Comments

Add hyperlinks to your Modern Comments in Excel.

(more…)

Excel: Support for Large Files from SharePoint in Excel for the web

You can now open and edit files up to 100 MB from SharePoint in Excel for the web.

(more…)


I've been working with Microsoft Technologies over the last ten years, mainly focused on creating collaboration and productivity solutions that drive the adoption of Microsoft Modern Workplace.