Solved

Scrolling an Excel Spreadsheet

Posted on 2014-09-03
2
177 Views
Last Modified: 2014-09-03
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
0
Comment
Question by:morinia
  • 2
2 Comments
 
LVL 27

Accepted Solution

by:
Glenn Ray earned 500 total points
ID: 40302077
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
 
LVL 27

Expert Comment

by:Glenn Ray
ID: 40302351
Glad I could help! :?

-Glenn
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now