“In an Excel table, you can move and resize cells, sort and filter, and work with images,” Microsoft says. “Your pictures can now be a part of the worksheet instead of just floating on top. Also, a new function called “ IMAGE” is added so that images can be put into cells and an alternative text can be added. The Power Query editor can now be opened with a keyboard shortcut. In the same way, the latest update to Microsoft Excel for Windows adds some cool new features. It lets you fix broken links to cloud workbooks without having to do anything.

The second feature is called “ Suggested Links,“. This one, in particular, tells Excel to suggest filling the whole column with a formula if it sees that the user is following a pattern. The “ Formula for example” is one of them. Microsoft has also added a couple of functions that will save users time when filling out spreadsheets. More from us: How to fix ‘Your organization’s data cannot be pasted here’ error What is changing in Microsoft Excel? Yes, the function is only available in English and only in the web version of Excel. The operation will also be done automatically, of course. So, if we need to figure out the total of a list of incomes and write “ Total” at the end of the column, Excel will suggest the sum formula. The user will only need to click on the one that is easiest. To do this, the creator or editor of that spreadsheet only needs to write the “ =” sign in the cell or in the formula bar at the top of the screen.Įxcel will show you the most useful options, which could be sum, average, count, numerical count, minimum, and maximum. The “Formula Suggestions” function lets Excel suggest a formula based on the rest of the information that the user has already entered into the cell, column, or row.

Excel new window