Adding a scroll Bar to a worksheet

**Macdave_19** · 11-15-2007, 10:49 AM

Hi guys and Girls,

Just wondered,

i have a long table, i want to be able to freeze the headings and totals and then add a scroll bar so that you can scroll the middle and see the breakdown of the different criteria. is this possible and how would i go about it please.

Cheers for reading my thread guys!!

**Macdave_19** · 11-15-2007, 10:56 AM

Heres an example file

**stevekirk** · 11-15-2007, 11:03 AM

hi,

file not attached but you can select the row you want to spilt or freeze
then goto <window <slpit then you can scroll down from that row

hope this helps
steve

**Macdave_19** · 11-15-2007, 11:08 AM

Yeah i know that buddy and appreciate the advice however i want to add a scroll bar to the worksheet so i can minimise the size of the table as i will have many table on the sheet!!