#Side scroll bar missing in excel code#
#Side scroll bar missing in excel windows#

In fact, we learned that this change impacted many things in Excel. It may seem straightforward to smooth things out, but we knew there could be some side effects to not snapping.

#Side scroll bar missing in excel code#

After all, it should be a simple matter of removing a few lines of code that causes the sheet to snap. Many whoРІР‚в„ўve asked for Excel to stop snapping when youРІР‚в„ўre trying to scroll just a little have also asked why this wasnРІР‚в„ўt done a long time ago. It provides an interesting peek at the complexities of making even small changes to Excel, which has been around for decades and has so many features.

Drag the scroll bar to see that you can scroll with precision and you can stop anywhere you like.Р”Р„ll you need to know is that Excel will scroll better, but we wanted to share more about the story of this improvement.

Increase the height on some rows in your spreadsheet and scroll using your mouse wheel or touch pad to see that you can stop partway through a row, and avoid snapping to the top.

#Side scroll bar missing in excel windows#

If your Windows setting is to move 1 line for each click of the scroll wheel, it will move by line of text rather than by 1 row of your worksheet.

If you donРІР‚в„ўt have a РІР‚СљprecisionРІР‚Сњ mouse or touch pad, each movement will be based on the height of one line of text. * Depending on the mouse or touch pad youРІР‚в„ўre using, you may not be able to scroll one pixel at a time. Second, and most importantly, you can stop scrolling partway through a row or column, and Excel wonРІР‚в„ўt force you to go any further than you want.First, itРІР‚в„ўs smoother during the scroll when using either the mouse wheel* or the scrollbars (touch screen and touch pad already scrolled smoothly).We fixed the issue by making the scrolling much smoother-there are 2 parts to this update. Many of you requested that we improve the way this works, and thatРІР‚в„ўs just what weРІР‚в„ўve done. When youРІР‚в„ўre scrolling in a sheet with very large cells, the way Excel for Windows snapped to the grid made it hard to view your data. The bold text in row 2 says 'We're happy to anounce New in Excel for Windows: Smooth Scrolling'. Short video showing an Excel sheet that scrolls and stops partway through row 2, then scrolls to show row 1. 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.

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. The main reason for this issue is that Excel automatically snapped to the top-left cell as you scrolled. WeРІР‚в„ўve heard from many of you that it can be difficult to scroll through a worksheet with large cells and view all the data.