It does not matter how fast I am scrolling. Is the workbook maximised? worth considering. At first I was scrolling down. In older versions of Excel, the description will be Comment and indicators. In Excel. Instructions in this article apply to Excel for Microsoft 365, Excel 2019, Excel 2016, Excel 2013, and Excel 2010. I know he hasn't lost any material, but I don't know how to restore/unhide the tabs and scroll bar. All the comments/notes will now be visible. Then I try selecting cell range using Shift+Up arrow. You can follow the question or vote as helpful, but you cannot reply to this thread. Click on the View tab and select the Arrange All option. It includes a set of programs that are used to attain some basic office tasks. 1) To tell the truth - I don't know. Since the issue is experienced on a particular file, I suggest you copy the content from problem Excel file, paste it into a new file and verify whether issue re-occurs. Can you help us restore the view to the way it was so he can see the worksheet tabs and horizontal scroll bar? Check if you are able to see any changes, Close and open the excel to see if the issue persists. So most likely as of now for me, it's that file only. Further, if I move it just one pixel, instead of jumping to the next screen of data, Excel will move to row 4500. In Excel 2016 the ribbon and menu bar are missing, but the Ribbon Display Options icon is not available to restore them, only the minimize, maximize and close icon are displayed in the top right corner. Scroll to the section for Display. Click OK. Solution 1: Enabling Scroll Bar. Hi SergSlim would it be possible for you to share the file with me. *** Email address is removed for privacy ***. Actually I just tried scrolling/selecting on another file with at least 300+ rows, and it works fine there. The Excel Options window will open. Scrolling issues are also present in IE11, though they are a bit different. Click on the File menu then Options. that was selected previously would not be selected anymore. This is true for all of the files - both the originals and Hello Serg, Just started recently. I'm not using Excel Online that much. And again using Shift+Up arrow try to select a range of cells. Is the operating system Windows 7? or F5 goto as an immediate work around. Both vertical and horizontal scroll bars have disappeared in an Excel 2010 worksheet.

For example I select range of cells: C91:E91, and then using Shift+UP arrow I try to select range of C21:E91, for example. Similar problem happens when I try to select multiple cells using Shift+Up/Down arrows. Hope it helps. Excel for Microsoft 365, Excel 2019, Excel 2016, Excel 2013, Excel 2010 Excel 2007 By default, a horizontal and vertical scroll bar are displayed in an Excel workbook so that you can scroll through the data in its worksheets. Select Advanced from the sidebar. For that: Open Excel and launch the spreadsheet for which the scroll is missing.

You can follow the question or vote as helpful, but you cannot reply to this thread. The horizontal scroll bar may be hiding the tabs because it is set to fill the whole of the scroll bar area, in which case it my not even look like a scroll bar. You can notice a strange jump on 27th second. You may refer to the thread below which discusses about the same issue and check if it helps: http://answers.microsoft.com/en-us/office/forum/office_2007-excel/worksheet-tabs-and-horizontal-scroll-bar/bf3717d1-9f20-48d0-9d4c-e542e3506e73. For example I am scrolling a sheet down using wheel of my mouse, at the point when top visible row is 30, when I keep scrolling down - it jumps to 9th row. It occurs in both cases - when I'm editing it on my own, or when we do it together.

Since the issue is experienced on a particular file, I suggest you copy the content from problem Excel file, paste it into a new file and verify whether issue re-occurs. From the Advanced section, scroll to the Display sub-section and select Indicators and notes, and comments on hover. Now click on the Tiled and select OK. There have been some issues (I am not claiming this is one but ...) After some rows were selected as expected, something strange would happen, and selection would jump to some random place, and everything