Scrolling an Excel Spreadsheet

Experts,

I have an interactive spreadsheet that allows you to click on columns A8 though A27 relative to what you want to see.  The spreadsheet goes down to Row 419.

Is there a way to freeze a1 through B27  and c7 to AB8 (headers)  and allow scrolling of a9: to AB419
moriniaAdvanced Analytics AnalystAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Glenn RayConnect With a Mentor Excel VBA DeveloperCommented:
Well, yes and no.

Yes, you could freeze panes, anchored at cell A9.  That would freeze rows 1:8.

No, because you're asking to simultaneously freeze A1:B27 and yet still allow scrolling of A9 onward, which is in the section you want to freeze.

We might need to see a screenshot at least.

-Glenn
0
 
Glenn RayExcel VBA DeveloperCommented:
Glad I could help! :?

-Glenn
0
All Courses

From novice to tech pro — start learning today.