Excel heed scratcher

[Dirk Diggler]

I have an Excel sheet with multiple tabs. One of the tabs won't scroll up and down with my mouse scroll wheel, I have to drag the scroll bar. All the other tabs are fine.

Help me, please.

 

[Yaayuh!]

Have you tried turning it off and on again?

 

[Ogoshi]

Have you frozen too many rows?

 

[Participant]

Alt-F4
Tab
Enter

That's the shortcut to fix it when the scrolly no worky

 

[Deleted User 298457]

Have you frozen too many rows?

Yeah I'd start with unfreeze panes.

 

[GreatAuk]

Weird. Does it have lots of macros running? Lots of hidden rows or columns?

What happens if you delete everything on the sheet - is it still un-wheell-scrollable?

What about if you copy everything onto a brand new fresh sheet - can you scroll in the new sheet?

 

[Pipe & Slippers]

A combo of grouped rows and frozen panes is my bet

 

[Dirk Diggler]

It's not a freeze frame issue, which I proved by adding a freeze frame and then removing.

I deleted all the rows and it still wouldn't scroll.

It's making me a bit

 

[Bassmansam]

Usually happens with frozen rows bro

 

[Dirk Diggler]

Usually happens with frozen rows bro

Ok.

All the rows move when I scroll by dragging the scroll bar, and when I look at the freeze panes section it doesn't display the option to unfreeze any panes.

Are frozen rows different?

 

[Diddums]

Hahaha nerds

 

[Dirk Diggler]

Select all cells > Home > Format > Auto fit row height

Deeply, deeply disappointing that The Forum didn't have this knowledge.

 

[MooMoo444]

Select all cells > Home > Format > Auto fit row height

Deeply, deeply disappointing that The Forum didn't have this knowledge.

Forbidden knowledge

 

[Deleted User 298457]

Delete that post right now!

This should just be marked as "resolved" and thread closed.

 

[GreatAuk]

Thanks for the solution, will store that knowledge away for the day 4 years from now when I'm trying to browse some humungous database someone's built in excel and not being able to wheel scroll will drive me uo the wall

 

[swillsy]

Excel <> Database

 

[dirtychinchilla]

My heed hurts

 

[Diddums]

My heed hurts

So take a pereceetemol

 

[Dirk Diggler]

Delete that post right now!

This should just be marked as "resolved" and thread closed.

If I'd said it was a column on the left that I wanted on the right of the sheet, the thread would be a 20 pager by now.

The art of the Geek is dead here. Dead I tells ye.


*Hings heed in dispair*

 

[sigma]

Excel <> Database

Access >*