creating scroll bar in excel

**sanlen** · 08-19-2010, 06:08 AM

Hi,

Could you please advice how to create scroll bar in excel 2003?

Thanks
sanlen

**dominicb** · 08-19-2010, 06:12 AM

Good morning sanlen

Originally Posted by sanlen

Could you please advice how to create scroll bar in excel 2003?

From the brevity of your post, it's not entirely clear what you are trying to achieve.

You will need to give a bit more info.

DominicB

**sanlen** · 08-19-2010, 06:48 AM

Hi,

i have data same as the file attached.

I want to scroll only the value between DATA1 and DATA19 by placing the scroll bar on the top.

Sorry for not giving the detail in the previouse post.

Best regards,
sanlen

**Andy Pope** · 08-19-2010, 07:31 AM

Your example file alone does not help explain what you are trying to achieve.

Can you explain your problem?

**sanlen** · 08-19-2010, 09:52 AM

Hi,

My purpose is that I want to keep column A to stay still, and as well as column V. Even how many columns i will add into my list (DATA20, DATA21, DATA22,..........DATA50), i want to use the scroll bar that i have created to move my columns around and keep column A & column V to stay freeze.

Thanks,
sanlen

**Andy Pope** · 08-19-2010, 10:00 AM

I created some dummy data to the right of the sheet.

Some scrollbar properties need to be set.

Min=1
Max=10
LinkedCell=A1

The formula in the static table is INDEX