Excel 2007 Scroll-bar going to end of sheet
August 25, 2013 3:00 PM Subscribe
I have an excel 2007 spreadsheet in which the vertical scrollbar covers the whole 1,000,000 rows i.e pressing ctrl - end takes me to row 1,048,576. I would like it to only scroll to the end of my data.
posted by mataboy to computers & internet (9 answers total)
Clearing all the rows below my data does nothing.
I've tried changing the scroll area but that just stopped it going all the way down the bar was the same size
Last time this happened I just copy pasted to a new sheet but I don't want to have to update all the formulas again
Thanks in advance for your help.