Scrolling down worksheet is slow

DougStroud

Well-known Member
Joined
Aug 16, 2005
Messages
2,966
Scrolling down my worksheet I experience different speeds. At the top of the worksheet the scroll speed is normal using the mouse wheel or dragging the scroll bar on the right hand margin.
But down a certain number of rows, the speed slows to a crawl using the same two methods until it reaches the end of this, whatever area, and then speeds up again to normal speed.
I am unable to determine either settings or formulas that would create this degredation in performance....

Thanks,

ds
 

Excel Facts

When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.

Asala42

Well-known Member
Joined
Feb 26, 2002
Messages
2,318
Sounds like excel is having a problem rendering something in that zone of rows (do you have any graphics or charts near that area?).

Do you suffer the same issue in any other files? Or is the issue just tied to one sheet on this particular workbook?

It may be worth a quick test to see if the scrolling is slow after doing an Edit/Clear Formats (or all) blanketed over the rows that appear to be the problem.
 

DougStroud

Well-known Member
Joined
Aug 16, 2005
Messages
2,966
No graphics are in this file.
There is conditional formatting.
No, this does not affect any other files, just this one.

I will test based on your suggestion. If any other ideas popup feel free to throw them my way.

thanks,
ds
 

Forum statistics

Threads
1,136,575
Messages
5,676,644
Members
419,636
Latest member
phownz

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top