One of the most frustrating parts of using Microsoft Excel (opens in new tab) could finally be over thanks to a new update to the software.
Microsoft has revealed it will be bringing support for smoother scrolling to its Excel Desktop app, hopefully resulting in a much better user experience.
The spreadsheet software (opens in new tab) update should mean an end to accidentally snapping to random unwanted cells, or losing track of all your vital data in the middle of an important work task.
- Check out our list of the best productivity software (opens in new tab) available
- Here's our list of the best collaboration software (opens in new tab) out there
- We've built a list of the best office software (opens in new tab) on the market
At the moment, Excel struggles with smooth scrolling, as the software looks to automatically highlight the cell in the top-left of your spreadsheet - an issue Microsoft admits is frustrating, and not particularly easy to fix.
"Though you might think this is an easy fix, simply requiring the alteration of a few lines of code, there’s actually a lot more to it," noted Microsoft engineer Steve Kraynak in a blog post (opens in new tab) outlining the change.
"In fact, we learned that this change affects many different aspects of Excel, including freezing panes, resizing rows, cutting and pasting, filtering, cell styles, comments, dragging and filling, and more."
The new smoother scrolling update has two parts - firstly, making scrolling smoother when using either the mouse wheel or the scrollbars (with Microsoft noting that touch screen and touch pad already scrolled smoothly).
Secondly (and more excitingly) you can now stop scrolling partway through a row or column, with Excel no longer making you go any further than you want.
Microsoft notes that users can try out a number of new features thanks to the update, including dragging the scroll bar to see how they can scroll with precision and stop anywhere they like.
The feature is available now to Insiders on Windows with Beta Channel or Current Channel Preview with Version 2109 (Build 14430.20000) or later, and be available to all Microsoft 365 Subscribers within the next few months.
- Microsoft Office 2021 (opens in new tab) release date, pricing, features and everything else you need to know