Forum Discussion
right scroll bar is too high up spreadsheet
Kindly confirm if you can scroll down when you use your mouse and drag the right scroll wheel
yes that is not the issue its the positon its too high up when it should reflect where I am on on the sheet.
This sheet is what I inherited we have many behaving the same way.
As i said in my post the scroll bar part is too small I can't use it. Where it shows on my image is the last line of data in this 15,000-row sheet so it's rendered useless, do you know how I can rectify this?
The reason why I am asking, is because there are coloured sections on different rows and columns, and it's easier for me to drag the scroll bar up and down to find them quickly. This is what I can do easily on another sheet I created myself!
- Oh, I understand.
But if I get you right, the scroll works and can allow you to see any portion of the document that you would like to see, right? Trust you are good.
Based on the picture shared, it is somehow impossible to understand your point fully. Is it possible to show how this scroll works on the file you created having the same set of information? so we can compare the 2 instances.
Cheers
- I am not sure what it is that you can't understand?
« I had to manually select all the rows/columns, I don't know what the keyboard shortcut is for this. »
Select one cell with data, then press Ctrl+A. If your data is contiguous (i.e., no embedded fully-blank columns or fully-blank rows), that should suffice. That's for Excel on Windows; for Excel on Mac, the shortcut is probably Cmd+A.
The scroll bar reflects the current view's relative position within the used portion of the worksheet (you knew that), so it seems that someone, at some time, put data WAY down further (and possibly too far right, as well). To identify that situation, click in any cell and press Ctrl+End (Cmd+End on Mac?). Excel moves the selection to the cell for the bottom-most ever-used row and the rightmost ever-used column.
(An alternative to confirm that is to open the VBA Editor, open its Immediate window, and enter a statement such as "? Sheet1.UsedRange.Address" without the quotes.)
Typical deletion of rows and/or columns does not change that location. You could create a new worksheet, and copy only the desired cells to it. But one or more of the following techniques will likely work for you.- manual actions: How to reset used range in Excel - Business - Spiceworks Community
- code #1: Reset the used range - TIP, TRICKS & CODE OzGrid Free Excel
- code #2: ExcelExperts.com - VBA Tips Reset Used Range - YouTube
(If you use VBA code, you are not required to save it (in a macro-enabled workbook) after you are finished using the code. In fact, you probably can skip the use of procedures/macros and just execute either of those single-line statements in the VB Editor's Immediate window.)
