New feature in Microsoft Excel will put an end to many headaches

Microsoft wants to avoid additional headaches with one of Excel’s more complex features, the spreadsheet program that’s part of what was formerly known as Office 365 (now called Microsoft 365). The company, in particular, announced a new update for the web version with a function, will allow you to automatically generate formulas using suggestions.

The function called “Formula Suggestions” This allows, as the name suggests, to let Excel suggest a formula that is related to the rest of the content that the user has previously entered in a cell, column, or row. To do this, the author or editor of this table will only need to write the “=” sign in the cell or in the formula bar located at the top of the screen.

Excel will automatically display the most appropriate options, which can be as follows: sum, average value, quantity, numerical value, min. and max. The user will only have to click on the most convenient one.

Thus, if, for example, we need to calculate the total of a list of incomes and we write “Total” at the end of the column, Excel will recommend the sum formula. Of course, it will also perform the operation automatically. function, yes. It is only available in English and, we repeat, only in the web version of Excel.

Other news in Microsoft Excel

Microsoft has also included a couple of additional features that will save the user time when filling out spreadsheets. One of them is the call “Formula, for example.” This specifically allows Excel to suggest filling an entire column with a formula if it detects that the user is following a pattern, as shown in this example. The second feature is calledsuggested links” and allows you to automatically fix broken links to cloud books.

In the meantime, Excel for Windows has also received some cool features in its latest update. Currently you can add a keyboard shortcut to open the Power Query editor. In addition, a new IMAGE function has been added, which allows inserting images into cells and adding alt text. “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 in an Excel spreadsheet,” explains Microsoft. This last feature is also available in Excel for Mac.