Solved

Scrolling an Excel Spreadsheet

Posted on 2014-09-03
2
193 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

738 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