Worksheet datatable won't scroll

[pecoemla]

I'm totally confused. I have a datatable with data from 2010 and 2011. The worksheet will not scroll at all. It looks like it is scrolling at the side where the scroll bar is but the worksheet does not move. I can move the tab up or down but the page/worksheet doesn't move at all. If I activate the filter and select only the year 2011 in the drop down box for the Date column, it scrolls fine. But if I check "All Dates" or just "2010" from the drop down box on the Date column the page/worksheet will not scroll. I can select a certain month from the drop down box for 2010 and it will show the data (about 25 rows) but I cannot scroll. When I have just 2011 selected from the filter it all works fine. I'm not real swift with Excel. It was working fine until today. I don't have a clue what I did to cause this. Help!

 

[Akashwani]

Hi,

Welcome to MrExcel.

I can't answer you questions as I've not experienced what you are describing, but, do you have a "Freeze Frame" on your sheet?
Click between the 1 & A in the top left corner of your sheet, copy and paste your data to a new worksheet and see if you have the same problem.

Sorry that I couldn't be more helpful.

Ak

 

[Gardoglee]

Thanks for the "Unfreeze Panes" suggestion. I was also having the same problem and that solved it. Now to figure out how I unintentionally froze the panes...

 

[DataAnalyst]

Thanks for the "Unfreeze Panes" suggestion. I was also having the same problem and that solved it. Now to figure out how I unintentionally froze the panes...

Thanks, I just had this happen for the first time in 10 years of using Excel. I thought I had frozen the top row of headers but found I hadn't on a duplicate sheet... I think I had clicked Freeze Panes with the top left cell A1 selected and that's what froze the sheet. Thanks again for this thread, I would have been pulling my hair out trying to fix it!