The most bizarre behaviour in Excel with frozen windows

FenceFurniture

New Member
Joined
Apr 24, 2016
Messages
31
CAVEAT: I have a wide reputation for being the King of Weird Inexplicable Crap in matters of all kinds.
This is no exception. :unsure:

I am no longer able to successfully freeze my columns/rows. (been going on for about 6 months or more)

There is one particular sheet that I use all the time, and I freeze cell F3. It should look like this:
Music stable.JPG

The oval shapes are all macro buttons. That all works as it should....until I do ANY copy and paste. When I use either the vertical or horizontal scroll bar, what happens then is that the areas above or to the left of the frozen area jumps around like it has the worst case of St Vitus Dance. It will actually stop in place when I stop scrolling, and that looks like this:

Jitterbug.JPG

As you can see, row 1 is fully visible, but the content is not! Whenever I scroll down or up by dragging the bar, AND ONLY by dragging the bar, the content in rows 1 and 2 does a constant jitterbug up and down until I stop scrolling - and will be anywhere out of place - never in the right place.

At the same time, the content below the line that should show as scrolling through....stays still so that I don't know where to scroll to!

Using the arrows above or below the scroll bar does not create any problem.

This became so much if a pita that I actually wrote a macro called Freezer (magenta buttons in the first screen capture) - it unfreezes and refreezes the pane when I need to (after any copy & paste).



I'll wager that nobody has ever seen this behaviour before. I REALLY don't want to re-install Excel (would that fix it?) because I have customised things so very much, and can't remember A) what I've customised or B) how to do it again. I'm ok at doing this stuff when I'm on a roll, but then it leaves my head almost completely.
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

FenceFurniture

New Member
Joined
Apr 24, 2016
Messages
31
The other thing I noticed with this Excel version (right from the very start in 2016) is that the vertical scroll bar is "sticky" and jumpy - it doesn't scroll smoothly, and there is an annoying delay. It seems to scroll in batches or blocks of rows. Anyone else got that?
 

FenceFurniture

New Member
Joined
Apr 24, 2016
Messages
31
Maybe it's a time-of-year thing, or maybe this is just too weird and nobody knows what to say?
 

FenceFurniture

New Member
Joined
Apr 24, 2016
Messages
31
I have captured this in a screenshot video which is a 1.0MB MP4. Not sure if I can upload vids here though.....nope.
 

Watch MrExcel Video

Forum statistics

Threads
1,127,758
Messages
5,626,686
Members
416,200
Latest member
Pulsar3000

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