Hi, I have a huge number of worksheets with a huge number of tabs which all scroll down to around 1,000,000 rows even though I only have around 5000 rows of data in each tab. I've googled and none of the proposed solutions work. The only thing that works is if I copy my data, create a new tab, then paste it in there. But I have to format it again etc and will take ages for hundreds of tabs. Is there a quicker way?

It's no good at the moment because it's extraordinarily difficult to get to a specific row eg if I try to get to the row 2000, I'm liable to go to 200,000 instead. And it's all jerky when I scroll down. And sometimes I get that ever circling circle and have to wait an eternity before excel does something.