Excel heed scratcher

Dirk Diggler · 14 Oct 2022 at 15:58

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! · 14 Oct 2022 at 16:01

Have you tried turning it off and on again?

Ogoshi · 14 Oct 2022 at 16:02

Have you frozen too many rows?

Participant · 14 Oct 2022 at 16:04

Alt-F4
Tab
Enter

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

dlockers · 14 Oct 2022 at 16:05

Ogoshi said:
Have you frozen too many rows?

Yeah I'd start with unfreeze panes.

GreatAuk · 14 Oct 2022 at 16:07

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 · 14 Oct 2022 at 16:56

A combo of grouped rows and frozen panes is my bet

Dirk Diggler · 15 Oct 2022 at 06:25

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 · 15 Oct 2022 at 10:47

Usually happens with frozen rows bro

Dirk Diggler · 15 Oct 2022 at 12:26

Bassmansam said:
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 · 15 Oct 2022 at 12:43

Hahaha nerds

Dirk Diggler · 21 Oct 2022 at 11:06

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

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

MooMoo444 · 21 Oct 2022 at 11:30

Dirk Diggler said:
Select all cells > Home > Format > Auto fit row height

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

Forbidden knowledge

dlockers · 21 Oct 2022 at 11:31

Delete that post right now!

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

GreatAuk · 21 Oct 2022 at 11:51

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 · 21 Oct 2022 at 13:42

Excel <> Database

dirtychinchilla · 21 Oct 2022 at 13:55

My heed hurts

Diddums · 21 Oct 2022 at 15:02

dirtychinchilla said:
My heed hurts

So take a pereceetemol

Dirk Diggler · 21 Oct 2022 at 15:15

dLockers said:
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 · 21 Oct 2022 at 15:16

swillsy said:
Excel <> Database

Access >*