Keeping columns C - AB static in Excel while I scroll down columns A - B


I have calculated values in Columns C - AB based on which value is selected in column A11 - A107.   The problem is when I scroll down pass A35, I can no longer see columns C8 - M19.  

Currently I am using sumifs to calculate the columns.  Is there a way to use sumifs if I put columns A11 in a list and use a drop down in Excel
moriniaAdvanced Analytics AnalystAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Saurabh Singh TeotiaCommented:
Can you post your sample file with what you are trying to do..

moriniaAdvanced Analytics AnalystAuthor Commented:

I have attached the file.  I have removed most of the respective data, but it is the layout that I want you to see.  After scrolling down column "A" to about A21, you can no longer see the other columns.

I need to lock from column C on or if possible use a drop down list that the tin can be selected.

Currently the column you click on is used.  With a list, am I able to select the value?
Saurabh Singh TeotiaCommented:
Look at your example i'm confused about how does the tin number is related to product??

Can you help me understand the above or can you help me understand what result you want to see when you do a particular action...

In additional you can try selecting row-21 and then go to view-->freeze panes..that will freeze the rows to row-21 and above irrespective how much down you go...

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
moriniaAdvanced Analytics AnalystAuthor Commented:
The freeze panes worked perfectly.  

Because of the sensitivity of the data, I removed all relative data.  If the data had been in the spreadsheet.  When you click on a respective "TIN' in columns A11 - A107,  the sumfis which were in columns R - AB which have been removed calculate the values that populate the columns in C12 - M12.

This is driven by the macro.  The macro that is in the program now, only goes to A33 because the tab that was copied only wen to "A33".  I have fixed that macro.

I hope this gives you a better understanding of what I was doing.

Thanks the solution to freeze the panes worked.  Sorry for the confusion by removing so much of the pertinent data.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.