Help! Cells to follow "Scrolling."Closed

Question

Hello!

This is the situation that I am facing. 

I have already freezed the required panes on a spreadsheet however I am trying to get a table to follow my scrolling up/down at the end of the spreadsheet. 
This table will show my lastest status of information which I'll need for decisions in changing the information on the right half of the spreadsheet. 
How can I create this table that follows my scrolling of the spreadsheet?

Thanks for your time in trying to advice my query.

Thanks!! 


Configuration: Windows 7 / Internet Explorer 8.0

TrowaD · Answer

Hi Stupidbear,

Excel provides two options for you.

Since I'm using a dutch version of excel I don't know the exact translations, but let me try.

On the top menu goto "window" (the one left of "help").
Here you will find the options: "divide" and "block header".
These options are nearly at the bottom of the menu, just above the windows you have opened.

Hopefully it's clear enough for you to understand where to look.

Best regards,
Trowa

Stupidbear · Answer

Hi Trowa,

Thanks for the reply but I'm currently running excel from 2010 which seems different.
Could you kindly advise if my request could be carried out in Excel 2010 and if so, how can I proceed to work on it.

Thanks for your time.

Help! Cells to follow "Scrolling."

2 responses

Similar discussions

Subscribe To Our Newsletter!