I am using Excel 2010 & having an issue recently when I highlight a cell and then hold shift and page down (or shift and end), the cells in the spreadsheet continue to get highlighted, but the spreadsheet only displays the top rows. This is making it difficult when I want only a certain amount of the data to be highlighted, to know how far down the data set I am since I cannot see which row I'm on. I know it's not being affected by the split panes or freeze panes options, since it happens to all workbooks, even new ones. I'm assuming that there is some option in Excel itself that is causing this. Does anyone know how to fix it?
Thanks.
Thanks.