Forum Discussion
right scroll bar is too high up spreadsheet
Hi,
I have a very long spreadsheet that we have finished editing - 15,000 rows it has several columns across. I have set the print area thinking it would help this problem but it hasn't, I had to manually select all the rows/columns, I don't know what the keyboard shortcut is for this.
Anyway, the scroll bar thing on the right-hand side is very high up the page rather than at the bottom of the document which is where I was expecting it to show. I cannot move that scroll bar to where I would like because the area is far too small obviously.
See the picture, this is where the end of the document is!
I hope this makes sense to everyone, it's really irritating that I cannot scroll through the document to move to through the sheet vertically.
How can I correct this problem?
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?
- Any help from anyone here?
