Office|Office 365

Smooth Scrolling Comes to Excel for Windows

Have you ever been scrolling through a large Microsoft Excel spreadsheet and stopped because you came across some cells with important data and it whips right past you? Well, Microsoft Excel engineers have been working to enhance this aspect of Excel for a long time.

When they set out to ‘put the idea to code’ for this enhancement, they very quickly noticed that tiny changes they made to make scrolling easier affected countless other aspects of the program. So, they spent many many months, and the fruit of their labor is finally here for us all!

Microsoft has heard from many of you that scrolling issues are prevalent, especially on large spreadsheets with a lot of data to keep track of. The main engineering reason is that Excel automatically snapped to the top-left cell as you scrolled. Although you may think this would be an easy fix, as I said above, altering ‘a few lines of code’, can affect a whole lot more.

Here’s a partial list of what they found to be affected: freezing panes, cutting and pasting, filtering, resizing rows, cell styles, comments, dragging and filling, and much more!

Sponsored Content

Passwords Haven’t Disappeared Yet

123456. Qwerty. Iloveyou. No, these are not exercises for people who are brand new to typing. Shockingly, they are among the most common passwords that end users choose in 2021. Research has found that the average business user must manually type out, or copy/paste, the credentials to 154 websites per month. We repeatedly got one question that surprised us: “Why would I ever trust a third party with control of my network?

Smooth Scrolling is here!

How smooth scrolling works in Excel

When you’re scrolling in a sheet with very large or tall cells, the former way Excel snapped to the grid made it hard to view your data. Thanks to a lot of feedback and suggestions from end-users (feedback rocks!), they took it upon themselves to fix the issue by making the scrolling much smoother. There are two parts to what they updated:

  • First, it’s smoother during the scroll function using the mouse wheel or the scrollbars. (Using the touch screen and touch pad already scrolls smoothly)
  • Second, you can stop scrolling partway through a row or column. Excel won’t force you to go any further than you want.

Want to know more about smooth scrolling in Excel?

I will try to give you the ‘Cliff Notes’ version of the engineering explained in a recent blog post on the subject. Microsoft found two main types of issues because of not snapping to the edges and scrolling smoothly. One set dealt with how objects are positioned on the sheet. The other is related to how objects are displayed while scrolling.

Screenshot of a table in Excel showing the mouse is clicking on cell E5, but cell G5 becomes selected, due to an offset from column B being scrolled partway out of view, causing an “offset” which was not possible when Excel always snapped to the edge of a column.

Using your touch screen is similar. Excel calculates what should be in the place where you touched, and it always assumed the sheet would be snapped (to the upper left). If they scrolled partway through a row and tried to draw on the sheet, there would be a gap near the bottom of the sheet where Excel couldn’t draw anything.

This image shows that since row 1 is scrolled partway out of view, the “offset” caused a drawing problem near the bottom of the sheet. Drawing near the bottom of the sheet stopped working in an area the same height as the amount of row 1 which is out of view.

Remember that ‘partial’ list above detailing some of the features of Excel that were affected when the engineers and developers started work on this monumental task? Here’s a nice word cloud showing the full extent!

A word cloud diagram listing various aspects of Excel in different font sizes, colors, and angles. The largest words are “freeze panes”, “scrollbar”, “RTLSheet”, “PLV”, “data validation”, “edit cell”, and comments. There are other smaller words scattered around the larger words.

Feature availability

This new scrolling feature is available to Office Insiders on the Beta Channel or Current Channel (Preview) with version 2109 or higher (14430.20000). As Microsoft loves to point out, these features are rolled out gradually to make sure a large bug is not blasted out to 1 billion Office users at once. It is expected to be available to all Microsoft 365 subscribers by 1st quarter, 2022.

Related Topics:

BECOME A PETRI MEMBER:

Don't have a login but want to join the conversation? Sign up for a Petri Account

Register
Comments (0)

Leave a Reply