Remove jammers & protect against malware: These are the latest Excel features
March 29, 2023
0
At the end of the month, Microsoft will review the new features it has introduced to Excel. This is the overview for March. Microsoft is constantly adding new
At the end of the month, Microsoft will review the new features it has introduced to Excel. This is the overview for March.
Microsoft is constantly adding new features to the 365 applications. To keep track, the software giant once again lists all the new features that have been added to Excel this month. Availability may vary by web version, Windows and/or Mac.
Remove Unwanted Cells (Web)
Formatted cells can negatively impact productivity. They make the workbooks heavier, which negatively affects the speed of work. In particular, unintentionally formatted cells are more likely to be lost than rich. From check performance You can spot and remove jammers before you get further lost.
The feature appears when you open a spreadsheet from SharePoint or OneDrive. click on Check over and do a check. Check Performance optimizes the content and layout of cells within the selected domain. This reduces the file size, resulting in a smoother workflow. The feature is currently only available for the web version.
Source: microsoft
Formula First Aid (Web)
Learning to work with formulas is essential for anyone using Excel. Finding the right formula and entering it correctly has given many users nightmares. formula argument helphelps you set up the formula and fill in all the parameters. That way, you no longer have to look for external resources when you’re at your wit’s end. To make it even easier, Excel now also offers automatic formula suggestions.
Drag Queries (Web)
Microsoft Excel adds drag and drop functionality to the query pane. This makes it easier to organize your saved queries and to drag and drop between different files.
Protection against malware (Windows)
Microsoft is tightening the security of the Windows app. Attackers can use add-ins to inject malware into your workbooks. Excel counters this by automatically blocking XXL add-ins from now on. If Excel has detected a potentially suspicious add-in, a pop-up window will appear. After that, you need to decide whether you want to continue blocking or allowing the add-in.
Divide and conquer (Windows & Mac)
Do you work with colleagues in the same folder? Then you can divide the work up better from now on. Add a comment to a cell and tag a colleague. By the Assign toField notifies that person that they have been assigned a task in the file.
As an experienced journalist and author, Mary has been reporting on the latest news and trends for over 5 years. With a passion for uncovering the stories behind the headlines, Mary has earned a reputation as a trusted voice in the world of journalism. Her writing style is insightful, engaging and thought-provoking, as she takes a deep dive into the most pressing issues of our time.