Excel has a new feature for speeding up spreadsheets

Microsoft Excel spreadsheets can contain thousands of cells for storing data, which can slow down your PC even if there is no visible data in many of the cells. Fortunately, Microsoft is rolling out a new feature to improve spreadsheet performance.

Microsoft mentioned in a recent blog post that empty cells with leftover formatting and style information can often slow performance and increase file size. The company said, “we have observed that over time a workbook may accumulate cells that have no data, but still contain hidden information that has little or no further use. These cells may have had data and formatting in the beginning, but now they have no data but still take up space because they contain formatting. “

Microsoft’s first attempt to solve this is a new “Check Performance” feature, accessible from the Check tab in Excel Online. It looks for empty cells that still contain formatting data, such as a fill color or custom text alignment, and gives you a button to clear the data. Microsoft’s example used a spreadsheet with more than a million empty cells, with the file size decreasing from 3.14 MB to 17.5 kB. Importantly, the function does not run automatically, so you don’t have to worry about losing formatting you want to use later.

Check Performance is now rolling out to Excel Online for paid Microsoft 365 subscribers, and Microsoft says it has “upcoming plans” to bring the feature to Excel for Windows and Mac. The company is also investigating other common problems that can be added to the detection for Check Performance.

Source: howtogeek

Certified Office 365 experts

De oplossingen van Microsoft zijn al decennia lang toonaangevend als het gaat om productiviteit, presentatie en e-mail. Voor Office 365 zijn deze bekende producten doorontwikkeld om uw organisatie sneller en efficiënter te laten werken. 

Microsoft biedt u naast de oplossingen uit de Microsoft 365 suite de cloudversies van Microsoft Exchange Online, Microsoft SharePoint Online en Microsoft Teams. Deze diensten werken naadloos samen en zorgen voor maximaal gebruiksgemak op zowel pc’s, tablets, smartphones en browsers.

We leveren de nodige expertise om over deze diensten te kunnen beschikken en daarnaast de bedrijfsprocessen door middel van software te optimaliseren.